155 Caselli Avenue, San Francisco, CA, 94114 - Property Description

_yoast_indexnow_last_ping,1715036254

ffd_listing_title,4416 18th 4420 Street, San Francisco, CA, 94114

ffd_mls_id,423920010

ffd_salesforce_id,a0E8W00000dxGaIUAU

num_of_rooms__c,13

of_units__c,3

address2__c,4416 18th 4420 Street, San Francisco, CA, 94114

pba__address_pb__c,4416 18th 4420 Street, San Francisco, CA, 94114

agent_only_remarks__c,Please email or call Rachel Abraham-Pollard at [email protected] or 415.828.3964 for more information.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,6

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-10-31T20:48:35.000+0000

days_on_market__c,189

dom__c,170

ffd_description_pb,4416-4420 18th Street is a three unit mixed-use building in Eureka Valley, a few blocks from the heart of the Castro retail district. The property is tucked away on a tree-lined block making it a unique asset to the location. The ground floor is occupied by a successful restaurant. The business is currently on a month-to-month lease, but has expressed interest in signing a longer term lease, which will provide stability for both the tenant and new owner. Upstairs are two large flats. Both units are currently used as 3bd. Each has high-ceilings, hardwood floors, built-in cabinets, and period charm. Both units are rented significantly below market rate. The property is professionally managed and well maintained. This is an excellent opportunity to purchase a mixed-use asset in a strong location at an entry level price. Only $357 per square foot!

district__c,SF District 5

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-05-06T22:49:07.000+0000

pba__latitude_pb__c,37.760799

pba__latitude_property__c,37.760799

listed_date__c,2023-10-30

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Adam

pba__listing_agent_lastname__c,Filly

listing_agent_mls_id__c,803097

ffd_listingagentname,Adam D Filly

listing_agent_number__c,803097

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP13

listing_office_name__c,Compass Commercial

listing_office_number__c,27689

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.438716

mls_id__c,423920010

parkingspaces__c,0

on_market_date__c,2023-10-30

original_price__c,1650000

overall_days_on_market__c,-81751

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,332.14

pba__propertytype__c,Triplex

ListingId,a0E8W00000dxGaIUAU

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

size__c,4200

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,18th

subdist__c,The Castro - Dolores Heights

ffd_name,4416 18th 4420 Street, San Francisco, CA, 94114

website_property_type__c,Triplex

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715036545

ffd_listing_title,234 Eureka Street, San Francisco, CA, 94114

ffd_mls_id,424030585

ffd_salesforce_id,a0EUd000001wJphMAE

num_of_fireplaces__c,0

num_of_rooms__c,9

of_units__c,0

address2__c,234 Eureka Street, San Francisco, CA, 94114

pba__address_pb__c,234 Eureka Street, San Francisco, CA, 94114

agent_only_remarks__c,Showings start AFTER 1st open house on Tuesday, May 7, May 7, 2024. Handsome and warm, updated Queen Anne Victorian with luxe, private plant- and fun-filled yard, sought-after 3-bed, 2-bath, top level. Updated in 2017, refined in 2024 with creature comforts, natural light, scale and thoughtful touches. Solar panels, radiant heat, structural updates, EV outlet, lush landscaping. Recent front step restoration work completed (w/permits). Disclosures via disclosures io starting 5/8. Please start Q+A section before asking questions (as most will be answered there). Showing requests via text to BOTH agents, Jonathan, 415.215.4393 AND Kevin, 415.297.7462, or email both at [email protected]. Offer date, if any, TBD. Escrow should remain with Mike Schmidt and Leslie Hom at First American. Visit 234-Eureka.com for floor plans, MatterPort, Video link and more.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Ice Maker;Built-In Refrigerator;Gas Plumbed

architectural_style__c,Contemporary;Victorian

bath_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Skylight/Solar Tube;Low-Flow Shower(s)

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1904

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Jonathan B McNarry

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-06T19:47:43.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Nestled between the Castro and Noe Valley, 234 Eureka Street presents a meticulously updated, stylish Queen Anne Victorian single-family home, seamlessly merging timeless charm with modern convenience. Renovated in 2017 and refined in 2024, this three-story gem offers 4 bedrooms, 3.5 baths, over a 1-car garage. Bathed in natural light, the home exudes a warm and inviting ambiance across its versatile layout. Enter through the front porch and formal entry (complete with an actual closet), leading to a spacious living room with a bay window. Next, you'll see the showcase chef's kitchen with a large island, ideal for gatherings and informal meals. The sunny formal dining room opens to 234's sunny rear garden, which given 234's 125-foot-deep parcel, is considerable and wonderful. Upstairs, 234 has the coveted 3-bed, 2-bath layout, including an en suite primary bedroom boasting skyline views. The lower level features a second living room, bedroom, and bathroom, with access to both Eureka Street and the stunning backyard. 234 is equipped with solar panels, dual-pane windows, an EV charging-capable garage, radiant heated floors, modern designer LED lighting, in-ceiling speakers and Nest thermostats, 234 blends timeless elegance with contemporary energy efficiency. Eureka, you found it!

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

electric__c,220 Volts,Photovoltaics Seller Owned

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

pba__heatingtype_pb__c,Radiant Floor;Gas

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

ffd_lastmodifieddate,2024-05-06T22:48:08.000+0000

pba__latitude_pb__c,37.7584158

pba__latitude_property__c,37.7584158

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

listed_date__c,2023-11-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Kevin

pba__listing_agent_lastname__c,Ho

listing_agent_mls_id__c,807683

ffd_listingagentname,Kevin K Ho

listing_agent_number__c,1023884

listing_co_agent_mls_id__c,809929

listing_co_agent_number__c,1044211

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

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.4382807

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

mls_id__c,424030585

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

master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Low-Flow Shower(s);Window;Stone;Skylight/Solar Tube

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-05-06

open_house_end__c,2024-05-07T14:00:00.000+0000

open_house_start__c,2024-05-07T00:00:00.000+0000

original_price__c,3695000

overall_days_on_market__c,-81940

parking_access__c,Independent

parking_features__c,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck;Uncovered Patio;Front Porch

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

roof__c,Shingle

room_type__c,Office;Bonus Room;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector;Video System;Security System Prewired

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

pba__street_pb__c,Eureka

subdist__c,The Castro - Dolores Heights

ffd_name,234 Eureka Street, San Francisco, CA, 94114

view__c,Downtown;San Francisco;Sutro Tower

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Weather Stripped

pba__yearbuilt_pb__c,1904

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714964135

ffd_listing_title,3883 20th 3885 Street, San Francisco, CA, 94114

ffd_mls_id,424030438

ffd_salesforce_id,a0EUd000001vnjNMAQ

num_of_rooms__c,14

of_units__c,2

address2__c,3883 20th 3885 Street, San Francisco, CA, 94114

pba__address_pb__c,3883 20th 3885 Street, San Francisco, CA, 94114

agent_only_remarks__c,Please do not disturb tenants. Contact Ceily to arrange a private showing. You may also use the google form to book a tour with your client: https://forms.gle/cew2SXshGJwEf1jC8 Currently available showing windows include: Tuesday (5/7) 12-2pm.

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

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,7

year_build_text__c,1924

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Ceily S Landman

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-05T20:48:08.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,3883 & 3885 20th Street, modern condos opposite Dolores Park, are two jewels in their vibrant neighborhood's crown. This boutique building was extensively renovated in 2012 by Zack de Vito Architecture, pairing classic bones w/modern panache, and unique murals by a local artist were added in 2021. These homes' location, enviable in its own right, is also convenient to hot spots including the Mission and Valencia corridors, the Castro, and Noe Valley. We are listing as a duplex on the MLS for any investors interested in purchasing both units at the same time to own the whole building, but this is a condo building. Both units feature hardwood floors, elegant molding, and clean modern design. Front-facing living/dining rooms enjoy northern exposure and views toward the park. Kitchens feature luxury finishes/appliances + ample space. #3883: bi-level condo on lower floors, 4BR 2.5BA 1PK. To be delivered vacant - tenant-occupied through 5/30. Luxurious primary suite down. Exclusive-use backyard w/patio and garden + huge private storage room. #3885: top-floor condo, 3BR 2BA 1PK. Rented month-to-month at $5063/month. Primary suite at rear. Exclusive-use roof deck w/panoramic views including Sutro Tower and Transamerica Pyramid + private storage area. Photos are from prior sale in 2012.

district__c,SF District 5

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-05-06T02:48:08.000+0000

pba__latitude_pb__c,37.75788

pba__latitude_property__c,37.75788

laundry_features__c,In Each Unit

listed_date__c,2024-04-08

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Sherri

pba__listing_agent_lastname__c,Howe

listing_agent_mls_id__c,806718

ffd_listingagentname,Sherri Howe

listing_agent_number__c,166017501

listing_co_agent_mls_id__c,813032

listing_co_agent_number__c,1059036

listing_co_office_mls_id__c,BRAVA

listing_co_office_name__c,Brava Real Estate

listing_co_office_number__c,28638

listing_office_mls_id__c,BRAVA

listing_office_name__c,Brava Real Estate

listing_office_number__c,28638

pba__listingprice_pb__c,4000000

pba__listingtype__c,Sale

pba__listing_website__c,http://twocondosondolo.com/mls

pba__longitude_pb__c,-122.427563

mls_id__c,424030438

parkingspaces__c,2

on_market_date__c,2024-05-05

original_price__c,4000000

overall_days_on_market__c,-81939

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

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,1224.36

pba__propertytype__c,Duplex

ListingId,a0EUd000001vnjNMAQ

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

size__c,3267

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,20th

subdist__c,The Castro - Dolores Heights

ffd_name,3883 20th 3885 Street, San Francisco, CA, 94114

view__c,Park

website_property_type__c,Duplex

window_features__c,Dual Pane Full;Window Coverings

pba__yearbuilt_pb__c,1924

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714820372

ffd_listing_title,3827 20th 3831 Street, San Francisco, CA, 94114

ffd_mls_id,424028507

ffd_salesforce_id,a0EUd000001vIxTMAU

num_of_fireplaces__c,2

num_of_rooms__c,15

of_units__c,0

address2__c,3827 20th 3831 Street, San Francisco, CA, 94114

pba__address_pb__c,3827 20th 3831 Street, San Francisco, CA, 94114

agent_only_remarks__c,Two-level owner's unit, penthouse unit with 2-3 bedrooms + office, standalone back cottage with big bedroom and full bathroom. Extensive seismic work and roof work in 2020. Sq foot is Living Space 3827, 3829 and cottage.

appliances__c,Dishwasher;Insulated Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Electric Water Heater;Built-In Refrigerator

architectural_style__c,Edwardian

bath_features__c,Shower Stall(s);Tub;Split Bath

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,7

year_build_text__c,1911

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Mekhala Chatterjee

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-05-03T19:47:40.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Welcome to the Perfect Family Compound on Dolores Park. This is a house-like duplex plus a stunning studio cottage in the back. Designer finishes, remodeled and elevated living experience, and move-in ready. Absolutely ideal for a generational family living or partners with lots of separate spaces and several potential offices. What makes this so unique are the incredible views and access to one of the best parks in SF. The multi-unit home offers ample living/working/entertaining spaces, traditional millwork, practical layout, temperature-controlled wine room, dark room, tons of additional storage space, two-car garage, sunny patio, and two gourmet kitchens. The owner's unit boasts 3 bedrooms, a chic oasis on the lower floor that includes a media room, office, and wine room. The top floor unit offers a living/dining area, designer kitchen, laundry room, two or three bedrooms plus office, and southern exposed deck. The studio cottage in the rear with full bath is a super bonus and shares a sun-drenched garden. The home has had extensive seismic and tech upgrades.

district__c,SF District 5

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony;Entry Gate

external_listing__c,1

fireplace_features__c,Living Room;Gas Starter

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

interior_features__c,Storage Area(s)

ffd_lastmodifieddate,2024-05-04T10:47:22.000+0000

pba__latitude_pb__c,37.757942

pba__latitude_property__c,37.757942

laundry_features__c,Inside Room;Washer/Dryer Stacked Included

listed_date__c,2024-05-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Butch

pba__listing_agent_lastname__c,Haze

listing_agent_mls_id__c,803654

ffd_listingagentname,Butch Haze

listing_agent_number__c,803654

listing_co_agent_mls_id__c,810112

listing_co_agent_number__c,1044763

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.426442

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

mls_id__c,424028507

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

master_bathroom_features__c,Shower Stall(s);Soaking Tub

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-05-03

open_house_end__c,2024-05-05T15:00:00.000+0000

open_house_start__c,2024-05-05T13:00:00.000+0000

original_price__c,3995000

overall_days_on_market__c,-81937

parking_access__c,Tandem

parking_features__c,Attached

parking_type__c,On Site - Unassigned (Condo 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,978.45

pba__propertytype__c,2 Houses on Lot

ListingId,a0EUd000001vIxTMAU

roof__c,Composition

room_type__c,Storage;Office;Laundry;Kitchen;Library;Living Room;Dining Room;Media Room;Workshop;Wine Storage Area

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

size__c,4083

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,20th

subdist__c,The Castro - Dolores Heights

ffd_name,3827 20th 3831 Street, San Francisco, CA, 94114

view__c,City;Park;Panoramic;City Lights;San Francisco

website_property_type__c,2 Houses on Lot

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1911

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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