950 Duncan Street #201E, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1713610754

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

dom__c,15

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-20T10:46:59.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-21T16:00:00.000+0000

open_house_start__c,2024-04-21T14: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,1713650148

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

dom__c,23

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-20T21:46:43.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-21T16:00:00.000+0000

open_house_start__c,2024-04-21T14: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,2024-04-18T10:39:14.000+0000

price_per_square_foot__c,962.65

price_reduced__c,1

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

ffd_listing_title,135 Red Rock Way #105L, San Francisco, CA, 94131

ffd_mls_id,424017596

ffd_salesforce_id,a0EUd000001ZGZBMA4

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,396

address2__c,135 Red Rock Way #105L, San Francisco, CA, 94131

pba__address_pb__c,135 Red Rock Way #105L, San Francisco, CA, 94131

agent_only_remarks__c,Offers as they come. Unit needs just a little TLC. Kitchen and baths can be updated. Great light in unit and the patio space really adds to the unit.

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-26T21:47:31.000+0000

days_on_market__c,13

dom__c,13

ffd_description_pb,135 Red Rock Way #105L is a modern, urban retreat in San Francisco. This spacious studio offers smart and efficient use of space including a sleeping alcove and defined dining and living room areas. There is 650 square feet of living space plus a private, large, south-facing patio, which not only enhances the interior living space, but also allows for abundant light. There are three good-sized closets and a gas fireplace. A kitchen, full bath with separate vanity area completes this space. One-car parking and laundry facilities are located within the building. The Association, Diamond Heights Village, offers a lush, landscaped common area, with exotic plantings, streams and bridges. There is a beautiful swimming pool, club house, and a well-equipped gym. Located in the Diamond Heights neighborhood, there is good access to public transportation, freeways, and shopping at the Diamond Heights Shopping Center. The Castro, Noe Valley, and Glen Park are just minutes away. This condominium has wonderful potential and can be the perfect starter home or pied a terre in the City.

district__c,SF District 4

driveway_sidewalks__c,Paved Sidewalk,Shared Driveway,Sidewalk/Curb/Gutter

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Gas Starter

pba__floortype_pb__c,Carpet;Linoleum

hoa_fee_includes__c,Earthquake Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Recreation Facility,Trash,Water

pba__hoafees__c,646

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Diamond Heights Village HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2024-04-08T10:46:54.000+0000

pba__latitude_pb__c,37.746139

pba__latitude_property__c,37.746139

laundry_features__c,No Hookups

listed_date__c,2024-02-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,William

pba__listing_agent_lastname__c,Kitchen

listing_agent_mls_id__c,803707

ffd_listingagentname,William J Kitchen Jr.

listing_agent_number__c,803707

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.442014

mls_id__c,424017596

master_property__c,a0O1I000001ViQXUA0

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-03-26

original_price__c,499000

overall_days_on_market__c,-81899

parking_access__c,Side by Side

parking_features__c,Enclosed

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001ZGZBMA4

road_surface_type__c,Paved

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Secured Access

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

size__c,650

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Red Rock

subdist__c,Diamond Heights

ffd_name,135 Red Rock Way #105L, 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/530750819-1.jpg

_yoast_indexnow_last_ping,1713822981

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

dom__c,38

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-22T21:46:59.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