257 Collingwood Street, San Francisco, CA, 94114 - Property Description

_yoast_indexnow_last_ping,1715050497

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-07T02:50:25.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,1715079573

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

dom__c,1

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-07T10:46:49.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-07T12: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,1715137029

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 Buyers should evaluate the parking access to their satisfaction.

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

dom__c,2

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-08T02:47:12.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

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

open_house_start__c,2024-05-14T12:00:00.000+0000

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

ffd_listing_title,425 Liberty Street, San Francisco, CA, 94114

ffd_mls_id,424029843

ffd_salesforce_id,a0EUd000001v72jMAA

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,425 Liberty Street, San Francisco, CA, 94114

pba__address_pb__c,425 Liberty Street, San Francisco, CA, 94114

agent_only_remarks__c,Home is owner occupied, showings by appointment only.

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-03T16:47:43.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,425 Liberty offers a rare opportunity to buy a lovely home situated on one of Dolores Heights most coveted blocks. Tucked on quiet, sunny enclave with quick access to multiple surrounding neighborhoods, Dolores Park, and public transportation. This Victorian home boasts almost 2,000 square feet + a spacious 1,760 square foot garage/basement for within-the-envelope expansion potential. The main level hosts a dinning room, living room, a full bath and kitchen opening to a family room. The living space is extended by a sun-fill and south-facing walkout garden. The garden receives sun all day and is a truly magical place to retreat to. Upstairs are two bedrooms (including an extremely spacious primary with a balcony and access to the garden), and one full bath. The front bedroom has sweeping views of the city skyline, and both bedrooms receive copious amounts of light throughout the day. The lower level features a large garage (currently built out as living space) + a separate laundry room waiting for future development. Not to be missed!

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

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

pba__latitude_pb__c,37.756953

pba__latitude_property__c,37.756953

listed_date__c,2024-05-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Lamisse

pba__listing_agent_lastname__c,Droubi

listing_agent_mls_id__c,802259

ffd_listingagentname,Lamisse Droubi

listing_agent_number__c,802259

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,GENERATE

listing_office_name__c,Generation Real Estate

listing_office_number__c,28067

pba__listingprice_pb__c,1995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4307788

mls_id__c,424029843

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

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

overall_days_on_market__c,-81937

parking_access__c,Independent

parking_features__c,Attached

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001v72jMAA

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

size__c,1983

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Liberty

subdist__c,The Castro - Dolores Heights

ffd_name,425 Liberty Street, San Francisco, CA, 94114

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1910

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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