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

_yoast_indexnow_last_ping,1714096793

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

ffd_mls_id,424021617

ffd_salesforce_id,a0EUd000001fTOsMAM

num_of_fireplaces__c,1

num_of_rooms__c,2

of_units__c,240

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

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

agent_only_remarks__c,Call or text Par with any questions

appliances__c,Microwave;Free Standing Gas Range;Free Standing Refrigerator

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,0

year_build_text__c,1972

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Chip McAllister

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-06T00:49:09.000+0000

days_on_market__c,20

dom__c,20

ffd_description_pb,Overlooking a large manicured garden with mature trees, koi pond and meandering paths, you will find a spacious studio flooded in natural light. Modern, open floor-plan welcomes you with upgrades such as a gas fireplace, ample cabinetry, quartz countertops and recessed lighting throughout. Perfect as a starter home or pied a terre, Diamond Heights Village is located in the center of the City in a beautiful verdant surrounding. Shopping is minutes away, terrific access to transportation within walking distance, endless trails of Twin Peaks, Glen Park entices you to get out for a run. Full service amenities include parking, onsite laundry, gym, clubhouse and much more. Make this the one to see! HOA dues include- Earthquake Insurance, Elevator, Insurance on Structure, Maintenance Exterior, Maintenance Grounds, Management, Pool, Recreation Facility, Roof, Sewer, Trash, Water, Heat

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Piped

pba__floortype_pb__c,Laminate

pba__hoafees__c,650

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Wall Furnace;Natural Gas

ffd_lastmodifieddate,2024-04-26T01:46:32.000+0000

pba__latitude_pb__c,37.745822

pba__latitude_property__c,37.745822

listed_date__c,2024-03-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Par

pba__listing_agent_lastname__c,Hanji

listing_agent_mls_id__c,804371

ffd_listingagentname,Par Hanji

listing_agent_number__c,166013908

listing_co_agent_mls_id__c,535855

listing_co_agent_number__c,535855

listing_co_office_mls_id__c,COMP90

listing_co_office_name__c,Compass

listing_co_office_number__c,29048

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,499000

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.441873

mls_id__c,424021617

master_property__c,a0O1I000001ViHDUA0

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-05

open_house_end__c,2024-04-28T16:00:00.000+0000

open_house_start__c,2024-04-28T14:00:00.000+0000

original_price__c,499000

overall_days_on_market__c,-81909

parking_access__c,Independent

parking_features__c,Attached,Covered,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,842.91

pba__propertytype__c,Condominium

ListingId,a0EUd000001fTOsMAM

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,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 #107K, San Francisco, CA, 94131

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

_yoast_indexnow_last_ping,1714179455

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

ffd_mls_id,424017278

ffd_salesforce_id,a0EUd000001aw3KMAQ

num_of_fireplaces__c,1

num_of_rooms__c,8

of_units__c,0

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

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

agent_only_remarks__c,Please use open escrow with Christine Lim at Old Republic Title Company.

appliances__c,Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Free Standing Refrigerator;Double Oven

architectural_style__c,Contemporary

bath_features__c,Tub;Tile;Jetted Tub

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1968

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Carren S Shagley

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-03-29T00:47:42.000+0000

days_on_market__c,29

dom__c,29

ffd_description_pb,Exciting News - Fabulous Price for Exceptional, Spacious and Elegant Diamond Heights Home! Come see 260 Gold Mine Drive, where charm, function, high-quality finishes, and stunning panoramic views of Glen Park Canyon, Mount Davidson, and the Pacific Ocean converge. Thoughtfully stewarded, with over 2500 square feet of bright, airy living spaces. Mahogany double-door front entrance. Open main living and dining spaces, with walnut-finished hardwood floors and stellar views, perfect for entertaining. Gourmet kitchen with an impressive island, large-scale Wolf and Kitchen-Aid stainless steel appliances, extensive counter space, and custom solid-wood cabinets. The primary bedroom offers a walk-in closet and elegant en suite bath. Spacious secondary bedrooms with beautiful views and ample storage. Modern bathrooms with floating, wall-mounted vanities. Home theater/enormous family room with sliding glass doors and an outdoor viewing deck. Desirable two-car garage. Step outside to blooming fruit trees, flowering shrubs, and raised beds. Prime location in the very heart of San Francisco with easy access to Glen Park and Noe Valley amenities, BART, MUNI, and 280 freeway. Schedule a tour ASAP!

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Gas Piped;Gas Starter

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Electric;Fireplace(s)

interior_features__c,Formal Entry;Skylight(s)

ffd_lastmodifieddate,2024-04-27T00:47:39.000+0000

pba__latitude_pb__c,37.7414401

pba__latitude_property__c,37.7414401

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2024-02-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jennifer

pba__listing_agent_lastname__c,Burden

listing_agent_mls_id__c,804035

ffd_listingagentname,Jennifer C Burden

listing_agent_number__c,166013451

listing_co_agent_mls_id__c,113506

listing_co_agent_number__c,113506

listing_co_office_mls_id__c,LEGACY

listing_co_office_name__c,Legacy Real Estate

listing_co_office_number__c,27760

listing_office_mls_id__c,LEGACY

listing_office_name__c,Legacy Real Estate

listing_office_number__c,27760

pba__listingprice_pb__c,2500000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.260GoldMine.com

pba__longitude_pb__c,-122.4388194

lower_level__c,Family Room,Retreat

mls_id__c,424017278

main_level__c,Full Bath(s);Bedroom(s);Garage

master_bathroom_features__c,Shower Stall(s);Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-03-28

open_house_end__c,2024-04-28T16:00:00.000+0000

open_house_start__c,2024-04-28T14:00:00.000+0000

original_price__c,2895000

overall_days_on_market__c,-81901

parking_access__c,Side by Side

parking_features__c,Covered,Garage Door Opener,Garage Facing Front

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Back Porch;Uncovered 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,962.65

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001aw3KMAQ

road_surface_type__c,Paved

room_type__c,Kitchen;Living Room;Baths Other;Dining Room;Family Room;Possible Guest;Home Theater;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

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

size__c,2597

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Gold Mine

subdist__c,Diamond Heights

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

view__c,Ocean;City;Panoramic;City Lights;San Francisco;Twin Peaks;Mountains;Canyon

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Screens

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

_yoast_indexnow_last_ping,1713898537

ffd_listing_title,55 Red Rock Way #208O, San Francisco, CA, 94131

ffd_mls_id,424015328

ffd_salesforce_id,a0EUd000001S0m7MAC

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,396

address2__c,55 Red Rock Way #208O, San Francisco, CA, 94131

pba__address_pb__c,55 Red Rock Way #208O, San Francisco, CA, 94131

agent_only_remarks__c,Please call Charlie at 415-269-3705 with questions, for disclosures and for showing instructions. Agent lives in complex and can be shown on short notice

appliances__c,Hood Over Range;Electric Cook Top;Built-In Refrigerator;Built-In Electric Oven

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,0

year_build_text__c,1972

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Debra Donovan

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-03-15T10:47:45.000+0000

days_on_market__c,39

dom__c,39

ffd_description_pb,This condominium home is a Jr 1 Bedroom/Alcove Studio which has been meticulously cared for and includes tasteful upgrades that elevate the graciousness of the home. As you enter the unit, you'll see wood flooring which transitions into carpeting in the living room/ bedroom area. In theupdated kitchen, you'll discovernew matching stainless-steel appliances and custom cabinetry. The recently renovated bathroom features a modern vanity with lots of drawers and storage with a separate area for the shower over tub. The closet pass-through has been upgraded with aconvenient desk/ workspace with even more storage shelves. The living/ bedroom area has a tasteful and convenient Murphy bed to maximize living space, as well as a gas fireplace that can provide both heat and ambiance. This unit faces south and west out to the pool and clubhouse, as well as views of the beautiful landscaping. HOA amenities include an outdoor heated pool, fitness center with cardio, free weights, dry sauna and whirpool spa. EV Charging too You may never want to leave home!

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Starter

pba__floortype_pb__c,Carpet;Laminate

hoa_fee_includes__c,Water,Trash,Sewer,Pool,Management,Insurance,Elevator,Earthquake Insurance,Common Areas

pba__hoafees__c,645

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village Homeowners Assoc.

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Gas

ffd_lastmodifieddate,2024-04-23T18:46:40.000+0000

pba__latitude_pb__c,37.7460467

pba__latitude_property__c,37.7460467

laundry_features__c,In Basement

listed_date__c,2024-03-05

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_mls_id__c,807872

listing_co_agent_number__c,1027954

listing_co_office_mls_id__c,PKNO

listing_co_office_name__c,Park North Real Estate

listing_co_office_number__c,24343

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__longitude_pb__c,-122.4410617

mls_id__c,424015328

master_property__c,a0O1I000001VhkGUAS

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-03-15

open_house_end__c,2024-04-23T16:00:00.000+0000

open_house_start__c,2024-04-23T09:00:00.000+0000

original_price__c,525000

overall_days_on_market__c,-81888

parking_access__c,Side by Side

parking_features__c,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001S0m7MAC

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

size__c,592

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,55 Red Rock Way #208O, San Francisco, CA, 94131

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

_yoast_indexnow_last_ping,1713898529

ffd_listing_title,95 Red Rock Way #209M, San Francisco, CA, 94131

ffd_mls_id,424012834

ffd_salesforce_id,a0EUd000001KcqBMAS

num_of_fireplaces__c,0

num_of_rooms__c,2

of_units__c,396

address2__c,95 Red Rock Way #209M, San Francisco, CA, 94131

pba__address_pb__c,95 Red Rock Way #209M, San Francisco, CA, 94131

agent_only_remarks__c,Please call Charlie at 269-3705 with questions, for disclosures and to show. Agent lives in building and can show on short notice. I'll have a L/B installed on the unit door and can also buzz you into the bldg. For your convenience a pre-sale escrow has been opened at WFG Title. Offers reviewed upon presentation. All Offers MUST be on an SFAR or CAR contract.

appliances__c,Dishwasher;Microwave;Hood Over Range;Free Standing Refrigerator;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-03-04T11:47:03.000+0000

days_on_market__c,50

dom__c,50

ffd_description_pb,Welcome Home! This stunningly remodeled condo in the minimalist style is nestled above a soothing courtyard. It features a spacious kitchen, open closet and dressing area, breakfast bar with a spacious main living area. M209 has views to south, over the central courtyard which features a series of cascading koi ponds, surrounded by a curated mix of native and drought-tolerant landscaping. Living here is like being in your own private garden. We've repainted and replaced all of the surfaces and appliances and added a dishwasher. The minimalist decor brings the home a Zen-like feel. This condo makes for a great pied a terre or starter home and is ready for move right in! As a member of Diamond Hts Village 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 mgmnt and an EV charging station. + deeded garage parking - at no extra monthly cost. Glen Canyon Park, Red Hen Organic Community Garden, Douglass Playground, public tennis courts, Christopher Playground and the Diamond Heights Safeway Shopping Center are all nearby. You'll love living here!

district__c,SF District 4

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Bamboo

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-04-23T18:46:40.000+0000

pba__latitude_pb__c,37.746321

pba__latitude_property__c,37.746321

laundry_features__c,Inside Room

listed_date__c,2024-03-01

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.44152

mls_id__c,424012834

master_property__c,a0O1I00000BBKIeUAP

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-03-04

open_house_end__c,2024-04-23T16:00:00.000+0000

open_house_start__c,2024-04-23T09:00:00.000+0000

original_price__c,500000

overall_days_on_market__c,-81877

parking_access__c,Side by Side

parking_features__c,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,1054.85

pba__propertytype__c,Condominium

ListingId,a0EUd000001KcqBMAS

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

size__c,474

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,95 Red Rock Way #209M, San Francisco, CA, 94131

view__c,Garden/Greenbelt

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Bay Window(s)

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