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

_yoast_indexnow_last_ping,1714082216

ffd_listing_title,3918 17th Street, San Francisco, CA, 94114

ffd_mls_id,424025778

ffd_salesforce_id,a0EUd000001q2d3MAA

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,2

address2__c,3918 17th Street, San Francisco, CA, 94114

pba__address_pb__c,3918 17th Street, San Francisco, CA, 94114

agent_only_remarks__c,Staged and can be shown by appointment with combo box or better yet, come to an open house! Exclusive deck needs repair. Rear garden and garage storage rooms are for the other unit (not shared). HOA has ~ $24,000 in the bank account. If not a problem, please use open escrow with First American w/ Amy Edberg. Square footage: 1,348 per tax records; 1,415 per floor plan. Buyer to verify as desired. Pet Restrictions: Each unit allows for a maximum of two cats or dogs, with the option to also keep fish and birds indoors, provided they are contained within cages. PLEASE NOTE: The seller and listing agent have NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.

appliances__c,Dishwasher;Built-In Gas Range

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-25T15:46:32.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Enjoy quintessential SF living in this top-floor condo of a boutique two-unit building, located in the heart of the Castro and Eureka Valley. As you enter the full-floor flat, the city's pulse fades, inviting you to relax among the period charm and modern comforts. A spacious front living room is bathed in southern light, hosting a decorative fireplace and views of Twin Peaks. Two generous bedrooms share an updated split full bath. Entertain in the formal dining room, featuring lovely built-ins and a fireplace with possible gas hookup. The large, updated kitchen is well-equipped with stainless steel GE and Frigidaire appliances and a gas range, leading out to an exclusive-use deck that captures 'secret garden' vibes with its verdant outlooks. Additional comforts include a very large walk-in hall closet, a spacious in-unit laundry room with a stacked Maytag front-loading washer and dryer, and independent garage parking. With a Walk Score of 99 and Transit Score of 88 per Walkscore.com, this home is a stone's throw from the dynamic Castro and Mission districts, offering an array of shops, restaurants, and nightlife.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Common Areas,Insurance on Structure,Maintenance Grounds,Trash,Water

pba__hoafees__c,250

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Self- Managed

hoa__c,Yes

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-25T21:46:38.000+0000

pba__latitude_pb__c,37.762819

pba__latitude_property__c,37.762819

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-04-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Danielle

pba__listing_agent_lastname__c,Lazier

listing_agent_mls_id__c,803117

ffd_listingagentname,Danielle Lazier

listing_agent_number__c,803117

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VIVRE

listing_office_name__c,Vivre Real Estate

listing_office_number__c,28694

pba__listingprice_pb__c,1149000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.43348

mls_id__c,424025778

master_property__c,a0OUd000006RgisMAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-25

open_house_end__c,2024-04-25T18:30:00.000+0000

open_house_start__c,2024-04-25T17:00:00.000+0000

original_price__c,1149000

overall_days_on_market__c,-81929

parking_access__c,Independent

parking_features__c,Enclosed,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001q2d3MAA

room_type__c,Kitchen;Living Room;Dining Room

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

size__c,1415

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,17th

subdist__c,The Castro - Dolores Heights

ffd_name,3918 17th Street, San Francisco, CA, 94114

website_property_type__c,Condominium

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/530766547-1.jpg

_yoast_indexnow_last_ping,1714042893

ffd_listing_title,110 Liberty Street, San Francisco, CA, 94110

ffd_mls_id,424025958

ffd_salesforce_id,a0EUd000001nKZnMAM

num_of_fireplaces__c,1

num_of_rooms__c,6

of_units__c,0

address2__c,110 Liberty Street, San Francisco, CA, 94110

pba__address_pb__c,110 Liberty Street, San Francisco, CA, 94110

agent_only_remarks__c,OFFER DATE TBD. Contact Dennis at 415 595-1300 or Anna Spathis at 415-810-5291 for showing and disclosures. Pre-escrow has been opened with Christine Lim at Old Republic Title.

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

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1882

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Dennis Stavropoulos

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-20T00:49:11.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,This Liberty Hill Victorian gem boasts downtown views and a resort-style backyard oasis. With a coveted 98 WalkScore, this home epitomizes urban luxury and convenience. Step inside to discover a spacious living room adorned with a south facing bay window, perfect for soaking in natural light. The formal dining room features a wood-burning fireplace with marble, setting the stage for memorable gatherings. A chef's kitchen awaits, complete with marble counters, ample storage, and a skylit breakfast nook with custom built-in seating. Entertain effortlessly as the kitchen opens to a large, sun-drenched Ipe deck, ideal for al fresco dining and relaxation. Upstairs, the primary suite beckons with downtown vistas and a luxurious bath illuminated by a skylight. Outside, the expansive 2850 sq ft lot unveils a multi-tiered backyard retreat, complete with a wired and modern shed/office. Bonus garden-level spaces offer versatility as a guest room, artist studio/multimedia room, or home office. Owned solar panels, prime Liberty Hill location near restaurants, parks, and transportation hubs, including BART and MUNI, elevate the allure of this urban sanctuary. An opportunity to call this Liberty Hill treasure home.

district__c,SF District 5

entry_level__c,0

exterior_features__c,Fire Pit

external_listing__c,1

fencing__c,Wood

fireplace_features__c,Dining Room

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;Storage Area(s)

ffd_lastmodifieddate,2024-04-25T10:46:56.000+0000

pba__latitude_pb__c,37.7577183

pba__latitude_property__c,37.7577183

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2024-02-06

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Anna

pba__listing_agent_lastname__c,Spathis

listing_agent_mls_id__c,804040

ffd_listingagentname,Anna G Spathis

listing_agent_number__c,166013457

listing_co_agent_mls_id__c,400242

listing_co_agent_number__c,1022227

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4239683

lower_level__c,Partial Bath(s),Retreat,Street Entrance

mls_id__c,424025958

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

master_bathroom_features__c,Shower Stall(s);Marble

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-19

open_house_end__c,2024-04-27T13:00:00.000+0000

open_house_start__c,2024-04-27T11:00:00.000+0000

original_price__c,2700000

overall_days_on_market__c,-81923

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001nKZnMAM

room_type__c,Storage;Bonus Room;Kitchen;Living Room;Dining Room;Workshop;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,1750

size__c,1750

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Liberty

subdist__c,The Castro - Dolores Heights

ffd_name,110 Liberty Street, San Francisco, CA, 94110

view__c,City

website_property_type__c,Single Family Home

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1882

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714042880

ffd_listing_title,37 Hartford Street, San Francisco, CA, 94114

ffd_mls_id,424024047

ffd_salesforce_id,a0EUd000001n3iXMAQ

num_of_fireplaces__c,3

num_of_rooms__c,8

of_units__c,2

address2__c,37 Hartford Street, San Francisco, CA, 94114

pba__address_pb__c,37 Hartford Street, San Francisco, CA, 94114

agent_only_remarks__c,37HartfordStreet.com for photos, video, 3D Tour and more! Easy to show! Email disclosure request to [email protected]. Contact Grayson Poulos for showing requests. [email protected] 415-717-4371. Prelim courtesy of Gerrie Brindley at Chicago Title.

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

architectural_style__c,Victorian

bath_features__c,Tub w/Shower Over;Shower Stall(s);Marble;Tile

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,1901

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-04-19T19:47:40.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Additional photos coming 4/20! Step into a timeless Victorian haven in San Francisco's Castro district, where elegance meets modern comfort. Spanning over 2200 sq. ft., this 3 bed, 3 bath condominium boasts classic features and contemporary amenities for sophisticated living. The formal living room welcomes you with intricate moldings and high ceilings, leading seamlessly to a double parlor and a formal dining room, perfect for entertaining guests. The remodeled kitchen, with a breakfast bar and family room, is an entertainer's delight. The spacious bedrooms offer privacy, while the garden-level primary suite is a retreat with its spa-inspired bathroom and walk-in closet. Throughout, period details and fireplaces add charm, while storage and in-unit laundry ensure convenience. Located on historic Hartford Street, enjoy the neighborhood's vibrant amenities, from shopping and dining to parks and entertainment. With easy access to transportation, this residence offers the quintessential San Francisco lifestyle.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Dining Room;Primary Bedroom

pba__floortype_pb__c,Bamboo;Tile;Wood

hoa_fee_includes__c,Maintenance Exterior

pba__hoafees__c,96

pba__hoafrequency_pb__c,Monthly

hoa_name__c,37-39 Hartford St. HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-04-25T10:46:56.000+0000

pba__latitude_pb__c,37.761932

pba__latitude_property__c,37.761932

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-01-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Brendon

pba__listing_agent_lastname__c,Kearney

listing_agent_mls_id__c,802979

ffd_listingagentname,Brendon Kearney

listing_agent_number__c,802979

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP3

listing_office_name__c,Compass

listing_office_number__c,27342

pba__listingprice_pb__c,1695000

pba__listingtype__c,Sale

pba__listing_website__c,https://37hartfordstreet.com/mls

pba__longitude_pb__c,-122.433671

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

mls_id__c,424024047

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

master_bathroom_features__c,Shower Stall(s);Tile;Soaking Tub;Radiant Heat

master_property__c,a0OUd000006DqteMAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-19

original_price__c,1695000

overall_days_on_market__c,-81923

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001n3iXMAQ

room_type__c,Storage;Laundry;Den;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;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,2246

size__c,2246

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Hartford

subdist__c,The Castro - Dolores Heights

ffd_name,37 Hartford Street, San Francisco, CA, 94114

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1901

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713578250

ffd_listing_title,4327 20th 4329 Street, San Francisco, CA, 94114

ffd_mls_id,424000831

ffd_salesforce_id,a0EUd000000jbEjMAI

num_of_rooms__c,7

of_units__c,2

address2__c,4327 20th 4329 Street, San Francisco, CA, 94114

pba__address_pb__c,4327 20th 4329 Street, San Francisco, CA, 94114

agent_only_remarks__c,Back On Market No Fault of Property! Contact John 415.218.6337 for any questions and access. Sellers are RE agents. Disclosures available at:https://app.disclosures.io/link/43274329-20th-St-n48z46ap

appliances__c,Dishwasher;Disposal;Tankless 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,1907

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-01-06T01:47:51.000+0000

days_on_market__c,105

dom__c,81

ffd_description_pb,Fall in love with this Eastlake Victorian beauty! Vacant and recently remodeled while keeping its Victorian architectural details of high ceilings, decorative moldings, stain-glass windows, wood flooring, and so much more! Enjoy neighborhood and downtown views from its large bay windows. Main floor is perfect for entertaining with spacious formal living rm w/ frplc and parlor doors leading to stately dining rm also w/ frplc. Eat-in kitchen w/ stainless steel appls and walk-in pantry leads to garden & a large patio area for outside dining. Finishing this level a spacious full BA, laundry closet, and extra storage. Elegant grand staircase leads to Upstairs: 3 BDs (one w/frplc), a versatile den/4th BD and a large full double-sink BA. Additional 1 BD In-Law w/ separate entry is perfect for extended family or rental. Coveted Eureka Valley location! Easy access to shops, transport, and dining. Walk to Castro and 24th St. neighborhoods. Main Home: 4BD/2BA (2150sqft) Separate Entrance 1BD/1BA In-Law (500 sqft)

district__c,SF District 5

exterior_features__c,Fenced Yard

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Electric

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-04-20T01:47:45.000+0000

pba__latitude_pb__c,37.757366

pba__latitude_property__c,37.757366

laundry_features__c,Laundry Closet;Washer/Dryer Hookups

listed_date__c,2024-01-05

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,John

pba__listing_agent_lastname__c,Farrell

listing_agent_mls_id__c,806076

ffd_listingagentname,John Farrell

listing_agent_number__c,166016242

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,FARL

listing_office_name__c,Farrell Real Estate Investments

listing_office_number__c,166014033

pba__listingprice_pb__c,2395000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.4327-4329-20thst.com

pba__longitude_pb__c,-122.436365

mls_id__c,424000831

parkingspaces__c,0

on_market_date__c,2024-01-05

open_house_end__c,2024-04-23T14:00:00.000+0000

open_house_start__c,2024-04-23T12:00:00.000+0000

original_price__c,2995000

overall_days_on_market__c,-81818

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,904.8

price_reduced__c,1

pba__propertytype__c,Duplex

ListingId,a0EUd000000jbEjMAI

roof__c,Bitumen;Shingle

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

size__c,2647

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,20th

subdist__c,The Castro - Dolores Heights

ffd_name,4327 20th 4329 Street, San Francisco, CA, 94114

view__c,City Lights;Downtown

website_property_type__c,Duplex

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1907

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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