95 Red Rock Way #304M, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1728730391

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.

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

dom__c,1

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-12T10:48:21.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-12T16:00:00.000+0000

open_house_start__c,2024-10-12T14: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,1728608145

ffd_listing_title,135 Turquoise Way, San Francisco, CA, 94131

ffd_mls_id,424069703

ffd_salesforce_id,a0EUd000003G6nhMAC

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,135 Turquoise Way, San Francisco, CA, 94131

pba__address_pb__c,135 Turquoise Way, San Francisco, CA, 94131

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1962

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-10-02T16:47:52.000+0000

days_on_market__c,8

dom__c,8

ffd_description_pb,Peaceful and serene, 135 Turquoise Way is a special home basked in sunlight with green outlooks, located on one of Diamond Heights' most beautiful blocks. The spacious & open main floor hosts a dining room with a gas fireplace and an ample-sized living room. The two rooms are connected by a unique sunroom/solarium with a ceiling of skylights and walls of windows with Southern light -- a delightful room to both relax & host. An updated kitchen features copious storage, a double oven, pantry space, and a wine fridge/coffee area. Sliding doors lead to a back garden with a patio for seating and a tiered garden for plants. A half bath and storage/coat closet complete the main level. The upstairs bedroom level features two guest/kids bedrooms, a remodeled full bath, and a primary bedroom with a spa-like bathroom with a double sink, soaking tub, and shower. Additionally, the home features a two-car garage + a separate laundry room, air conditioning, abundant windows throughout, and great storage. Nestled on a tree-lined street steps to the Glen Canyon trailhead, and quick access to Diamond Heights Shopping Center & all that Noe Valley has to offer.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Starter;Dining Room

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-11T00:47:26.000+0000

pba__latitude_pb__c,37.7437623

pba__latitude_property__c,37.7437623

listed_date__c,2024-10-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Lamisse

pba__listing_agent_lastname__c,Droubi

listing_agent_mls_id__c,802259

ffd_listingagentname,Lamisse Droubi

listing_agent_number__c,802259

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,GENERATE

listing_office_name__c,Generation Real Estate

listing_office_number__c,28067

pba__listingprice_pb__c,2195000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4433761

mls_id__c,424069703

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-10-02

open_house_end__c,2024-10-13T15:00:00.000+0000

open_house_start__c,2024-10-13T13:00:00.000+0000

original_price__c,2195000

overall_days_on_market__c,-82089

parking_access__c,Side by Side

parking_features__c,Attached

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003G6nhMAC

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

size__c,2039

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Turquoise

subdist__c,Diamond Heights

ffd_name,135 Turquoise Way, San Francisco, CA, 94131

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1962

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1728557627

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

dom__c,34

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-10T10:48:59.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-12T18:00:00.000+0000

open_house_start__c,2024-10-12T16: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,1728500005

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

dom__c,34

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-09T18:47:26.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-13T16:00:00.000+0000

open_house_start__c,2024-10-13T14: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