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,1800-01-01
ffd_createddate,2023-09-21T14:46:30.000+0000
days_on_market__c,0
dom__c,0
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
district__c,SF District 4
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard;Partial
fireplace_features__c,Living Room;Gas Starter
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Central;Gas
interior_features__c,Formal Entry;Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate,2023-09-21T20:46:55.000+0000
pba__latitude_pb__c,37.745687
pba__latitude_property__c,37.745687
laundry_features__c,Laundry Closet;Washer Included;Dryer Included
listed_date__c,2023-06-09
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Michael
pba__listing_agent_lastname__c,Shaw
listing_agent_mls_id__c,800323
ffd_listingagentname,Michael H Shaw
listing_agent_number__c,800323
listing_co_agent_mls_id__c,263622
listing_co_agent_number__c,263622
listing_co_office_mls_id__c,VANG03
listing_co_office_name__c,Vanguard Properties
listing_co_office_number__c,1228
listing_office_mls_id__c,VANG03
listing_office_name__c,Vanguard Properties
listing_office_number__c,1228
pba__listingprice_pb__c,1750000
pba__listingtype__c,Sale
pba__listing_website__c,https://youtu.be/CL2mIpyMAk0
pba__longitude_pb__c,-122.446877
mls_id__c,423910835
main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c,Shower Stall(s);Marble;Stone
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2023-09-21
open_house_end__c,2023-09-23T16:00:00.000+0000
open_house_start__c,2023-09-23T13:00:00.000+0000
original_price__c,1750000
overall_days_on_market__c,-81712
parking_access__c,Side by Side
parking_features__c,Attached,Side-by-Side
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Deck
pba__pendingdate__c,1800-01-01
possible_bedrooms__c,0
pba__pricechangedat__c,1800-01-01T00:00:00.000+0000
price_per_square_foot__c,1074.28
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000dTNPoUAO
room_type__c,Kitchen;Living Room;Baths Other;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_number__c,0
selling_co_agent_number__c,0
selling_co_office_number__c,0
pba__status__c,Active
pba__totalarea_pb__c,1629
size__c,1629
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Turquoise
subdist__c,Diamond Heights
ffd_name,8 Turquoise Way, San Francisco, CA, 94131
view__c,Park;Panoramic;Garden/Greenbelt;Ridge
website_property_type__c,Single Family Home
window_features__c,Dual Pane Partial
pba__yearbuilt_pb__c,1964
pba__postalcode_pb__c,94131
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530680589-1.jpg
