255 Red Rock Way #307H, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1715540101

ffd_listing_title,5140 Diamond Heights Boulevard #304A, San Francisco, CA, 94131

ffd_mls_id,424030539

ffd_salesforce_id,a0EUd000001zkBrMAI

num_of_fireplaces__c,1

num_of_rooms__c,4

of_units__c,396

address2__c,5140 Diamond Heights Boulevard #304A, San Francisco, CA, 94131

pba__address_pb__c,5140 Diamond Heights Boulevard #304A, San Francisco, CA, 94131

agent_only_remarks__c,Please call Charlie at 269-3705 with questions, for disclosures and to show. Agent lives in complex and can show on short notice. A lockbox will be installed on unit door after 1st Sunday open for contactless showings. Owner is very much alive and has lived in home for many years. Offers reviewed Wed May 22 at Noon.

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

architectural_style__c,Contemporary;Mid-Century

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-10T22:47:11.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Stunning, unobstructed views of downtown and the bay area are yours from this top floor 2bed/2bath double en-suite condominium home. This condo has been meticulously cared for and includes tasteful upgrades which elevate its graciousness. As you enter, your eyes are drawn to the unparalleled panoramic bay area vistas afforded by being on the top floor. We've repainted the home and it shows to perfection:There is a wood beam ceiling in the living and bedrooms, a nicely remodeled kitchen with matching granite countertops and appliances including a gas range and dishwasher. The tastefully elegant wet bar, adjacent to the dining area matches the countertops found in the kitchen and is complemented by a gas fireplace in the main living area. The primary suite features a generously sized walk-in closet and full bathroom. The second bedroom and bath are on the other side of the living room, providing a nice separation. The home has wall-to-wall white carpeting, except tile in the kitchen and baths. Including the walk-in, this roomy condo has five closets. A deeded parking space completes your new home. HOA amenities include an outdoor heated pool, fitness center with cardio, free weights, a sauna, whirlpool spa as well as walking trails through the landscaped grounds. EV charging too!

district__c,SF District 4

driveway_sidewalks__c,Paved Sidewalk,Sidewalk/Curb/Gutter

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,Sewer,Trash,Water

pba__hoafees__c,872

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;Natural Gas

interior_features__c,Open Beam Ceiling

ffd_lastmodifieddate,2024-05-12T18:47:33.000+0000

pba__latitude_pb__c,37.7467823

pba__latitude_property__c,37.7467823

laundry_features__c,Inside Room

listed_date__c,2024-03-22

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4405863

mls_id__c,424030539

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

master_property__c,a0O1I000001VhnpUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-05-10

open_house_end__c,2024-05-12T16:00:00.000+0000

open_house_start__c,2024-05-12T14:00:00.000+0000

original_price__c,975000

overall_days_on_market__c,-81944

parking_access__c,Side by Side

parking_features__c,Covered,Enclosed,EV Charging,Interior Access

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001zkBrMAI

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;Secured Access;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,1175

size__c,1175

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Diamond Heights

subdist__c,Diamond Heights

ffd_name,5140 Diamond Heights Boulevard #304A, San Francisco, CA, 94131

view__c,City;Panoramic;Bay;Downtown;Bay Bridge;San Francisco;Mountains;Mt Diablo;Bridges

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Bay Window(s);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/530776401-1.jpg

_yoast_indexnow_last_ping,1715205544

ffd_listing_title,1005 Duncan Street, San Francisco, CA, 94131

ffd_mls_id,424022955

ffd_salesforce_id,a0EUd000001vgLJMAY

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,1005 Duncan Street, San Francisco, CA, 94131

pba__address_pb__c,1005 Duncan Street, San Francisco, CA, 94131

agent_only_remarks__c,Offers due Tuesday 5/14 by noon.Pre-escrow opened with Mijael Schmidt at First American Title. For showings, or questions please contact Hanne Vastveit [email protected] 415.535.2550.

appliances__c,Dishwasher;Microwave;Disposal;Built-In Gas Range;Free Standing Refrigerator;Ice Maker;Free Standing Freezer

architectural_style__c,Mid-Century

bath_features__c,Tub w/Shower Over;Tub;Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1962

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-04T16:46:35.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,This elegantly remodeled Eichler home blends timeless architecture with modern luxury, epitomizing the essence of indoor-outdoor living. At the center of the home is an atrium filled with tropical plants and flooded by natural light, creating a perfect backdrop for relaxation and entertainment. The atrium connects the house's primary rooms through expansive floor-to-ceiling windows and sliding glass doors. The modern kitchen is a chef's delight, featuring marble countertops and beamed ceilings. The adjacent dining area opens onto a captivating patio with ambient lighting and a BBQ area. The living room has a fireplace and soaring ceilings, which presents a cozy, grand setting ideal for social gatherings. The primary suite hosts an ensuite spa-like bathroom and walk-in closet, with custom built-in shelves and drawers by Califonia Closets. Enjoy serene, one-level living with four spacious bedrooms, each thoughtfully designed to foster privacy and deep outdoor connection, and 2.5 baths. Additional highlights include Sunrun Solar System, an oversized landscaped backyard, newly remodeled bathrooms, and wood floors, all in a central location. This Eichler home offers a blend of design and lifestyle, embodying sophistication and effortless living.

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Covered Courtyard;Entry Gate

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Wood Burning

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

interior_features__c,Skylight(s);Open Beam Ceiling

ffd_lastmodifieddate,2024-05-08T21:47:43.000+0000

pba__latitude_pb__c,37.7451598

pba__latitude_property__c,37.7451598

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-03-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Hanne

pba__listing_agent_lastname__c,Vastveit

listing_agent_mls_id__c,815942

ffd_listingagentname,Hanne Vastveit

listing_agent_number__c,1074944

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,AVNU

listing_office_name__c,Avenue 8 Inc.

listing_office_number__c,28244

pba__listingprice_pb__c,2950000

pba__listingtype__c,Sale

pba__listing_website__c,https://fichelsonre.com/properties/1005-duncan-st

pba__longitude_pb__c,-122.4433592

lower_level__c,Bedroom(s),Dining Room,Full Bath(s),Garage,Kitchen,Living Room,Primary Bedroom,Street Entrance

mls_id__c,424022955

master_bathroom_features__c,Shower Stall(s);Tile;Window;Skylight/Solar Tube

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-05-04

open_house_end__c,2024-05-09T19:30:00.000+0000

open_house_start__c,2024-05-09T18:00:00.000+0000

original_price__c,2950000

overall_days_on_market__c,-81938

parking_access__c,Independent

parking_features__c,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Covered Deck;Front Porch

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2024-05-03T09:04:11.000+0000

price_per_square_foot__c,1574.17

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001vgLJMAY

room_type__c,Storage;Laundry;Atrium;Living Room;Solarium;Possible Guest;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,1874

size__c,1874

pba__state_pb__c,CA

stories__c,1

pba__street_pb__c,Duncan

subdist__c,Diamond Heights

ffd_name,1005 Duncan Street, San Francisco, CA, 94131

view__c,Garden/Greenbelt;Mountains;Sutro Tower

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

_yoast_indexnow_last_ping,1714784226

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

dom__c,28

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-05-04T00:47:57.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-05-05T16:00:00.000+0000

open_house_start__c,2024-05-05T14: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,1715425039

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

dom__c,44

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-05-11T10:47:45.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-05-11T16:00:00.000+0000

open_house_start__c,2024-05-11T14: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