135 Turquoise Way, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1729126477

ffd_listing_title,940 Duncan Street #302D, San Francisco, CA, 94131

ffd_mls_id,424072178

ffd_salesforce_id,a0EUd000003L1VfMAK

num_of_fireplaces__c,1

num_of_rooms__c,3

of_units__c,396

address2__c,940 Duncan Street #302D, San Francisco, CA, 94131

pba__address_pb__c,940 Duncan Street #302D, San Francisco, CA, 94131

agent_only_remarks__c,Please call Charlie at 415-269-3705 with questions, for disclosures and to show. Light Fixer/Owner lived here for many years and is now in a rest home. Offers reviewed anytime following second Sunday Open House (10/20). Agent lives in complex and can usually show on short notice. As this is a trust sale, we are requesting buyers use Katerina at WFG Title. Please allow 24-48 hours for response from Successor Trustee. Disclosures are available on the disclosure IO platform or this link: https://app.disclosures.io/link/940-Duncan-Street-302D-g06ekr59

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range

architectural_style__c,Contemporary

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

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,2024-10-12T00:50:00.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,This Top Floor Corner Condominium Home faces South and East with sunny unobstructed panoramic views over the Bay and down the Peninsula. Home has been lived in by the same owner for 30+ years and is a cosmetic fixer, though everything works. Features include a gas fireplace, open beamed ceiling, large walk-in closet, gas range, Dishwasher and lots of natural light. As a member of Diamond Heights Village HOA you will enjoy an outdoor heated pool, fitness center with machines, free-weights, universal press, sauna, and whirlpool spa, clubhouse with several seating areas, billiards, and free Wi-Fi throughout and also poolside. Condo comes complete with its own deeded, garage parking space at no extra monthly charge. EV charging too. If you're looking for an easy fixer at a great price, this is the condo you have been waiting for!

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Gas Log

pba__floortype_pb__c,Carpet

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

pba__hoafees__c,748

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Wall Furnace;Gas

interior_features__c,Open Beam Ceiling

ffd_lastmodifieddate,2024-10-17T00:50:48.000+0000

pba__latitude_pb__c,37.7454734

pba__latitude_property__c,37.7454734

laundry_features__c,In Garage

listed_date__c,2024-09-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Charles

pba__listing_agent_lastname__c,Mader

listing_agent_mls_id__c,803056

ffd_listingagentname,Charles W Mader

listing_agent_number__c,803056

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,PKNO

listing_office_name__c,Park North Real Estate

listing_office_number__c,24343

pba__listingprice_pb__c,600000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4409003

mls_id__c,424072178

master_property__c,a0O1I000001y1kHUAQ

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-10-11

open_house_end__c,2024-10-16T19:00:00.000+0000

open_house_start__c,2024-10-16T17:00:00.000+0000

original_price__c,600000

overall_days_on_market__c,-82098

parking_access__c,Side by Side

parking_features__c,EV Charging

parking_type__c,On Site - Mapped (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,806.45

pba__propertytype__c,Condominium

ListingId,a0EUd000003L1VfMAK

road_surface_type__c,Asphalt

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Fire Extinguisher;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,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,940 Duncan Street #302D, San Francisco, CA, 94131

view__c,Panoramic;Garden/Greenbelt;Bay;San Francisco;Hills;Mountains

website_property_type__c,Condominium

window_features__c,Dual Pane Full;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/530867155-1.jpg

_yoast_indexnow_last_ping,1729198654

ffd_listing_title,340 Gold Mine Drive, San Francisco, CA, 94131

ffd_mls_id,424063340

ffd_salesforce_id,a0EUd0000033JkLMAU

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,340 Gold Mine Drive, San Francisco, CA, 94131

pba__address_pb__c,340 Gold Mine Drive, San Francisco, CA, 94131

agent_only_remarks__c,Offer to be review as they come. Previous MLS transaction in 2015 shows 2500 sqft while assessor record shows 1531 sqft. The buyer and the buyer's agent are responsible for conducting due diligence to verify the square footage of the property.

appliances__c,Dishwasher;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range

bath_features__c,Bidet;Multiple Shower Heads

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,4

year_build_text__c,1968

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-06T22:47:50.000+0000

days_on_market__c,41

dom__c,41

ffd_description_pb,Welcome to 340 Gold Mine Drive, a prime location offering a luxurious lifestyle! This expansive property features over 2,500 sqft of living space, and boasts 4 spacious bedrooms and 5 modern bathrooms. The updated kitchen and bathrooms, along with new flooring throughout, add a touch of contemporary elegance. Enjoy the large family room, perfect for gatherings, and take in the breathtaking panoramic views from your windows and stunning balcony. Situated close to the Glen Park BART Station, Walter Haas Playground, the Diamond Heights Shopping Center, and the scenic Glen Canyon Trail, convenience and outdoor adventure are at your doorstep. Don't miss the chance to own this exquisite home in a highly sought-after neighborhood - schedule your viewing today!

district__c,SF District 4

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning;Brick

pba__floortype_pb__c,Laminate;Tile

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-17T20:47:49.000+0000

pba__latitude_pb__c,37.7396512

pba__latitude_property__c,37.7396512

laundry_features__c,In Garage;Hookups Only

listed_date__c,2024-09-06

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Winnie

pba__listing_agent_lastname__c,Wong

listing_agent_mls_id__c,810145

ffd_listingagentname,Winnie Wong

listing_agent_number__c,1044931

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,SRPS

listing_office_name__c,Surpass Real Estate & Finance

listing_office_number__c,24008

pba__listingprice_pb__c,2300000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4389164

lower_level__c,Family Room,Full Bath(s)

mls_id__c,424063340

main_level__c,Full Bath(s);Bedroom(s);Street Entrance

master_bathroom_features__c,Bidet;Multiple Shower Heads

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,4

on_market_date__c,2024-09-06

open_house_end__c,2024-10-20T16:00:00.000+0000

open_house_start__c,2024-10-20T14:00:00.000+0000

original_price__c,2300000

overall_days_on_market__c,-82063

parking_access__c,Side by Side

parking_features__c,Attached,Garage Door Opener,Garage Facing Front,Side-by-Side

parking_type__c,On Site (Single Family Only)

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000033JkLMAU

room_type__c,Bonus Room;Living Room;Dining Room;Family Room

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

size__c,2500

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Gold Mine

subdist__c,Diamond Heights

ffd_name,340 Gold Mine Drive, San Francisco, CA, 94131

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1968

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1729025775

ffd_listing_title,175 Red Rock Way #101K, San Francisco, CA, 94131

ffd_mls_id,424062749

ffd_salesforce_id,a0EUd0000032lFtMAI

num_of_fireplaces__c,1

num_of_rooms__c,2

of_units__c,396

address2__c,175 Red Rock Way #101K, San Francisco, CA, 94131

pba__address_pb__c,175 Red Rock Way #101K, San Francisco, CA, 94131

agent_only_remarks__c,Please Call Charlie at 415-269-3705 with questions, for disclosures and to show. For your convenience, a pre-sale escrow has been opened with Katerina at WFG. Seller passed of old age off-site. FHA/VA Approved Complex. Sellers Disclosures are on IO or can be found here: https://app.disclosures.io/link/175-Red-Rock-Way-101K-hhmqowpy Please email agent with BBA for HOA disclosures.

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Electric Range

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,0

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-06T10:49:37.000+0000

days_on_market__c,40

dom__c,40

ffd_description_pb,Welcome Home! This nicely remodeled condominium is an end unit and has it's own deeded patio, nestled above a soothing bucolic courtyard. DHV #K101 has been nicely remodeled with engineered birch flooring throughout, updated lighting and newer kitchen appliances and closets. Other features include a galley kitchen, separate vanity and wet area, pass-thru California closets and dressing area, breakfast bar with a spacious main living area highlighted by a working gas fireplace. This gracious home has views to the west, as well as onto your own private patio, providing cross ventilation, also great for a pet owner and/or urban gardener. The floorplan makes for a great pied a terre or starter home and is ready for you to move right in! As a member of Diamond Heights Village HOA you will enjoy an outdoor resort-style heated pool, fitness center with machines, free-weights, universal press, sauna, and whirlpool spa, clubhouse with several seating areas, billiards, and free Wi-Fi throughout and also poolside, on-site management. Condo comes complete with its own deeded, garage parking space at no extra monthly charge. EV charging too.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Log

pba__floortype_pb__c,Simulated Wood

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

pba__hoafees__c,645

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village Assn

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2024-10-15T20:47:25.000+0000

pba__latitude_pb__c,37.7458223

pba__latitude_property__c,37.7458223

laundry_features__c,In Garage

listed_date__c,2024-08-24

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Charles

pba__listing_agent_lastname__c,Mader

listing_agent_mls_id__c,803056

ffd_listingagentname,Charles W Mader

listing_agent_number__c,803056

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,PKNO

listing_office_name__c,Park North Real Estate

listing_office_number__c,24343

pba__listingprice_pb__c,525000

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/aFMWF2Qoc2o

pba__longitude_pb__c,-122.4418727

mls_id__c,424062749

master_property__c,a0O1I000001ViHDUA0

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-05

open_house_end__c,2024-10-15T16:00:00.000+0000

open_house_start__c,2024-10-15T09:00:00.000+0000

original_price__c,525000

overall_days_on_market__c,-82062

parking_access__c,Side by Side

parking_features__c,Attached

parking_type__c,On Site - Mapped (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,886.82

pba__propertytype__c,Condominium

ListingId,a0EUd0000032lFtMAI

road_surface_type__c,Asphalt

roof__c,Tar/Gravel

sale_date__c,1800-01-01

sale_price__c,0

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

size__c,592

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,175 Red Rock Way #101K, San Francisco, CA, 94131

view__c,Other

website_property_type__c,Condominium

window_features__c,Dual Pane Full

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/530837514-1.jpg

_yoast_indexnow_last_ping,1728442545

ffd_listing_title,80 Gold Mine Drive, San Francisco, CA, 94131

ffd_mls_id,424056526

ffd_salesforce_id,a0EUd000002sa0YMAQ

num_of_fireplaces__c,1

num_of_rooms__c,13

of_units__c,0

address2__c,80 Gold Mine Drive, San Francisco, CA, 94131

pba__address_pb__c,80 Gold Mine Drive, San Francisco, CA, 94131

agent_only_remarks__c,Escrow is open with Michelle Pineda at Old Republic Title #0227020849. Disclosure package available shortly. For more information or showings contact Gary DeMars at 415-254-4243.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Wine Refrigerator

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Shower Stall(s)

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,2014

pba__city_pb__c,San Francisco

pba__contingentdate__c,2024-10-08

ffd_createddate,2024-08-17T10:48:47.000+0000

days_on_market__c,52

dom__c,52

ffd_description_pb,80 Gold Mine Drive is a gem in Diamond Heights, designed by Kerman Morris Architects and built in 2014. This home stands out for its quality, with crisp, clean, contemporary lines throughout its spacious three-level layout. On the first floor, you'll find a sound-wired family room, a bathroom, a guest room, and direct access to a side-by-side 2-car garage. An elevator connects all three levels for added convenience to help navigate the vertical spaces. The second floor features two bedrooms, a bathroom, and the large primary suite, which offers a spa-like bath, a walk-in closet, and a balcony for outdoor relaxation. The third level is the heart of the home, with a great room boasting vaulted ceilings, a gas fireplace, and an open chef's kitchen with Thermador appliances and quartz countertops. Floor-to-ceiling Bonelli windows flood the space with natural light, highlighting the quality finishes, including engineered wide plank oak floors with radiant heat in three zones. The home also has air conditioning, a fire suppression system, and a security system. For easy entertaining, there are multiple deck spaces with sweeping city views. The side yard perfect for a dog.

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

exterior_features__c,Balcony;Entry Gate

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

pba__heatingtype_pb__c,Radiant

interior_features__c,Elevator

ffd_lastmodifieddate,2024-10-09T02:46:06.000+0000

pba__latitude_pb__c,37.7440219

pba__latitude_property__c,37.7440219

laundry_features__c,Laundry Closet

listed_date__c,2024-07-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gary

pba__listing_agent_lastname__c,DeMars

listing_agent_mls_id__c,800719

ffd_listingagentname,Gary G DeMars

listing_agent_number__c,800719

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28936

pba__listingprice_pb__c,3250000

pba__listingtype__c,Sale

pba__listing_website__c,http://my.matterport.com/show/?m=QQJjZrcP9tK&brand=0

pba__longitude_pb__c,-122.4374787

mls_id__c,424056526

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-08-17

original_price__c,3500000

overall_days_on_market__c,-82043

parking_access__c,Side by Side

parking_features__c,Attached,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;Uncovered Patio

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000002sa0YMAQ

room_type__c,Family Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Fire Alarm;Fire Suppression System;Carbon Mon Detector;Security System Owned

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Contingent - Show

pba__totalarea_pb__c,3029

size__c,3029

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Gold Mine

subdist__c,Diamond Heights

ffd_name,80 Gold Mine Drive, San Francisco, CA, 94131

view__c,City;Bay;Downtown

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2014

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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