Array
(
[ID] => 12175
[post_author] => 4
[post_date] => 2018-10-30 00:43:30
[post_date_gmt] => 2018-10-30 00:43:30
[post_content] => Mention Midtown Terrace to many San Franciscans and you’ll be met with a quizzical gaze. Where is it? What is it? It’s a mid-century neighborhood on the west side of Twin Peaks. Think single-family homes, fully detached, with both front and rear yards, lots of green space, and peace and quiet.
[post_title] => Midtown Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => midtown-terrace-2
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:45:03
[post_modified_gmt] => 2022-12-14 11:45:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12175
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title 87 Aquavista Way, San Francisco, CA, 94131
ffd_mls_id 494107
ffd_salesforce_id a0E1I00000QnsdjUAB
num_of_fireplaces__c 1
num_of_rooms__c 6
of_units__c 0
address2__c 87 Aquavista Way, San Francisco, CA, 94131
pba__address_pb__c 87 Aquavista Way, San Francisco, CA, 94131
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 3
year_build_text__c 1956
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
ffd_createddate 2020-01-24T18:45:36.000+0000
days_on_market__c 1000
dom__c 6
ffd_description_pb Centrally located, 87 Aquavista has everything you and your family are dreaming of. This spacious, fully detached Mid Century Modern has been elegantly updated while maintaining its charming beauty of yesteryear. Bursting with natural sunlight, this bright 3 bedroom and 3 bath home boasts classic hardwood oak floors throughout, crown molding, skylight and cozy fireplace. The tasteful chef's kitchen with stainless steel applicances , sleek countertops and subway tiles, opens up to a fabulous dining area. Downstairs you will find a generous and versatile bonus room, which can be used as a family room, game and rec room, movie theater, kids playroom and so much more! In addition, there is a full bathroom. Enjoy outdoor entertainment in the low-maintenance backyard. 2 Car Attached Garage w/ Interior Access and storage space. Close to Molly Stone's, Starbucks, CVS Pharmacy, West Portal, Noe Valley and the Castro.
Centrally located, 87 Aquavista has everything you and your family are dreaming of. This spacious, fully detached Mid Century Modern has been elegantly updated while maintaining its charming beauty of yesteryear. Bursting with natural sunlight, this bright 3 bedroom and 3 bath home boasts classic hardwood oak floors throughout, crown molding, skylight and cozy fireplace. The tasteful chef's kitchen with stainless steel applicances , sleek countertops and subway tiles, opens up to a fabulous dining area. Downstairs you will find a generous and versatile bonus room, which can be used as a family room, game and rec room, movie theater, kids playroom and so much more! In addition, there is a full bathroom. Enjoy outdoor entertainment in the low-maintenance backyard. 2 Car Attached Garage w/ Interior Access and storage space. Close to Molly Stone's, Starbucks, CVS Pharmacy, West Portal, Noe Valley and the Castro.
