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

_yoast_indexnow_last_ping,1736821396

ffd_listing_title,920 Guerrero 926 Street, San Francisco, CA, 94110

ffd_mls_id,424077949

ffd_salesforce_id,a0EUd0000041v5BMAQ

num_of_rooms__c,12

of_units__c,4

pba__address_pb__c,920 Guerrero 926 Street, San Francisco, CA, 94110

address2__c,920 Guerrero 926 Street, San Francisco, CA, 94110

agent_only_remarks__c,Seller is willing to consider concessions. Easy to show by appointment - please call Joske Thompson for all showings. 415.608.2233

appliances__c,Gas Water Heater;Free Standing Gas Oven;Free Standing Refrigerator;Varies By Unit

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1953

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2025-01-11T11:49:20.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Welcome Home Mrs. Madrigral. Built in 1953 which has original design is a wonderful 4 unit building with 6 beds and 5 baths total - 1 Studio, 2 one bedroom units and a separate house which is 3 bedrooms, two full baths plus 2 car garage. The magical garden separates the two buildings. The studio is gutted to the studs awaiting someone with their own renovations. The house is designed on two levels, the top floor features a large living room with fireplace, a large eat-in kitchen and two bedrooms and one full bath with a bedroom suite down. Parking garage is at rear of property on Ames St. The studio and the house is vacant, ideal for an owner user with income from the two rented units. Immediate proximity to 16th St transit station, Valencia St thriving corridor, shopping & dining, Bi-Rite. This is a solid investment with stable rental income. Whether you're looking for a great income-generating property or a place to live while renting out the other 3 units, this quadruplex checks all the boxes. Don't miss out on this rare find in a prime location!

district__c,SF District 5

exterior_features__c,Fenced Yard

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

ffd_lastmodifieddate,2025-01-14T01:48:09.000+0000

pba__latitude_pb__c,37.7485824

pba__latitude_property__c,37.7485824

laundry_features__c,Laundry Closet;Washer/Dryer Owned

listed_date__c,2024-09-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Joske

pba__listing_agent_lastname__c,Thompson

listing_agent_mls_id__c,342699

ffd_listingagentname,Joske M Thompson

listing_agent_number__c,342699

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1700000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4184108

mls_id__c,424077949

parkingspaces__c,2

on_market_date__c,2025-01-11

open_house_end__c,2025-01-14T14:00:00.000+0000

open_house_start__c,2025-01-14T12:00:00.000+0000

original_price__c,1700000

overall_days_on_market__c,-82190

parking_features__c,Attached,Garage,Interior Access

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,608.23

pba__propertytype__c,Quadruplex

ListingId,a0EUd0000041v5BMAQ

roof__c,Bitumen

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

size__c,2795

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Guerrero

subdist__c,The Castro - Dolores Heights

ffd_name,920 Guerrero 926 Street, San Francisco, CA, 94110

view__c,Downtown

website_property_type__c,Quadruplex

pba__yearbuilt_pb__c,1953

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1736597836

ffd_listing_title,156 LIberty Street, San Francisco, CA, 94110

ffd_mls_id,424060468

ffd_salesforce_id,a0EUd000002y5RtMAI

num_of_fireplaces__c,0

num_of_rooms__c,10

of_units__c,0

pba__address_pb__c,156 LIberty Street, San Francisco, CA, 94110

address2__c,156 LIberty Street, San Francisco, CA, 94110

agent_only_remarks__c,Call Dennis Stavropoulos at 415-595-1300 for access. Pre-escrow has been opened with Alethea Benally at Old Republic. CAUTION - property in state of construction and is not safe for children or animals. All visitors to tour property with caution. Per 3R report this is a two unit building.

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,6

year_build_text__c,1900

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Anna G Spathis

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-08-28T01:47:42.000+0000

days_on_market__c,137

dom__c,127

ffd_description_pb,Family home in the premier location of Liberty Hill and around the corner from Dolores Park. An extraordinary opportunity with 3 levels of downtown views ready for a new owner to re-imagine, personalize and repurpose this property. Architectural plans are for 4190 sq ft of living space, 2 car tandem parking, roof deck and 12.5 feet floor to ceiling height in the main level. The finished product becomes an icon of contemporary design with tall ceilings and crisp lines. Designed by Suheil Shatara in collaboration with Vaso Peritos, the offering comes with architectural plans, foundation poured almost complete and building mostly framed. House is on the studs - not in a living condition. Almost 3 yrs of design, development and permitting yield build-to-suit opportunity. Buyer must do their own due diligence. Plans are for a 2 unit building and can function as a family home. Plans are available upon request. LOCATION! LOCATION! LOCATION!

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2025-01-11T11:47:59.000+0000

pba__latitude_pb__c,37.7576717

pba__latitude_property__c,37.7576717

listed_date__c,2024-08-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Dennis

pba__listing_agent_lastname__c,Stavropoulos

listing_agent_mls_id__c,400242

ffd_listingagentname,Dennis Stavropoulos

listing_agent_number__c,1022227

listing_co_agent_mls_id__c,804040

listing_co_agent_number__c,166013457

listing_co_office_mls_id__c,SHOM

listing_co_office_name__c,STERLING HOMES

listing_co_office_number__c,29116

listing_office_mls_id__c,SHOM

listing_office_name__c,STERLING HOMES

listing_office_number__c,29116

pba__listingprice_pb__c,3150000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4246593

mls_id__c,424060468

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-08-27

open_house_end__c,2025-01-12T14:00:00.000+0000

open_house_start__c,2025-01-12T12:30:00.000+0000

original_price__c,3150000

overall_days_on_market__c,-82053

parking_access__c,Tandem

parking_features__c,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,751.79

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000002y5RtMAI

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

size__c,4190

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,LIberty

subdist__c,The Castro - Dolores Heights

ffd_name,156 LIberty Street, San Francisco, CA, 94110

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1736828253

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

ffd_mls_id,424081364

ffd_salesforce_id,a0EUd0000041LpiMAE

num_of_fireplaces__c,2

num_of_rooms__c,6

of_units__c,2

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

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

agent_only_remarks__c,NEW LISTING! For special showings please call/text Nadia Ruimy at cell #415-706-5252. Disclosure package available to review prior to an offer. No monthly Dues except for annual building insurance and monthly water bill calculated for both units. Escrow opened with Chicago Title Co./Joanne Kung.

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

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1997

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-01-10T11:47:37.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Nestled between the sought-after neighborhoods of NOE VALLEY and EUREKA VALLEY, this EXPANSIVE TOP FLOOR two-level VIEW condo offers the feel of a single-family home. PRIVATE ELEVATOR to both levels from the garage, this residence is designed for convenience, entertainment, and LUXURY. The open floor plan seamlessly blends indoor and outdoor living, featuring soaring ceilings, skylights, powder room, pantry, beautiful hardwood floors throughout, and two gas fireplaces. PANORAMIC VIEWS and multiple DECKS, including a private HOT TUB, create an ideal setting for relaxing or entertaining under the stars, all while soaking in spectacular views.The modern floor plan in both HOA units was well thought-out separating the entertainment spaces from the bedrooms. The primary suite is a true retreat, boasting a marble-clad en-suite bathroom with a separate jet tub and shower, walk-in closet, office alcove, a sitting area with a FIREPLACE, and stunning views. Two additional spacious bedrooms, two bathrooms, and a separate laundry room provide ample space for family and guests. The shared garage offers one-to-two car tandem parking (depending on size) and exclusive storage areas. This home is part of an exceptional 2-unit HOA building, ensuring a well-maintained and cohesive community

district__c,SF District 5

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fireplace_features__c,Living Room;Gas Starter;Gas Log;Primary Bedroom

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,Homeowners Insurance,Water,See Remarks

pba__hoafees__c,0

pba__hoafrequency_pb__c,See Remarks

hoa_name__c,453-455 Eureka Street, A Condominium Project

hoa__c,Yes

pba__halfbathrooms_pb__c,2

pba__heatingtype_pb__c,Central;Gas;Fireplace(s)

interior_features__c,Skylight(s);Storage Area(s);Cathedral Ceiling;Elevator

ffd_lastmodifieddate,2025-01-14T03:48:11.000+0000

pba__latitude_pb__c,37.755011

pba__latitude_property__c,37.755011

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

listed_date__c,2024-11-11

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Nadia

pba__listing_agent_lastname__c,Ruimy

listing_agent_mls_id__c,292718

ffd_listingagentname,Nadia Ruimy

listing_agent_number__c,292718

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP01

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28939

pba__listingprice_pb__c,2595000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/573275535

pba__longitude_pb__c,-122.437413

lower_level__c,Garage,Street Entrance

mls_id__c,424081364

main_level__c,Full Bath(s);Partial Bath(s);Bedroom(s);Primary Bedroom

master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Jetted Tub;Marble

master_property__c,a0O1I00000D2fBYUAZ

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2025-01-10

open_house_end__c,2025-01-14T14:00:00.000+0000

open_house_start__c,2025-01-14T12:00:00.000+0000

original_price__c,2595000

overall_days_on_market__c,-82189

parking_access__c,Tandem

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

parking_type__c,On Site - Assigned (Condo Only);On Site - Mapped (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,1065.27

pba__propertytype__c,Condominium

ListingId,a0EUd0000041LpiMAE

roof__c,Composition

room_type__c,Dining Room

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

size__c,2436

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Eureka

subdist__c,The Castro - Dolores Heights

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

view__c,City Lights;Twin Peaks;Hills

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Window Coverings;Window Screens

pba__yearbuilt_pb__c,1997

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1736828251

ffd_listing_title,133 Hancock Street, San Francisco, CA, 94114

ffd_mls_id,425000913

ffd_salesforce_id,a0EUd0000041B5fMAE

num_of_fireplaces__c,1

num_of_rooms__c,4

of_units__c,0

pba__address_pb__c,133 Hancock Street, San Francisco, CA, 94114

address2__c,133 Hancock Street, San Francisco, CA, 94114

agent_only_remarks__c,Twilight Tour Tuesday 01/14 5:00-7:00PM. Please contact Mike Shaw 415 308 4281 or Michael Dunne 415 823-0002 to show. Trust sale. Disclosures available by request. Open Thursday 1/9 5-7pm, Sat 1/11 and Sun 1/12 12-3pm Tues 1/14 12-2pm. No Showing Time Please

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

architectural_style__c,Marina

bath_features__c,Shower Stall(s);Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1923

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Bernard Katzmann

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-01-09T20:47:15.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,This classic Marina-style home sits on an extra deep lot in a prime Eureka Valley location, just blocks to Dolores Park. The updated home offers an abundance of natural light, beautiful period detailing, refinished wood floors and modern updates. The foyer leads to a spacious living/dining room with gorgeous refinished wood floors, period details and a handsome wood-burning fireplace.The remodeled kitchen with quartz counters, stainless appliances include a Viking gas range and KitchenAid refrigerator and tile backsplash opens to the rear garden. 2 spacious bedrooms and 2 remodeled bathrooms. The home enjoys a deep south-facing garden with multiple decks and mature foliage. One-car garage with washer/dryer and storage. Ideal Eureka Valley location close to Dolores Park and neighborhood schools, and all the shopping, cafes and restaurants of the Castro, Upper Market and Mission Dolores. Easy access to public transit, tech shuttles and freeways

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Partial

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2025-01-14T03:48:11.000+0000

pba__latitude_pb__c,37.7601158

pba__latitude_property__c,37.7601158

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-10-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Michael

pba__listing_agent_lastname__c,Shaw

listing_agent_mls_id__c,800323

ffd_listingagentname,Michael H Shaw

listing_agent_number__c,800323

listing_co_agent_mls_id__c,263622

listing_co_agent_number__c,263622

listing_co_office_mls_id__c,VANG03

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,1228

listing_office_mls_id__c,VANG03

listing_office_name__c,Vanguard Properties

listing_office_number__c,1228

pba__listingprice_pb__c,1595000

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/cwTm6i0aZWc

pba__longitude_pb__c,-122.4313833

lower_level__c,Garage,Street Entrance

mls_id__c,425000913

main_level__c,Bedroom(s);Kitchen;Living Room;Primary Bedroom

master_bathroom_features__c,Shower Stall(s);Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-01-08

open_house_end__c,2025-01-14T19:00:00.000+0000

open_house_start__c,2025-01-14T05:00:00.000+0000

original_price__c,1595000

overall_days_on_market__c,-82187

parking_access__c,Independent

parking_features__c,Attached,Garage Facing Front,Interior Access

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000041B5fMAE

room_type__c,Kitchen;Living Room;Baths Other;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security System Prewired;Security System Leased

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

size__c,1080

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Hancock

subdist__c,The Castro - Dolores Heights

ffd_name,133 Hancock Street, San Francisco, CA, 94114

website_property_type__c,Single Family Home

window_features__c,Dual Pane Partial;Window Screens

pba__yearbuilt_pb__c,1923

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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