3820 Mission Street, San Francisco, CA, 94110 - Property Description

_yoast_indexnow_last_ping,1726163722

ffd_listing_title,462 Prentiss Street, San Francisco, CA, 94110

ffd_mls_id,424054714

ffd_salesforce_id,a0EUd0000035dbhMAA

num_of_fireplaces__c,0

num_of_rooms__c,10

of_units__c,0

address2__c,462 Prentiss Street, San Francisco, CA, 94110

pba__address_pb__c,462 Prentiss Street, San Francisco, CA, 94110

agent_only_remarks__c,Check out website: www.ModernPrentiss.com. Offer date to be announced.

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-12T12:46:56.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Indulge in contemporary luxury in this newly built three-level residence in Bernal Heights. The open floor plan invites seamless living and entertaining, with high-end stainless steel Thermador appliances and sleek quartz countertops in the kitchen. Large NanaWall doors connect indoor and outdoor spaces, leading to a tranquil landscaped garden. Natural light floods the interiors, and sweeping views of the East Bay captivate from multiple vantage points within the home. Ascend to the upper levels via a stunning floating wood staircase encased in glass. The residence also offers a flexible garage space, catering to diverse lifestyle needs. Situated near the bustling Cortland shopping corridor, residents enjoy easy access to cafes, restaurants, the Good Life Grocery, and essential amenities. With proximity to the freeway, commuting to other parts of the city and beyond is effortless, ensuring both convenience and connectivity. This impeccably designed home in Bernal Heights represents a rare opportunity to embrace luxurious contemporary living in one of San Francisco's most sought-after neighborhoods.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-09-12T17:47:18.000+0000

pba__latitude_pb__c,37.7374708

pba__latitude_property__c,37.7374708

listed_date__c,2024-07-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Castaldini

listing_agent_mls_id__c,805355

ffd_listingagentname,Frank A Castaldini

listing_agent_number__c,166015256

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.prentissmodern.com/

pba__longitude_pb__c,-122.4123668

mls_id__c,424054714

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-12

original_price__c,2200000

overall_days_on_market__c,-82069

parking_access__c,Tandem

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000035dbhMAA

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

size__c,1974

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Prentiss

subdist__c,Bernal Heights

ffd_name,462 Prentiss Street, San Francisco, CA, 94110

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726102652

ffd_listing_title,603 Ellsworth Street, San Francisco, CA, 94110

ffd_mls_id,424063412

ffd_salesforce_id,a0EUd0000034lzVMAQ

num_of_fireplaces__c,1

num_of_rooms__c,8

of_units__c,0

address2__c,603 Ellsworth Street, San Francisco, CA, 94110

pba__address_pb__c,603 Ellsworth Street, San Francisco, CA, 94110

agent_only_remarks__c,Please open escrow with Christine Lim, Old Republic Title Company, [email protected]

appliances__c,Dishwasher;Gas Water Heater;Microwave;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Edwardian;Traditional

bath_features__c,Shower Stall(s);Tile;Low-Flow Toilet(s);Outside Access

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1929

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Carren S Shagley

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-10T18:47:26.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Step into the allure of this 1929 Bernal Heights home, that invites for an in-person tour. The upper level features a bright living room with extended double-paned windows, original wood floors, elegant sconces, and a cozy brick fireplace. The living area flows into a formal dining room through double glass doors leading to a remodeled eat-in kitchen with granite countertops, stainless steel appliances, and newer cabinets. Two generous bedrooms and two renovated bathrooms, including an en suite with garden access, complete this level. The versatile lower level offers 2 additional bedrooms and a full bath (shower only). The rear bedroom, ideal as a family or media room, opens to the garden. An attached garage provides ample storage with internal access. Enjoy a compact, level yard with a mature tree and a fruit-bearing fig tree, perfect for BBQs or relaxing. Conveniently located within walking distance to Cortland & Mission thoroughfares, 603 Ellsworth offers easy access to the 101 and 280 freeways and the Alemany Farmer's Market. Don't miss the opportunity to make 603 Ellsworth your new address in Bernal Heights!

district__c,SF District 9

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Fenced

fireplace_features__c,Living Room;Brick

pba__floortype_pb__c,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-09-12T00:47:21.000+0000

pba__latitude_pb__c,37.7357958

pba__latitude_property__c,37.7357958

laundry_features__c,Laundry Closet;Inside Area;Ground Floor;Washer Included;Dryer Included;Gas Hook-Up

listed_date__c,2024-08-05

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

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/aXITrBzZlLs

pba__longitude_pb__c,-122.4147135

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

mls_id__c,424063412

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

master_bathroom_features__c,Low-Flow Toilet(s);Window;Stone;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-10

open_house_end__c,2024-09-12T19:00:00.000+0000

open_house_start__c,2024-09-12T17:30:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-82067

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Interior Access

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000034lzVMAQ

road_surface_type__c,Asphalt

room_type__c,Storage;Laundry;Kitchen;Living Room;Baths Other;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

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

size__c,1663

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Ellsworth

subdist__c,Bernal Heights

ffd_name,603 Ellsworth Street, San Francisco, CA, 94110

view__c,City

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1929

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1725889946

ffd_listing_title,115 Bronte 115A Street, San Francisco, CA, 94110

ffd_mls_id,424063705

ffd_salesforce_id,a0EUd0000033iKXMAY

num_of_rooms__c,8

of_units__c,2

address2__c,115 Bronte 115A Street, San Francisco, CA, 94110

pba__address_pb__c,115 Bronte 115A Street, San Francisco, CA, 94110

agent_only_remarks__c,The Upper unit is tenant occupied. The tenants will not turn in a protected status addendum or an estoppel. Please note that one of the tenants has a fragrance and dye allergy so no aftershave, scents or items washed with fragrance like a dryer sheet. We negotiated Tuesday/Thursday 2-4 pm for showings. Lower level owner's unit is one bedroom and can be shown with notice. There is a space below the owner's unit which is storage but shown as an artist's studio. Trustee sale. Disclosure package is ready.

architectural_style__c,Arts & Crafts

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,3

year_build_text__c,1924

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-09T10:49:25.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Charming 1920's duplex with views in sunny Bernal Heights. Upper unit is two-bedroom/one bath with deck (tenant occupied). Lower level owner's unit (vacant) is one bedroom/one bath with a lovely bonus area down that was used an artist's space. One car parking and rear yard goes with the owner's unit.

district__c,SF District 9

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-09T13:47:23.000+0000

pba__latitude_pb__c,37.7485824

pba__latitude_property__c,37.7485824

laundry_features__c,In Each Unit;Washer/Dryer Owned

listed_date__c,2024-08-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Amanda

pba__listing_agent_lastname__c,Jones

listing_agent_mls_id__c,803622

ffd_listingagentname,Amanda M Jones

listing_agent_number__c,803622

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,899000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4184108

mls_id__c,424063705

parkingspaces__c,1

on_market_date__c,2024-09-09

open_house_end__c,2024-09-10T16:00:00.000+0000

open_house_start__c,2024-09-10T14:00:00.000+0000

original_price__c,899000

overall_days_on_market__c,-82066

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,516.07

pba__propertytype__c,Duplex

ListingId,a0EUd0000033iKXMAY

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

size__c,1742

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Bronte

subdist__c,Bernal Heights

ffd_name,115 Bronte 115A Street, San Francisco, CA, 94110

view__c,City Lights;Bay;Water;San Francisco;Hills

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1924

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1725965644

ffd_listing_title,120 Brewster Street, San Francisco, CA, 94110

ffd_mls_id,424061129

ffd_salesforce_id,a0EUd0000033DYaMAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,120 Brewster Street, San Francisco, CA, 94110

pba__address_pb__c,120 Brewster Street, San Francisco, CA, 94110

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator

architectural_style__c,Contemporary

bath_features__c,Shower Stall(s);Tub;Tile

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,3

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Edward R Deleski

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-06T20:48:41.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,120 Brewster Street is a stunning, newly completed, modern single-family home in Bernal Heights, one of San Francisco's premier neighborhoods. Designed by Vaso Peritos, this luxurious residence with extraordinary finishes spans 4 levels and features a dramatic center staircase and a stunning roof terrace with sweeping views of San Francisco and the Bay. The main level offers seamless indoor-outdoor dining and entertaining, with an open-concept great room leading to a spacious terrace, a Chef's kitchen with Dacor and Bertazzoni appliances, stunning cabinetry, a dramatic porcelain waterfall island, a built-in wet bar, and a powder room. Entry level 2-car garage and a formal foyer leads to the second floor with two ensuite bedrooms and a laundry room. The fourth floor houses the primary suite with custom paneling, Bay views, and a spa-like bathroom with a soaking tub, large shower, and floating double vanity. This level also includes an office / media room and a guest bathroom. The location offers proximity to Cortland Avenue's shops and dining, several area parks, a nearby community garden, and easy access to a number of neighborhoods and attractions, including the Mission District, Chase Center, and major routes via Interstate 280 and Highway 101.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant Floor;Central;MultiZone

interior_features__c,Formal Entry;Wet Bar

ffd_lastmodifieddate,2024-09-10T10:49:03.000+0000

pba__latitude_pb__c,37.7448286

pba__latitude_property__c,37.7448286

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

listed_date__c,2024-09-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jean-Paul

pba__listing_agent_lastname__c,Samaha

listing_agent_mls_id__c,804997

ffd_listingagentname,Jean-Paul Samaha

listing_agent_number__c,166014752

listing_co_agent_mls_id__c,807512

listing_co_agent_number__c,1020319

listing_co_office_mls_id__c,VANG02

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,166013449

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,3495000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4072015

lower_level__c,Bedroom(s),Full Bath(s),Garage,Street Entrance

mls_id__c,424061129

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-06

open_house_end__c,2024-09-10T16:00:00.000+0000

open_house_start__c,2024-09-10T14:00:00.000+0000

original_price__c,3495000

overall_days_on_market__c,-82063

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;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,1365.23

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000033DYaMAM

road_surface_type__c,Asphalt

room_type__c,Kitchen;Great Room;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Video System;Security System Owned

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

size__c,2560

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Brewster

subdist__c,Bernal Heights

ffd_name,120 Brewster Street, San Francisco, CA, 94110

view__c,Bay;San Francisco

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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