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, 1747739938
ffd_listing_title, 45 Turquoise Way, San Francisco, CA, 94131
ffd_mls_id, 425033969
ffd_salesforce_id, a0EUd000004qFtjMAE
num_of_fireplaces__c, 1
num_of_rooms__c, 11
of_units__c, 0
pba__address_pb__c, 45 Turquoise Way, San Francisco, CA, 94131
address2__c, 45 Turquoise Way, San Francisco, CA, 94131
agent_only_remarks__c, Price Reduced! $1000 for a fully redone home. Great property. Go Show and sell this amazing home! Supra lockbox on gas pipe in side yard. Use key card by placing on lock face until you hear it open, PLEASE leave lights ON. On way out it will lock itself. Disclosures: https://app.disclosures.io/link/45-Turquoise-Way-0yn76gy5
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Wine Refrigerator;Self/Cont Clean Oven;Built-In Refrigerator;Gas Cook Top;Plumbed For Ice Maker;Built-In Electric Oven;Warming Drawer;Gas Plumbed
ffd_description_pb, Welcome to 45 Turquoise Way a stunningly renovated mid-century modern home nestled on one of Diamond Heights' most charming streets, right on the edge of Glen Canyon Park. This 4BD/4.5BA residence offers a perfect blend of modern style and indoor-outdoor living. The open-concept main level features an eco-friendly fireplace, designer kitchen with custom cabinetry, built-in coffee maker, steam oven, and sleek stone countertops. Floor-to-ceiling sliding glass doors lead to a spacious redwood deck and tiered backyard, ideal for entertaining or relaxing in nature. The upper level includes a serene primary suite with vaulted ceilings and spa-inspired finishes, plus three additional bedrooms and laundry. The lower level offers flexible space with a game room, guest suite or office, wet bar, full bath, second laundry area, and storage. Two garages, EV charging, and a location near shops, transit, and trails make this a truly exceptional San Francisco home.
45 Turquoise Way, San Francisco, CA, 94131 - Property Description
Welcome to 45 Turquoise Way a stunningly renovated mid-century modern home nestled on one of Diamond Heights' most charming streets, right on the edge of Glen Canyon Park. This 4BD/4.5BA residence offers a perfect blend of modern style and indoor-outdoor living. The open-concept main level features an eco-friendly fireplace, designer kitchen with custom cabinetry, built-in coffee maker, steam oven, and sleek stone countertops. Floor-to-ceiling sliding glass doors lead to a spacious redwood deck and tiered backyard, ideal for entertaining or relaxing in nature. The upper level includes a serene primary suite with vaulted ceilings and spa-inspired finishes, plus three additional bedrooms and laundry. The lower level offers flexible space with a game room, guest suite or office, wet bar, full bath, second laundry area, and storage. Two garages, EV charging, and a location near shops, transit, and trails make this a truly exceptional San Francisco home.
Appliances: Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Wine Refrigerator;Self/Cont Clean Oven;Built-In Refrigerator;Gas Cook Top;Plumbed For Ice Maker;Built-In Electric Oven;Warming Drawer;Gas Plumbed
