35 Keystone Way, San Francisco, CA, 94127 - Property Description

_yoast_indexnow_last_ping,1713492062

ffd_listing_title,612 Dorado Terrace #8, San Francisco, CA, 94112

ffd_mls_id,424025215

ffd_salesforce_id,a0EUd000001mANyMAM

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,0

address2__c,612 Dorado Terrace #8, San Francisco, CA, 94112

pba__address_pb__c,612 Dorado Terrace #8, San Francisco, CA, 94112

agent_only_remarks__c,Escrow Details: Please open escrow with Nate Scharton - Old Republic Title. Inspections completed.This is an as is sale Please only write offers on SFAR contracts only. Open House Schedule:4/23 Tues 1-3pm Broker Tour, 4/25 Thurs 5pm-6:30pm, 4/26 Fri 5pm-6:30pm, 4/27 Sat 11am - 1pm, 4/28 Sun 2pm-4pm, 4/30 Tues 1pm-3pm Broker Tour, 05/1 Wed 5-6:30pm, 5/2 Thurs Offers Welcome at 1pm

bath_features__c,Tub w/Shower Over;Shower Stall(s);Double Sinks

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1985

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-18T18:47:12.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,612 Dorado Terrace is a sophisticated multi-level townhome in San Francisco, nestled between Mount Davidson Manor and Westwood Park. It features two spacious primary suites with en-suite marble bathrooms and dual sinks. The flowing floor plan includes hardwood floors and a living room with elegant wood cabinetry, a marble appointed powder room, and an eat-in kitchen with a functional island and modern appliances. Outdoors, enjoy a sunny deck with a cozy seating area. Includes a large two car garage with laundry. Plenty of room for storage. Located in a walkable neighborhood close to shops, restaurants, and transit, this home combines luxury with convenience for a premium urban living experience.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

hoa_fee_includes__c,Maintenance Exterior,Maintenance Grounds,Water

pba__hoafees__c,462

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

interior_features__c,Storage Area(s)

ffd_lastmodifieddate,2024-04-19T01:47:00.000+0000

pba__latitude_pb__c,37.725627

pba__latitude_property__c,37.725627

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2024-04-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Heidi

pba__listing_agent_lastname__c,Rossi

listing_agent_mls_id__c,800916

ffd_listingagentname,Heidi I Rossi

listing_agent_number__c,800916

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,999000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.461631

lower_level__c,Kitchen,Living Room,Partial Bath(s)

mls_id__c,424025215

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

master_bathroom_features__c,Tub w/Shower Over;Double Sinks

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-18

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

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

original_price__c,999000

overall_days_on_market__c,-81922

parking_access__c,Independent

parking_features__c,Attached

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck

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

pba__propertytype__c,Townhouse

ListingId,a0EUd000001mANyMAM

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

size__c,1332

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Dorado

subdist__c,Mount Davidson Manor

ffd_name,612 Dorado Terrace #8, San Francisco, CA, 94112

website_property_type__c,Townhouse

pba__yearbuilt_pb__c,1985

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713747345

ffd_listing_title,1 North Gate Drive, San Francisco, CA, 94127

ffd_mls_id,424022295

ffd_salesforce_id,a0EUd000001jZM7MAM

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,1 North Gate Drive, San Francisco, CA, 94127

pba__address_pb__c,1 North Gate Drive, San Francisco, CA, 94127

agent_only_remarks__c,On SUPRA, go and show. Questions? Text Charles Loiacono at 732-670-6860. Pre-Escrow opened with Barbara Jimenez, Chicago Title, #3652300477. Disclosures via Disclosures iO, https://app.disclosures.io/link/1-Northgate-Drive-t54l2xt3 Buyer to cooperate with seller's 1031 Exchange. website - http://www.embracetheview.com/. Seller conducting 1031 Exchange. Street is known as "Northgate" but MLS entry only accepted North Gate. Offer Date Wednesday, April 24, 11AM, upload to Disclosures iO.

appliances__c,Dishwasher;Hood Over Range;Free Standing Refrigerator;Gas Cook Top;Built-In Electric Oven

architectural_style__c,Mid-Century

bath_features__c,Shower Stall(s)

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1957

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Sabrina Gee-Shin

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-04-15T10:47:44.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,1 Northgate Drive is a handsome Mid-century home in coveted Mount Davidson Manor. This corner home gets great natural light and has stunning hill and ocean views. The home has an exceptional layout with 3 large bedrooms and 2 bathrooms all on the same level. The main level also features a spacious living room, formal dining room, kitchen, breakfast nook and laundry room. New roof (2023), polished wood floors and freshly painted interior and exterior. This home awaits your personal touch to create a luxurious ensuite and kitchen of your dreams. The rear patio is perfect for entertaining guests, enjoying as your own private sanctuary, or for hosting kiddie and doggie playdates. The large 2-car garage has plenty of storage and functionality. You might even be able to fit a third compact car or consider developing the entire level. Near Whole Foods, West Portal Village, Ocean Avenue, Stonestown Mall, Lake Merced, Stern Grove, Balboa Park. Public Transit: K-Ingleside, 23, 29, 43, 91. Easy access to 280/101 Freeways.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Wood

fireplace_features__c,Wood Burning;Brick

pba__floortype_pb__c,Laminate;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Formal Entry;Storage Area(s)

ffd_lastmodifieddate,2024-04-22T00:46:39.000+0000

pba__latitude_pb__c,37.80803565

pba__latitude_property__c,37.80803565

laundry_features__c,Inside Room;Inside Area;Washer Included;Dryer Included

listed_date__c,2023-08-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Charles

pba__listing_agent_lastname__c,Loiacono

listing_agent_mls_id__c,811340

ffd_listingagentname,Charles Loiacono

listing_agent_number__c,1050901

listing_co_agent_mls_id__c,804986

listing_co_agent_number__c,166014733

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1828000

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/PPfVC3Lc5O4

pba__longitude_pb__c,-122.47635351

lower_level__c,Garage

mls_id__c,424022295

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom

master_bathroom_features__c,Tub w/Shower Over

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,4

on_market_date__c,2024-04-15

open_house_end__c,2024-04-21T15:00:00.000+0000

open_house_start__c,2024-04-21T13:00:00.000+0000

original_price__c,1828000

overall_days_on_market__c,-81919

parking_access__c,Side by Side

parking_features__c,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side,Uncovered Parking Space,Workshop in Garage

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,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,941.3

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001jZM7MAM

roof__c,Composition;Shingle

room_type__c,Storage;Laundry;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom

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

size__c,1942

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,North Gate

subdist__c,Mount Davidson Manor

ffd_name,1 North Gate Drive, San Francisco, CA, 94127

view__c,Ocean;Hills

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Screens

pba__yearbuilt_pb__c,1957

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713909357

ffd_listing_title,22 Fairfield Avenue, San Francisco, CA, 94127

ffd_mls_id,423924174

ffd_salesforce_id,a0EUd000001eMPSMA2

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,0

address2__c,22 Fairfield Avenue, San Francisco, CA, 94127

pba__address_pb__c,22 Fairfield Avenue, San Francisco, CA, 94127

agent_only_remarks__c,BOM, no fault of the seller. Disclosures: https://app.disclosures.io/link/22-Fairfield-Way-1tqr6vkk . Pre-escrow opened with Old Republic Title Christine Lin #0216038397. Email questions to [email protected] or text call listing agent @ 415-570-3090.

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

bath_features__c,Shower Stall(s);Low-Flow Toilet(s);Skylight/Solar Tube;Low-Flow Shower(s)

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,5

year_build_text__c,1928

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-04-04T16:46:21.000+0000

days_on_market__c,19

dom__c,19

ffd_description_pb,Nestled in the highly sought-after Mount Davidson Manor Neighborhood, this extensively renovated, fully-detached single family house comes with 5-bedroom, 4-bathroom in a 2,584 Sq ft of generous living space and a rare 4,120 Sq ft lot. Back side has a beautiful redwood deck leading into the well-designed landscaped, low-maintenance yard. A perfect retreat for those who appreciate the finer things in life. Throughout the house, it is boasting with exceptional natural light from the skylights, designer details, and well-thought-out floor plan. As you enter the property, you would be attracted by the open-floor concept living room anchored by a modern fireplace. Hardwood flooring throughout. Kitchen has modern and custom built cabinetry, high-end stainless steel appliances, eat-in island, and multiple skylines with LED recessed lightings. The lower level features a spacious family room with a fireplace. magnificent master bedroom, guest room, and a bathroom. It has an entry into the charming backyard. Close proximity to commercial district on Ocean Ave, historical Ingleside Terrace, and Stonestown shopping mall. Easy access to highways and public transportation with walking distance.

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Family Room

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry;Skylight(s);Wet Bar

ffd_lastmodifieddate,2024-04-23T21:46:42.000+0000

pba__latitude_pb__c,37.7263795

pba__latitude_property__c,37.7263795

laundry_features__c,Laundry Closet;Hookups Only;Inside Area

listed_date__c,2024-01-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Shu

pba__listing_agent_lastname__c,Pu

listing_agent_mls_id__c,806281

ffd_listingagentname,Shu Pu

listing_agent_number__c,166016663

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CAFH

listing_office_name__c,CENTURY 21 Real Estate Alliance

listing_office_number__c,166014509

pba__listingprice_pb__c,2295000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/928137315

pba__longitude_pb__c,-122.4633

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage,Primary Bedroom,Street Entrance

mls_id__c,423924174

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-04

original_price__c,2295000

overall_days_on_market__c,-81908

parking_access__c,Independent

parking_features__c,Covered,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001eMPSMA2

roof__c,Bitumen

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

size__c,2584

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Fairfield

subdist__c,Mount Davidson Manor

ffd_name,22 Fairfield Avenue, San Francisco, CA, 94127

view__c,City;City Lights

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1928

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

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