1334 Douglass Street, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1713438059

ffd_listing_title,514 29th Street, San Francisco, CA, 94131

ffd_mls_id,424023668

ffd_salesforce_id,a0EUd000001lb3bMAA

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,514 29th Street, San Francisco, CA, 94131

pba__address_pb__c,514 29th Street, San Francisco, CA, 94131

agent_only_remarks__c,HOA casually managed, expenses paid when needed. Escrow open with Joanne Kung at Chicago Title Company.

appliances__c,Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,2002

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-17T21:46:59.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Enjoy a unique living experience in this Noe Valley contemporary condominium in a 2002 two-unit building. With a house-like layout, the main level hosts a spacious living area while the top floor features three bedrooms and two bathrooms. The open living/dining/kitchen area, with its 10-foot ceiling height and rare-to-find volume, is an entertainer's dream. The Chef's kitchen comes with stainless steel appliances, a stone countertop, and a breakfast bar. Natural light floods the space highlighting the oak hardwood floors. Two gas-burning fireplaces add warmth and ambiance. The primary bedroom features a comfortable sitting area, a walk-in closet, and a spa-like bathroom offering a jet tub and shower. Additional bedrooms provide ample space and tranquility. A light-filled landing offers a perfect spot for a home office. The private rooftop deck showcases stunning views of Noe Valley, Bernal Heights, and the Bay. A spacious side-by-side 1-car garage also provides ample storage. Located in vibrant west Noe Valley, just steps from slow-traffic Sanchez St and amenities such as the Day St Rec Center & Dog's Park, and Church St shops and restaurants, with easy access to highways and public transportation, this condominium epitomizes modern city living.

district__c,SF District 5

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Homeowners Insurance,Maintenance Exterior,Trash

pba__hoafees__c,0

pba__hoafrequency_pb__c,See Remarks

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Heat Pump

ffd_lastmodifieddate,2024-04-18T10:47:13.000+0000

pba__latitude_pb__c,37.743641

pba__latitude_property__c,37.743641

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-03-05

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Denis

pba__listing_agent_lastname__c,Lancerin

listing_agent_mls_id__c,805604

ffd_listingagentname,Denis Lancerin

listing_agent_number__c,721509295

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CITYRE

listing_office_name__c,City Real Estate

listing_office_number__c,27425

pba__listingprice_pb__c,2295000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/934249583?h=a008769d85

pba__longitude_pb__c,-122.431671

mls_id__c,424023668

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

master_bathroom_features__c,Shower Stall(s);Double Sinks;Jetted Tub

master_property__c,a0OUd0000068E5eMAE

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-17

open_house_end__c,2024-04-18T19:30:00.000+0000

open_house_start__c,2024-04-18T18:00:00.000+0000

original_price__c,2295000

overall_days_on_market__c,-81921

parking_access__c,Side by Side

parking_features__c,Assigned,Covered

parking_type__c,On Site - Assigned (Condo Only);On Site - Mapped (Condo Only)

patio_and_porch_features__c,Roof 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,1077.97

pba__propertytype__c,Condominium

ListingId,a0EUd000001lb3bMAA

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;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,2129

size__c,2129

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,29th

subdist__c,Noe Valley

ffd_name,514 29th Street, San Francisco, CA, 94131

view__c,Bay;Valley

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2002

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713402179

ffd_listing_title,4125 24th Street #2, San Francisco, CA, 94114

ffd_mls_id,424024169

ffd_salesforce_id,a0EUd000001lQ89MAE

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,4

address2__c,4125 24th Street #2, San Francisco, CA, 94114

pba__address_pb__c,4125 24th Street #2, San Francisco, CA, 94114

agent_only_remarks__c,Pre-Escrow opened with First American Title. Disclosures linked to MLS or download here: https://app.disclosures.io/link/4125-24th-Street-2-cewowxkw. For private showings and additional information please contact [email protected] / 415.935.1014.

appliances__c,Dishwasher;Free Standing Refrigerator;Free Standing Electric Range

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1965

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-17T17:46:30.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Discover this beautifully renovated mid-century modern condo, perfectly located along the vibrant 24th Street. This chic 2-bedroom home boasts modern contemporary finishes and an open floor plan. The updated eat-in kitchen features stainless steel appliances and washer/dryer. Quartz countertops and a butcher block extension add both functionality and charm. The layout flows effortlessly into a spacious family room, where a large picture window showcases the exclusive south-facing deck flooding the living area with natural light. Venture outside to relish in over 150 sq. feet of private outdoor space, ideal for BBQs and dining al fresco. The bedrooms offer privacy, plentiful natural light, and extensive closet storage with smart solutions like California closets. The bathroom has been tastefully remodeled to feature bright, airy Carrera Marble decor and heated floors, enhancing the sense of luxury. Amenities include an in-home washer/dryer, a Grohe Blue filtered-water dispenser, HUE Phillips lighting, and a smart NEST thermostat. Includes 1-car independent parking and deeded storage and low HOA fees.

district__c,SF District 5

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,300

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-04-18T00:47:22.000+0000

pba__latitude_pb__c,37.7510868

pba__latitude_property__c,37.7510868

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-04-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jason

pba__listing_agent_lastname__c,Hoffman

listing_agent_mls_id__c,807419

ffd_listingagentname,Jason H Hoffman

listing_agent_number__c,1017981

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

pba__listingtype__c,Sale

pba__listing_website__c,https://www.noeoasis.com

pba__longitude_pb__c,-122.4347337

mls_id__c,424024169

main_level__c,Bedroom(s);Kitchen;Living Room

master_property__c,a0O1I000001ViWxUAK

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-17

open_house_end__c,2024-04-20T16:00:00.000+0000

open_house_start__c,2024-04-20T14:00:00.000+0000

original_price__c,995000

overall_days_on_market__c,-81921

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001lQ89MAE

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,24th

subdist__c,Noe Valley

ffd_name,4125 24th Street #2, San Francisco, CA, 94114

view__c,City

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1965

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713351584

ffd_listing_title,3848 24th Street, San Francisco, CA, 94114

ffd_mls_id,424024344

ffd_salesforce_id,a0EUd000001kICfMAM

num_of_rooms__c,14

of_units__c,5

address2__c,3848 24th Street, San Francisco, CA, 94114

pba__address_pb__c,3848 24th Street, San Francisco, CA, 94114

agent_only_remarks__c,All units tenant-occupied. 24-48 hour notice required. E-mail Natalie @ [email protected] Disclosures: https://app.disclosures.io/link/3848-24th-Street-245-Vicksburg-Street-k9knn7q3 Marketing package: https://www.allisonchapleau.com/listing/3848-24th-st-245-vicksburg-st

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-16T00:49:23.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,3848 24th Street & 245 Vicksburg Street presents an opportunity to own a 5-unit mixed-use building in San Francisco's vibrant Noe Valley District. The building has been meticulously maintained over the years with over $300,000 of recent capital improvements invested into the building. Upgrades for the building include unit remodels, exterior paint, sewer lateral replacement, and new electrical panels. All of the units are currently occupied by tenants, presenting an ideal scenario for investors seeking a turn-key, stable asset in one of San Francisco's most sought-after retail corridors. Situated in Noe Valley, residents can enjoy the convenience of nearby Dolores Park, as well as restaurants, bars, cafes, and shops in the area. Popular neighborhood spots include Novy, Uma Casa, Bacco, Lupa Trattoria, Firefly, Aha Fresh, Vive La Tarte, Philz, and Noe Valley Bakery.

district__c,SF District 5

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-17T10:48:35.000+0000

pba__latitude_pb__c,37.751818

pba__latitude_property__c,37.751818

listed_date__c,2024-04-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Allison

pba__listing_agent_lastname__c,Chapleau

listing_agent_mls_id__c,981036

ffd_listingagentname,Allison Chapleau

listing_agent_number__c,981036

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.428457

mls_id__c,424024344

parkingspaces__c,2

on_market_date__c,2024-04-15

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

overall_days_on_market__c,-81919

parking_features__c,Attached,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,567.05

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000001kICfMAM

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

size__c,4400

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,24th

subdist__c,Noe Valley

ffd_name,3848 24th Street, San Francisco, CA, 94114

website_property_type__c,5 or More Unit

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

_yoast_indexnow_last_ping,1713232967

ffd_listing_title,573 Diamond Street, San Francisco, CA, 94114

ffd_mls_id,424018644

ffd_salesforce_id,a0EUd000001jrcIMAQ

num_of_fireplaces__c,0

num_of_rooms__c,8

of_units__c,0

address2__c,573 Diamond Street, San Francisco, CA, 94114

pba__address_pb__c,573 Diamond Street, San Francisco, CA, 94114

agent_only_remarks__c,For Showings, please text or call Taylor: 209-988-9822. City has approved a 1,343 sq ft expansion project. See disclosure package for plans. Escrow opened with Liz Paglinawan, First American, [email protected].

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

bath_features__c,Tub w/Shower Over;Tile;Window

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,4

year_build_text__c,1906

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-15T17:47:30.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Nestled in San Francisco's Noe Valley, this 1908 Victorian blends classic elegance with modern upgrades. An open floor plan connects living areas, while Bay windows flood the space with sunlight, accentuating rich floors and intricate details. At the front, a proper entrance leads to the formal living room. Adjacent, the dining room and lounge area adjoin the spacious kitchen, boasting new countertops and top-of-the-line appliances. Walk-out access leads to the deck and lush backyard, offering ample space for outdoor entertaining or gardening, including a secret garden-style deck. Upstairs, the primary suite offers tranquility with a grand arched window and cathedral ceilings, along with two additional bedrooms and a full bathroom. The lower level features a media room or guest suite with backyard access, offering privacy and convenience. Remodeled with a cozy sitting area, mudroom, abundant storage, laundry room, and garage. In a sought-after neighborhood near shops, restaurants, and amenities. With its open floor plan and expansive backyard, this remodeled Noe Valley home offers a perfect blend of historic charm and contemporary living. Just steps away from the shops and eateries of 24th Street, residents can enjoy the convenience of nearby amenities.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway

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

interior_features__c,Skylight Tube;Cathedral Ceiling

ffd_lastmodifieddate,2024-04-16T01:47:39.000+0000

pba__latitude_pb__c,37.753241

pba__latitude_property__c,37.753241

laundry_features__c,Laundry Closet;Ground Floor;Washer Included;Dryer Included

listed_date__c,2024-04-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Missy

pba__listing_agent_lastname__c,Wyant Smit

listing_agent_mls_id__c,804067

ffd_listingagentname,Missy Wyant Smit

listing_agent_number__c,166013500

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4362524

lower_level__c,Bedroom(s),Full Bath(s),Garage,Street Entrance

mls_id__c,424018644

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

master_bathroom_features__c,Shower Stall(s);Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-15

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

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

original_price__c,3595000

overall_days_on_market__c,-81919

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001jrcIMAQ

room_type__c,Kitchen;Living Room;Baths Other;Dining 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,2692

size__c,2692

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Diamond

subdist__c,Noe Valley

ffd_name,573 Diamond Street, San Francisco, CA, 94114

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1906

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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