Wonderful location! #4 definitely the best. Would come again despite the fact that I might not of booked this unit once I found out the higher than average pet fee of $50/night (even for small dog) which is not disclosed until after you book. Regardless, it's a very nice unit and a very affordable nightly rate for the location.
As other reviews mention, parking is quite limited in the area but you will pretty easily find a spot you could leave your car for a day or more a few blocks away. No car needed during your stay unless you wanted to leave the area but no need as far as eating and entertainment go. There's also 15min parking on Prospect so you can unload/load. You will see mentioned that the unit is loud between the busy area and morning trash pickup. We used our noise machine that we normally sleep with and had no issue with it.
If you bring your dog, make sure to check out the dog beach in Ocean Beach about a 20 min drive that's well worth it and can also provide additional mexican food options.