398 Vienna Street, San Francisco, CA, 94112 - Property Description

_yoast_indexnow_last_ping,1747013617

ffd_listing_title,42 Stoneybrook Avenue, San Francisco, CA, 94112

ffd_mls_id,425039015

ffd_salesforce_id,a0EUd00000503cXMAQ

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

pba__address_pb__c,42 Stoneybrook Avenue, San Francisco, CA, 94112

address2__c,42 Stoneybrook Avenue, San Francisco, CA, 94112

agent_only_remarks__c,Supra iBox will be installed on 05/13. Offer date will be set after the first weekend open house. Disclosures: https://app.disclosures.io/link/42-Stoneybrook-Avenue-ywc3g2xl Buyers and buyer's agents should perform their own due diligence in verifying the square footage. Please use SFAR purchase contract and include pre-approval and / or proof of funds and a signed cover page from the disclosure package. Escrow is opened with WFG Title. Escrow officer is Diana Ou-Yang.

appliances__c,Dishwasher;Hood Over Range;Built-In Gas Oven;Gas Cook Top

bath_features__c,Tub w/Shower Over;Tile

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1942

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2025-05-11T10:47:03.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Welcome to 42 Stoneybrook Ave, a charming single-family home built in 1942, ideally located near the Excelsior, Mission Terrace, and Portola neighborhoods. This bright and well-maintained 2-bedroom, 1-bath residence offers a great blend of character, comfort, and potential. The main level features a sunlit living room with a cozy fireplace, an open kitchen with a skylight, and two bedrooms that overlook the backyard. A skylight in the full bathroom further enhances the natural light throughout. The interior and exterior have been freshly painted, providing a clean and move-in-ready experience. Downstairs, the garage level includes one-car parking, laundry hookups, and open space with great potential for future development or customization (buyers to verify with the city). The backyard offers a sunny patio/deck, ideal for outdoor enjoyment and entertaining. With convenient access to public transportation, parks, restaurants, shopping, and highways 101 & 280, this home is a fantastic opportunity in one of San Francisco's most desirable neighborhoods.

district__c,SF District 10

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Fireplace(s)

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2025-05-12T00:46:33.000+0000

pba__latitude_pb__c,37.7302202

pba__latitude_property__c,37.7302202

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

listed_date__c,2025-05-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jack

pba__listing_agent_lastname__c,Ho

listing_agent_mls_id__c,809859

ffd_listingagentname,Jack Ho

listing_agent_number__c,1043834

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COLD03

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,875

pba__listingprice_pb__c,898000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4219943

lower_level__c,Garage,Street Entrance

mls_id__c,425039015

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-05-11

open_house_end__c,2025-05-13T14:00:00.000+0000

open_house_start__c,2025-05-13T12:00:00.000+0000

original_price__c,898000

overall_days_on_market__c,-82310

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd00000503cXMAQ

road_surface_type__c,Paved

roof__c,Composition;Shingle

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Stoneybrook

subdist__c,Excelsior

ffd_name,42 Stoneybrook Avenue, San Francisco, CA, 94112

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1942

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1746803835

ffd_listing_title,682 London Street, San Francisco, CA, 94112

ffd_mls_id,425037618

ffd_salesforce_id,a0EUd000004zCroMAE

num_of_fireplaces__c,0

num_of_rooms__c,8

of_units__c,0

pba__address_pb__c,682 London Street, San Francisco, CA, 94112

address2__c,682 London Street, San Francisco, CA, 94112

agent_only_remarks__c,*** Lockbox will be installed after first open house weekend *** Please contact Fred Meng at 415-828-1205 or [email protected] with any questions or for disclosures.

appliances__c,Gas Water Heater;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Ice Maker;Gas Cook Top

architectural_style__c,Marina

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1928

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Fred Meng

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-05-09T10:48:37.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Welcome to this charming semi-detached residence that blends timeless San Francisco character with stylish modern updates and captivating outdoor spaces. Offering 1,735 sq ft of living space on a 2,500 sq ft lot, this residence features refinished hardwood floors, upgraded lighting, and freshly painted interiors. The main level boasts a sunlit living room with bay windows and a decorative fireplace, a spacious dining room ideal for lively gatherings, a modern kitchen with stainless steel appliances with bar seating, and a bright breakfast nook. Two generous bedrooms with walk-in closets and a stylish full bath complete this floor. The recently renovated lower level offers a versatile family room with a wet bar, full bath, and third bedroom-perfect for guests, a home office, or creative space. Step outside to a professionally designed, multi-tiered backyard with built-in planters, lounge areas, and city views-ideal for relaxing, hosting, or gardening. Located near City College, vibrant shops and dining on Mission Street and Ocean Avenue, green spaces like Balboa Park, Crocker Amazon Park, and McLaren Park. For commuters, the nearby HWY 280, multiple Muni lines, and Balboa Park BART station make traveling throughout the city and beyond a breeze.

district__c,SF District 10

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood;Parquet

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas;Fireplace(s)

interior_features__c,Storage Area(s)

ffd_lastmodifieddate,2025-05-09T14:47:25.000+0000

pba__latitude_pb__c,37.7184727

pba__latitude_property__c,37.7184727

laundry_features__c,In Garage;Inside Area;Washer Included;Dryer Included;Gas Hook-Up

listed_date__c,2025-05-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Wesley

pba__listing_agent_lastname__c,Wong

listing_agent_mls_id__c,819235

ffd_listingagentname,Wesley Wong

listing_agent_number__c,1077913

listing_co_agent_mls_id__c,810913

listing_co_agent_number__c,1048658

listing_co_office_mls_id__c,DREIM

listing_co_office_name__c,DREIM

listing_co_office_number__c,29081

listing_office_mls_id__c,DREIM

listing_office_name__c,DREIM

listing_office_number__c,29081

pba__listingprice_pb__c,1295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4387337

lower_level__c,Bedroom(s),Family Room,Garage,Primary Bedroom

mls_id__c,425037618

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-05-09

open_house_end__c,2025-05-10T16:00:00.000+0000

open_house_start__c,2025-05-10T14:00:00.000+0000

original_price__c,1295000

overall_days_on_market__c,-82308

parking_access__c,Independent

parking_features__c,Enclosed,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,746.4

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004zCroMAE

room_type__c,Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater

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

size__c,1735

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,London

subdist__c,Excelsior

ffd_name,682 London Street, San Francisco, CA, 94112

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1928

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1747048660

ffd_listing_title,635 Moscow Street, San Francisco, CA, 94112

ffd_mls_id,425037947

ffd_salesforce_id,a0EUd000004zCrgMAE

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

pba__address_pb__c,635 Moscow Street, San Francisco, CA, 94112

address2__c,635 Moscow Street, San Francisco, CA, 94112

agent_only_remarks__c,No lockbox, but happy to show. For private showings and disclosures, please contact Heather Kennedy at (650) 773-1326 or [email protected].

appliances__c,Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker;Plumbed For Ice Maker;Gas Plumbed

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1915

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-05-09T10:48:37.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Behold, a San Francisco treasure! This cherished home, passed between only two families in over a century, now awaits its third custodian. Stepping into the living room, you're immediately greeted by tall ceilings, beautiful custom arches and windows that bathe the room in natural light. Reimagined to suit a host's lifestyle, the sizeable dining room awaits your friends and family for gatherings and celebrations. A modern chef's kitchen, complete with a commercial-grade Wolf range and Fisher & Paykel fridge, is the natural gathering place for community and chatter. With multiple flexible spaces ready for your vision, this home invites creativity. 635 Moscow Street has expertly and gracefully realized much of its potential, yet still offers room to grow --an ideal canvas for the next chapter. Retreat to the inviting backyard, where fresh-grown citrus thrives in the privacy created by the manicured trees. Gaze at the stars while sitting on custom benches that surround your Restoration Hardware fire pit. Revel in a neighborhood that offers every possible amenity - proximity to McLaren Park, Crocker Amazon Playground, schools, shops and eateries. This meticulously cared-for home is awaiting the next generation of memories.

district__c,SF District 10

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Wood

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

interior_features__c,Formal Entry;Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2025-05-12T10:47:06.000+0000

pba__latitude_pb__c,37.7175023

pba__latitude_property__c,37.7175023

laundry_features__c,In Garage;Washer Included;Dryer Included;Sink

listed_date__c,2025-03-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Heather

pba__listing_agent_lastname__c,Kennedy

listing_agent_mls_id__c,816634

ffd_listingagentname,Heather Kennedy

listing_agent_number__c,1075591

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP41

listing_office_name__c,Compass

listing_office_number__c,27887

pba__listingprice_pb__c,899000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.635moscow.com/

pba__longitude_pb__c,-122.4301904

lower_level__c,Garage

mls_id__c,425037947

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

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,3

on_market_date__c,2025-05-09

open_house_end__c,2025-05-13T16:00:00.000+0000

open_house_start__c,2025-05-13T14:00:00.000+0000

original_price__c,899000

overall_days_on_market__c,-82308

parking_access__c,Tandem

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Size Limited,Tandem Garage

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004zCrgMAE

road_surface_type__c,Asphalt,Paved

sale_date__c,1800-01-01

sale_price__c,0

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Moscow

subdist__c,Excelsior

ffd_name,635 Moscow Street, San Francisco, CA, 94112

view__c,Mountains

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Coverings

pba__yearbuilt_pb__c,1915

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1746847096

ffd_listing_title,627 London Street, San Francisco, CA, 94112

ffd_mls_id,425025295

ffd_salesforce_id,a0EUd000004dncsMAA

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

pba__address_pb__c,627 London Street, San Francisco, CA, 94112

address2__c,627 London Street, San Francisco, CA, 94112

agent_only_remarks__c,This is a trustee sale. Trustee has authority to sell property. Disclosure Package Link: https://app.disclosures.io/link/627-London-Street-wzen0me9

appliances__c,Free Standing Gas Oven;Free Standing Refrigerator

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-03-31T18:47:51.000+0000

days_on_market__c,39

dom__c,32

ffd_description_pb,Located in the heart of the Excelsior, this home has been in the same family for over 50 years. The banana yellow facade is recent but wait until you walk up the terrazzo stairs. Inside there are two full bedrooms, and a bonus room (often used as a bedroom or office) that looks over the backyard. There is nothing more gorgeous that beautiful wood floors. This home has beautifully redone softwood floors with amazing natural details. Which means, when you visit, you're gonna need to take off those high heel shoes! The formal living room has bay windows that look north and has amazing view from City College across to Sutro Tower. The dining room is big enough for that 12 person full-sized dining room table... and did I mention the gorgeous floors? The eat-in kitchen has a step-down pantry and is super-bright with lots of windows and it's going to be a great project for the buyer with imagination. Out back is a full-width backyard that just says - opportunity! Downstairs is a full depth garage big enough for several vehicles and LOTS of storage.

district__c,SF District 10

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Linoleum;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Fireplace(s)

ffd_lastmodifieddate,2025-05-10T02:47:00.000+0000

pba__latitude_pb__c,37.7191024

pba__latitude_property__c,37.7191024

laundry_features__c,In Garage;Upper Floor;Inside Area;Washer Included;Dryer Included;Gas Hook-Up

listed_date__c,2025-03-31

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Herb

pba__listing_agent_lastname__c,Alston

listing_agent_mls_id__c,802541

ffd_listingagentname,Herb Alston

listing_agent_number__c,802541

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,985000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=4mHfsJPqrKA

pba__longitude_pb__c,-122.4377111

mls_id__c,425025295

main_level__c,Bedroom(s);Living Room;Dining Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2025-03-31

open_house_end__c,2025-05-11T16:00:00.000+0000

open_house_start__c,2025-05-11T14:00:00.000+0000

original_price__c,985000

overall_days_on_market__c,-82269

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Garage Facing Front,Tandem Garage

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004dncsMAA

road_surface_type__c,Asphalt

room_type__c,Office;Kitchen;Living Room;Dining Room

sale_date__c,1800-01-01

sale_price__c,0

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

size__c,1131

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,London

subdist__c,Excelsior

ffd_name,627 London Street, San Francisco, CA, 94112

view__c,City;Hills

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Bay Window(s)

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94112

ffd_media,Array

ffd_media_tags,Array

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