555 Bartlett Street #416, San Francisco, CA, 94110 - Property Description

_yoast_indexnow_last_ping,1737159506

ffd_listing_title,2401 23rd Street, San Francisco, CA, 94110

ffd_mls_id,425003972

ffd_salesforce_id,a0EUd00000459wPMAQ

num_of_rooms__c,10

of_units__c,3

pba__address_pb__c,2401 23rd Street, San Francisco, CA, 94110

address2__c,2401 23rd Street, San Francisco, CA, 94110

agent_only_remarks__c,*Lower unit bathroom and kitchen has been updated. *remodeled kitchen and replaced dish washer from upstairs unit *All 3 units are vacant and easy to show. Prospective purchasers are advised to independently verify accuracy & to review any disclosure information before submitting offer. Property is sold AS-IS. Please include 'EMD to be wired within 24 hours of contract ratification. Disclosures to be returned, signed in its entirety, within 48 hours of ratification as a term in the purchase agreement. Buyer to investigate square footage to their own satisfaction. Neither seller nor LA shall guarantee accuracy of sq ft. Call/text Simon at 4158062610 or Kent at 4158287510 if you have any questions or want showing instructions. Offer date TBD.

appliances__c,Gas Water Heater;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1916

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2025-01-17T22:47:59.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This rare opportunity to own a fully vacant corner 3-unit Victorian building features two residential units (a 3-bedroom, 1-bath top unit and a 2-bedroom, 1-bath lower unit) and one commercial unit with a half bathroom and spacious storage in the basement. The property includes a detached 2-car side-by-side garage, providing much-needed parking and additional income potential. Located directly across from Zuckerberg San Francisco General Hospital, this property boasts a Walk Score of 92 and high foot traffic, making it ideal for an owner-occupier seeking supplemental income or an investor completing a 1031 exchange. Don't let this versatile and lucrative opportunity pass you by!

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

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry

ffd_lastmodifieddate,2025-01-17T23:48:06.000+0000

pba__latitude_pb__c,37.7543274

pba__latitude_property__c,37.7543274

laundry_features__c,Washer/Dryer Hookups

listed_date__c,2025-01-17

pba__listing_agent_email__c,simonshue@gmail.com

pba__listing_agent_firstname__c,Simon

pba__listing_agent_lastname__c,Shue

listing_agent_mls_id__c,807897

ffd_listingagentname,Simon C Shue

listing_agent_number__c,1028279

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4037971

mls_id__c,425003972

parkingspaces__c,2

on_market_date__c,2025-01-17

open_house_end__c,2025-01-18T17:00:00.000+0000

open_house_start__c,2025-01-18T13:00:00.000+0000

original_price__c,1299000

overall_days_on_market__c,-82196

parking_features__c,Covered,Detached,Garage,Side-by-Side

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,577.33

pba__propertytype__c,Triplex

ListingId,a0EUd00000459wPMAQ

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

size__c,2250

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,23rd

subdist__c,The Mission

ffd_name,2401 23rd Street, San Francisco, CA, 94110

website_property_type__c,Triplex

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1916

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1737159496

ffd_listing_title,2670 21st Street, San Francisco, CA, 94110

ffd_mls_id,425003102

ffd_salesforce_id,a0EUd00000450GUMAY

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,0

pba__address_pb__c,2670 21st Street, San Francisco, CA, 94110

address2__c,2670 21st Street, San Francisco, CA, 94110

agent_only_remarks__c,The lower level is unwarranted. Please use SFAR form for offer and include POF and lender reapproval. Disclosure are here:

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,0

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-01-17T19:48:19.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Welcome to this beautifully renovated 4-bedroom home, perfectly situated in the vibrant and walkable Mission District. Thoughtfully updated with a brand-new kitchen and bathrooms, this home also features gleaming hardwood floors and a marble-surround fireplace, combining modern elegance with timeless charm. The upper level offers two bedrooms, two baths, a living room, and a family room. Step outside to discover a tranquil garden oasis with a Koi pond, mini pool, and fruit trees including avocado, apple, and lemonperfect for relaxing or entertaining. The lower level, though unwarranted, includes two additional bedrooms, a sitting room, an office, and a bath, along with ample storage, a laundry room, and one-car interior parking. An additional exterior parking space completes this home's practicality. Located just steps from a cozy coffee shop and a short walk to acclaimed dining and entertainment options like Penny Roma, Lost Resort, and Flour + Water, this property embodies the charm and energy of the Mission District. Don't miss this rare opportunity to call it yours!

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Bamboo;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2025-01-17T23:46:48.000+0000

pba__latitude_pb__c,37.7578756

pba__latitude_property__c,37.7578756

listed_date__c,2025-01-14

pba__listing_agent_email__c,sherry@sherryjuneja.com

pba__listing_agent_firstname__c,Sherry

pba__listing_agent_lastname__c,Juneja

listing_agent_mls_id__c,808563

ffd_listingagentname,Sherry Juneja

listing_agent_number__c,1036824

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CTOR

listing_office_name__c,Keller Willams Realty

listing_office_number__c,23160

pba__listingprice_pb__c,1995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4083749

mls_id__c,425003102

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2025-01-17

open_house_end__c,2025-01-18T16:00:00.000+0000

open_house_start__c,2025-01-18T14:00:00.000+0000

original_price__c,1995000

overall_days_on_market__c,-82196

parking_access__c,Independent

parking_features__c,Attached

parking_type__c,On Site (Single Family 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,997.5

pba__propertytype__c,Single Family Residence

ListingId,a0EUd00000450GUMAY

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

size__c,2000

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,21st

subdist__c,The Mission

ffd_name,2670 21st Street, San Francisco, CA, 94110

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94110

_yoast_indexnow_last_ping,1737159484

ffd_listing_title,2412 Harrison Street #214, San Francisco, CA, 94110

ffd_mls_id,424083953

ffd_salesforce_id,a0EUd0000044tTRMAY

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,28

pba__address_pb__c,2412 Harrison Street #214, San Francisco, CA, 94110

address2__c,2412 Harrison Street #214, San Francisco, CA, 94110

agent_only_remarks__c,Showings by appointment. No lockbox. 2nd bedroom is open-walled with murphy bed; agents & seller make no warranty regarding number of legal bedrooms. Tax records show 2 MLS bedrooms. Differing square footage measurements: Buyers to measure to their own satisfaction. One of the listing agents lives in the building.

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

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2002

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Timothy G Fong

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s)

ffd_createddate,2025-01-17T17:46:59.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Spectacular top floor Mission loft residence with flexible floorplan, two private outdoor areas, gas fireplace, lovely built ins including a murphy bed in the open guest room/office, 2 wine fridges and a fully enclosed primary suite! Located in the back corner of the building far from the street and with no neighbors above, this spacious home features soaring 17 ft ceilings with a wall of west-facing windows to let the sunshine pour in. Windows on two sides allow for cross ventilation rarely available in most lofts. Steps to some of the top restaurants, cocktail bars, and cafes in the city. Just blocks to BART and tech shuttles. This secure video-access building includes an elevator, garage parking, high-speed Webpass internet access, and an expansive shared roof deck to take in those city views. Easy access to 101/280 and Bay Bridge. Do not miss this unique property.

district__c,SF District 9

driveway_sidewalks__c,Gated

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Gas Piped

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Internet,Maintenance Exterior,Management,Sewer,Trash,Water

pba__hoafees__c,797

pba__hoafrequency_pb__c,Monthly

hoa_name__c,2412 Harrison Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Gas;Fireplace(s)

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

ffd_lastmodifieddate,2025-01-17T23:46:43.000+0000

pba__latitude_pb__c,37.7584883

pba__latitude_property__c,37.7584883

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-10-24

pba__listing_agent_email__c,patrick@patricklowell.com

pba__listing_agent_firstname__c,Patrick

pba__listing_agent_lastname__c,Lowell

listing_agent_mls_id__c,806173

ffd_listingagentname,Patrick Lowell

listing_agent_number__c,195508294

listing_co_agent_mls_id__c,400313

listing_co_agent_number__c,400313

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4127952

mls_id__c,424083953

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

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

master_property__c,a0O1I000001VhqeUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-01-17

open_house_end__c,2025-01-18T16:00:00.000+0000

open_house_start__c,2025-01-18T14:00:00.000+0000

original_price__c,1249000

overall_days_on_market__c,-82196

parking_access__c,Side by Side

parking_features__c,Covered,Garage Door Opener,Side-by-Side

parking_type__c,On Site - Mapped (Condo 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,825.51

pba__propertytype__c,Condominium

ListingId,a0EUd0000044tTRMAY

room_type__c,Storage;Office;Kitchen;Loft;Living Room;Possible Guest;Media Room;Wine Storage Area;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,1513

size__c,1513

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Harrison

subdist__c,The Mission

ffd_name,2412 Harrison Street #214, San Francisco, CA, 94110

view__c,City;San Francisco

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2002

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1737083872

ffd_listing_title,2942 21st Street, San Francisco, CA, 94110

ffd_mls_id,425003602

ffd_salesforce_id,a0EUd0000044RgwMAE

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,4

pba__address_pb__c,2942 21st Street, San Francisco, CA, 94110

address2__c,2942 21st Street, San Francisco, CA, 94110

agent_only_remarks__c,Escrow opened with Paula Seigel at Fidelity National Title

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Built-In Freezer

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2019

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-01-16T19:47:42.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Modern 2 bedroom, 2.5 bath, + loft mezzanine condominium in the heart of the Mission district. Constructed in 2019 this condominium features a living room with double height ceilings and an open concept lifestyle. Cook in the kitchen while entertaining guests in the living room or at the kitchen peninsula. Modern appliances and w/d included. South West facing single family like home with many windows and direct access from 21st Street. No shared entryway with the other homes in the building. 2 large bedrooms on separate floors and a large mezzanine level which could be a play room, music area, office, or movie room. 1 car deeded parking included and a fantastic roof deck. Open your front door and walk to Tartine, Heath Ceramics, Flour and water, or countless other neighborhood hot spots in minutes. Minutes to transit or the freeway.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Sewer,Water

pba__hoafees__c,418

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

interior_features__c,Cathedral Ceiling

ffd_lastmodifieddate,2025-01-17T02:46:46.000+0000

pba__latitude_pb__c,37.757549

pba__latitude_property__c,37.757549

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Stacked Only

listed_date__c,2024-10-02

pba__listing_agent_email__c,marco@vanguardsf.com

pba__listing_agent_firstname__c,Marco

pba__listing_agent_lastname__c,Carvajal

listing_agent_mls_id__c,808180

ffd_listingagentname,Marco A Carvajal

listing_agent_number__c,1031722

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4133027

lower_level__c,Bedroom(s)

mls_id__c,425003602

main_level__c,Living Room;Dining Room;Family Room;Street Entrance

master_bathroom_features__c,Tub w/Shower Over;Double Sinks;Tile

master_property__c,a0OUd00000Dhl7SMAR

monthly_parking_fees__c,40

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-01-16

open_house_end__c,2025-01-19T16:00:00.000+0000

open_house_start__c,2025-01-19T14:00:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-82195

parking_access__c,Independent

parking_features__c,Mechanical Lift

parking_type__c,On Site - Assigned (Condo 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,1124.06

pba__propertytype__c,Condominium

ListingId,a0EUd0000044RgwMAE

room_type__c,Office;Bonus Room;Kitchen;Loft;Living Room;Game Room;Great 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,1330

size__c,1330

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,21st

subdist__c,The Mission

ffd_name,2942 21st Street, San Francisco, CA, 94110

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Window Coverings;Caulked/Sealed

pba__yearbuilt_pb__c,2019

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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