Array
(
[ID] => 12155
[post_author] => 4
[post_date] => 2018-10-29 01:19:04
[post_date_gmt] => 2018-10-29 01:19:04
[post_content] => Above it all and sometimes in the fog, Diamond Heights has some great mid-century homes in the neighborhood overlooking Noe Valley. Diamond Heights Village dominates the neighborhood with nearly 400 condos, some of which have incredible downtown and Bay views. You'll need a car or quads of steel to get around in this 'hood.
[post_title] => Diamond Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => diamond-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:32:42
[post_modified_gmt] => 2024-04-11 15:32:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12155
[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, 42 Cameo Way, San Francisco, CA, 94131
ffd_mls_id, 421544027
ffd_salesforce_id, a0E1I00000USN9aUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 42 Cameo Way, San Francisco, CA, 94131
pba__address_pb__c, 42 Cameo Way, San Francisco, CA, 94131
agent_only_remarks__c, Transparent pricing. Very easy to show, text or call Alex for quickest response. 415-609-0914. Please follow NAR and SFAR COVID-19 showing guidelines. Disclosures linked MLS. All offers on SFAR purchase agreement. Escrow opened w/ Chicago Title - 1929 Market St, SF.
appliances__c, Dishwasher;Microwave;Free Standing Gas Range
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1962
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-06-27
cooling__c, None
ffd_createddate, 2021-04-30T17:47:18.000+0000
days_on_market__c, 810
dom__c, 82
ffd_description_pb, Perched on quiet Cameo Way right above Noe Valley, this renovated Mid Century Gem offers walls of glass opening up to stunning sunset views over Glen Canyon Park. The main level features a spacious and functional 3 bd 2 ba layout with a remodeled open kitchen and huge great room with fireplace and views. On the lower level is a large family room perfect for entertaining and a guest suite / office which adds flexibility, both opening to a huge view deck. Large windows and numerous skylights flood the home with light. A garage with a laundry area, and another covered parking spot provide for 2 car parking and storage as well as further expansion potential. A neighborhood of single-family homes along curved, quiet, residential streets with all serenity and natural charm of Marin, yet centrally located, close to everything Diamond Heights and the city have to offer, the home is close to shopping, trails at Glen Canyon Park, BART/MUNI transit as well as easy freeway access. #sunsetsofcameo
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter;Gas Log
42 Cameo Way, San Francisco, CA, 94131 - Property Description
Perched on quiet Cameo Way right above Noe Valley, this renovated Mid Century Gem offers walls of glass opening up to stunning sunset views over Glen Canyon Park. The main level features a spacious and functional 3 bd 2 ba layout with a remodeled open kitchen and huge great room with fireplace and views. On the lower level is a large family room perfect for entertaining and a guest suite / office which adds flexibility, both opening to a huge view deck. Large windows and numerous skylights flood the home with light. A garage with a laundry area, and another covered parking spot provide for 2 car parking and storage as well as further expansion potential. A neighborhood of single-family homes along curved, quiet, residential streets with all serenity and natural charm of Marin, yet centrally located, close to everything Diamond Heights and the city have to offer, the home is close to shopping, trails at Glen Canyon Park, BART/MUNI transit as well as easy freeway access. #sunsetsofcameo
