Mellow Yellow is a great location. Easy access to the beach due to a lot that has not been built on - when lot is finished, may be just a little more walk to either beachwalk piers.
Note that the house has no elevator, so hauling groceries to third floor can be exhausting - give the job to the kids.
If you like to cook, you will want to bring your own cooking utensils and cookware - the utensils at the house are quite used and cheap. if you need a big saute pan of 10" or more bring your own. This info would have been helpful before we got here. The dishwasher and upstairs stack washer/dryer have seen their days. Wash/Dry can wake up the house and the dishwasher is in desparate need of new utensil holder as well as bottom rack. Furniture in living ares is worn and needs to also be replaced. On bottom floor, good storage and new washer/dryer combo there, works well. Would have been nice to have access to a vaccum versus a broom - lots of sand gets into the house. The bedrooms were quite comfy and the b'rooms well done. Nice big table for meals and plenty of bar stools in kitchen, good size pantry, fridge is double door i think 23 cu ft,
For the price & location house is well worth it. Be aware if you bring more than three cars, parking is going to be an issue, the picture looks like there is more places to park than really is, street is narrow. Road deadends around the corner which is nice, reduces traffic flow in the neighborhood.