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

ffd_listing_title,255 Red Rock Way #103H, San Francisco, CA, 94131

ffd_mls_id,423909030

ffd_salesforce_id,a0E8W00000dTLl2UAG

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,396

address2__c,255 Red Rock Way #103H, San Francisco, CA, 94131

pba__address_pb__c,255 Red Rock Way #103H, San Francisco, CA, 94131

agent_only_remarks__c,No showings until Sunday Open House on 9/24. Please do not text me, use email.

appliances__c,Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-21T01:46:48.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Here you will find an exceptional combination of being away from the crowds, but near to everything. This spacious unit configuration has a bonus size living room and a huge outdoor patio. You are in a secluded corner of a big amenity complex featuring a heated swimming pool, clubhouse, weight room billiard room, spa and sauna. Steps away are all sorts of public transportation; also, there is access by road to all points in San Francisco, and the freeways are just minutes away. Within your own unit you will find freshened up palette with luxury appointments. It starts with quartz kitchen countertops, stainless steel sink, new gas stove and refrigerator, completely renovated bathroom with double sinks, gleaming floors, and a new shower/tub combination. The bedroom has new carpeting and features two great closets. Your living room is an enormous L shaped space with sliding glass doors leading to a gracious outdoor patio. The flooring is brand new high-end vinyl plank that shows like beautiful stained wood finish. New ceiling lighting is dimmable, and sets a calm and relaxing tone. There is assigned indoor parking to the unit and an Association managed charging station is nearby. The laundry facility featuring reliable professionally managed equipment is also just steps away.

district__c,SF District 4

driveway_sidewalks__c,Shared Driveway

entry_level__c,0

external_listing__c,1

fencing__c,Wood;Fenced;Masonry

pba__floortype_pb__c,Carpet;Simulated Wood

hoa_fee_includes__c,Common Areas,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Sewer,Trash,Water

pba__hoafees__c,688

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2023-09-22T02:46:39.000+0000

pba__latitude_pb__c,37.7455863

pba__latitude_property__c,37.7455863

laundry_features__c,See Remarks

listed_date__c,2023-04-26

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Bruce

pba__listing_agent_lastname__c,McKleroy

listing_agent_mls_id__c,800188

ffd_listingagentname,Bruce G McKleroy

listing_agent_number__c,800188

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,695000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=LVB3T4EzNnp&mls=1

pba__longitude_pb__c,-122.4430698

mls_id__c,423909030

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room

master_bathroom_features__c,Tub w/Shower Over;Double Sinks;Dual Flush Toilet;Fiberglass

master_property__c,a0O1I000004VXgBUAW

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-20

open_house_end__c,2023-09-24T16:00:00.000+0000

open_house_start__c,2023-09-24T14:00:00.000+0000

original_price__c,695000

overall_days_on_market__c,-81711

parking_access__c,Independent

parking_features__c,Garage Door Opener,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,Uncovered Patio

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,829.36

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTLl2UAG

room_type__c,Kitchen;Living Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;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,838

size__c,838

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,255 Red Rock Way #103H, San Francisco, CA, 94131

view__c,Garden/Greenbelt

website_property_type__c,Condominium

window_features__c,Window Screens

pba__yearbuilt_pb__c,1972

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530680410-1.jpg

ffd_listing_title,990 Duncan Street #307G, San Francisco, CA, 94131

ffd_mls_id,423900428

ffd_salesforce_id,a0E8W00000dSTOeUAO

num_of_fireplaces__c,1

num_of_rooms__c,3

of_units__c,396

address2__c,990 Duncan Street #307G, San Francisco, CA, 94131

pba__address_pb__c,990 Duncan Street #307G, San Francisco, CA, 94131

agent_only_remarks__c,Easy to show, please contact listing agent 415.871.4597 Carlos. Buyer to verify functionality of the gas fireplace.

appliances__c,Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2023-09-14T10:47:08.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Welcome to a nestle 1BR 1BA condo located in the Diamond Heights Village. This home is perfectly located on the top floor, bright, and it's a corner unit! The kitchen features new stainless steel appliances, equipped with a refrigerator, gas range oven, dishwasher, a microwave, and lots of cabinet space. The dining area and living room receives a great amount of natural light through the large windows. The home was recently painted in the interior, along with new light and water fixtures were installed for the sale. It has 1 parking space assigned, in a secured gated garage. Notable amenities of the community include the landscaped garden, a clubhouse with a pool table, a gym with separate cardio and weight training areas, and an outdoor heated swimming pool. Close to your new home you will find great green spaces, Douglass Playground and Dogplay, Douglass Park Tennis Courts, amazing Glen Canyon Park Trails. Close and convenient shops include Safeway, and Walgreens. Take a look and be marbled by all the value this home offers.

district__c,SF District 4

entry_level__c,0

exterior_features__c,Fireplace;Fire Pit

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Carpet;Laminate

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Management,Pool,Trash,Water

pba__hoafees__c,688

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Wall Furnace

interior_features__c,Open Beam Ceiling

ffd_lastmodifieddate,2023-09-21T01:46:35.000+0000

pba__latitude_pb__c,37.7453263

pba__latitude_property__c,37.7453263

laundry_features__c,Ground Floor

listed_date__c,2023-06-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Carlos

pba__listing_agent_lastname__c,Barrientos

listing_agent_mls_id__c,809136

ffd_listingagentname,Carlos L Barrientos

listing_agent_number__c,1040713

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,REDF

listing_office_name__c,Redfin

listing_office_number__c,64045

pba__listingprice_pb__c,649000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=uWhH5SnqBaT&brand=0&mls=1&

pba__longitude_pb__c,-122.4426443

mls_id__c,423900428

master_bathroom_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Tile

master_property__c,a0O8W00000KTGPfUAP

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-14

open_house_end__c,2023-09-23T16:00:00.000+0000

open_house_start__c,2023-09-23T14:00:00.000+0000

original_price__c,649000

overall_days_on_market__c,-81705

parking_access__c,Independent

parking_features__c,Garage Door Opener

parking_type__c,On Site - Assigned (Condo Only)

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,872.31

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSTOeUAO

room_type__c,Kitchen;Living Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate

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,744

size__c,744

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Duncan

subdist__c,Diamond Heights

ffd_name,990 Duncan Street #307G, San Francisco, CA, 94131

view__c,Garden/Greenbelt

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1972

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530676530-1.jpg

ffd_listing_title,255 Red Rock Way #206H, San Francisco, CA, 94131

ffd_mls_id,423907612

ffd_salesforce_id,a0E8W00000cqRRMUA2

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,396

address2__c,255 Red Rock Way #206H, San Francisco, CA, 94131

pba__address_pb__c,255 Red Rock Way #206H, San Francisco, CA, 94131

agent_only_remarks__c,Disclosures available https://app.glide.com/share/M4PLE85V2STouEC4NSOAr/ Offers as they come.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-08T00:47:05.000+0000

days_on_market__c,13

dom__c,13

ffd_description_pb,Welcome to your new home in desirable Diamond Heights Village! Step inside where you'll notice new flooring throughout the spacious and open floor plan, perfect for hosting friends or simply relaxing. The living room features oversized south-facing windows that brighten the home throughout the year while also offering breathtaking south-facing views. The kitchen has been updated with a new G.E. refrigerator and features generous storage and a large pantry closet. The spacious bedroom boasts an en-suite bathroom and large walk-in closet. The home includes one car assigned parking. The H building includes direct access to the building elevator, parking space, as well as the laundry room. Diamond Heights Village offers a full set of amenities, including fitness center, heated outdoor pool, sauna, and clubhouse with pool tables and lounge areas. You'll love life in this vibrant and welcoming community in a neighborhood offering a peaceful retreat from the city and nearby Glen Canyon access while still being just minutes away from all the action. Don't miss out on the opportunity to make this stunning condo your new home!

district__c,SF District 4

entry_level__c,0

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Grounds,Management,Pool,Roof

pba__hoafees__c,688

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2023-09-21T02:46:30.000+0000

pba__latitude_pb__c,37.74557

pba__latitude_property__c,37.74557

laundry_features__c,Ground Floor

listed_date__c,2023-06-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Colby

pba__listing_agent_lastname__c,Josey

listing_agent_mls_id__c,815567

ffd_listingagentname,Colby Josey

listing_agent_number__c,1073187

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,JFLL

listing_office_name__c,Jackson Fuller Real Estate

listing_office_number__c,27078

pba__listingprice_pb__c,650000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=t8jzFM5ogqg&mls=1

pba__longitude_pb__c,-122.44303

mls_id__c,423907612

master_property__c,a0O1I000004VXgBUAW

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-07

open_house_end__c,2023-09-23T16:00:00.000+0000

open_house_start__c,2023-09-23T14:00:00.000+0000

original_price__c,650000

overall_days_on_market__c,-81698

parking_access__c,Independent

parking_features__c,Garage Door Opener,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,873.66

pba__propertytype__c,Condominium

ListingId,a0E8W00000cqRRMUA2

sale_date__c,1800-01-01

sale_price__c,0

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,744

size__c,744

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,255 Red Rock Way #206H, San Francisco, CA, 94131

view__c,City;Downtown;San Francisco

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1972

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530672979-1.jpg