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-11-14 12:28:52
[post_modified_gmt] => 2024-11-14 20:28:52
[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
(
)
)
_yoast_indexnow_last_ping, 1735680282
ffd_listing_title, 8 Turquoise Way, San Francisco, CA, 94131
ffd_mls_id, 423910835
ffd_salesforce_id, a0E8W00000dTNPoUAO
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 8 Turquoise Way, San Francisco, CA, 94131
pba__address_pb__c, 8 Turquoise Way, San Francisco, CA, 94131
agent_only_remarks__c, Call Mike to show and for information regarding disclosures and offers. 415-308-4281.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Oven;Double Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over;Marble
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1964
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bernard Katzmann
pba__contingentdate__c, 2023-10-03
ffd_createddate, 2023-09-21T14:46:30.000+0000
days_on_market__c, 467
dom__c, 18
ffd_description_pb, Beautiful mid-century home on an oversized, extra wide lot. The vaulted entry foyer leads to a grand living and dining room features a stunning modern gas fireplace with black granite surround, contemporary lighting, and floor to ceiling windows. Sliding glass door leads to the full-width rear deck with sweeping views over Glen Canyon. Spacious eat-in chef's kitchen boasts granite counters, custom modern cabinetry with under cabinet lighting and modern stainless appliances, including double Bosch ovens, 5-burner Thermador gas cooktop and vent hood, JennAir 3-door refrigerator/freezer, and Bosch dish-washer. Floor to ceiling glass sliders from the kitchen open onto the expansive front deck, ideal for barbeques and outdoor entertaining. The home boasts a grand primary bedroom with en-suite bathroom and two additional bedrooms and a spa-like second bath. 2 car side by side garage with storage. Large lot with endless potential for the creative gardener. Prime Diamond Heights location surrounded by greenery and a peaceful street abuts Glen Canyon Park hiking and open space, playground, tennis courts, baseball fields, and a recreation center/ gym and close to Diamond Heights, Glen Park and Noe Valley stores and restaurants, transportation and freeways. Some photos may be altered/edited
8 Turquoise Way, San Francisco, CA, 94131 - Property Description
Beautiful mid-century home on an oversized, extra wide lot. The vaulted entry foyer leads to a grand living and dining room features a stunning modern gas fireplace with black granite surround, contemporary lighting, and floor to ceiling windows. Sliding glass door leads to the full-width rear deck with sweeping views over Glen Canyon. Spacious eat-in chef's kitchen boasts granite counters, custom modern cabinetry with under cabinet lighting and modern stainless appliances, including double Bosch ovens, 5-burner Thermador gas cooktop and vent hood, JennAir 3-door refrigerator/freezer, and Bosch dish-washer. Floor to ceiling glass sliders from the kitchen open onto the expansive front deck, ideal for barbeques and outdoor entertaining. The home boasts a grand primary bedroom with en-suite bathroom and two additional bedrooms and a spa-like second bath. 2 car side by side garage with storage. Large lot with endless potential for the creative gardener. Prime Diamond Heights location surrounded by greenery and a peaceful street abuts Glen Canyon Park hiking and open space, playground, tennis courts, baseball fields, and a recreation center/ gym and close to Diamond Heights, Glen Park and Noe Valley stores and restaurants, transportation and freeways. Some photos may be altered/edited
