822 Duncan Street, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1713005990

ffd_listing_title,514 Clipper 518 Street, San Francisco, CA, 94114

ffd_mls_id,424020347

ffd_salesforce_id,a0EUd000001jDIIMA2

num_of_rooms__c,10

of_units__c,2

address2__c,514 Clipper 518 Street, San Francisco, CA, 94114

pba__address_pb__c,514 Clipper 518 Street, San Francisco, CA, 94114

agent_only_remarks__c,VACANT- Lower Level Unit on Supra Lockbox. Show Anytime. Upper Penthouse is tenant occupied at $3511.35 rent Month to Month. Please do not disturb occupants. Tenant Occupied Unit will ONLY be shown on Tuesday Broker Tours from 12noon-2pm. Buyer MUST BE with agent to enter tenant occupied flat on the Broker Tour. Offers welcome on Wednesday, 4/24/24 by 10:00 am to [email protected]. Offer to have copy of 10% cashier's check made payable to Old Republic Title 2566 Ocean Ave, Officer Christine Lim. Buyer to use the CAR Purchase Contract with the Probate Purchase Addendum. This sale is subject to heirs approval and MAY or MAYBE NOT be subject to Probate Court approval. Purchase contract addenda gives buyer right to cancel contract if Probate Court is required. Buyer to sign disclosure package. Former owner died in the lower unit last October 2023. No Preemptive offers will be reviewed. Seller reserves the right to accept, counter or reject any offer.

appliances__c,Dishwasher;Gas Water Heater;Microwave;Disposal;Free Standing Gas Oven;Free Standing Refrigerator

architectural_style__c,Marina

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Tim Hawko

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-04-12T22:48:35.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Two unit residence rebuilt to a modern standard in 1995 and situated on a deep lot with a lush rear garden that takes full advantage of Noe Valley's localized microclimate. Detached on three sides with a Marina-Style facade, these spacious units have superior floor-plans and features that reflect contemporary style and design. The two-level unit lives like a townhome and overlooks the uncommonly private garden with wood patios, lush plantings and firepit. This unit has engineered flooring on the main level, custom designed kitchen with an abundance of cabinets, quartz counters and stainless appliances. Additionally this unit has direct garage access, two generous sized bedrooms and a full bath with shower over tub. The top floor unit is tenant occupied and is a 2-bed/2-bath including a primary suite with en-suite bath, private balcony, living room with fireplace and dining room that opens to the kitchen. Wonderfully located near Douglass Playground and just blocks to the best of 24th Street.

district__c,SF District 5

exterior_features__c,Fenced Yard

external_listing__c,1

pba__floortype_pb__c,Carpet;Laminate;Wood;Varies by Unit

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas;Fireplace(s)

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-04-13T10:48:17.000+0000

pba__latitude_pb__c,37.748978

pba__latitude_property__c,37.748978

laundry_features__c,In Common Area;Varies by Unit

listed_date__c,2024-03-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Kathleen

pba__listing_agent_lastname__c,Tostanoski

listing_agent_mls_id__c,810040

ffd_listingagentname,Katie A Tostanoski

listing_agent_number__c,1044436

listing_co_agent_mls_id__c,378394

listing_co_agent_number__c,378394

listing_co_office_mls_id__c,PKNO

listing_co_office_name__c,Park North Real Estate

listing_co_office_number__c,24343

listing_office_mls_id__c,PKNO

listing_office_name__c,Park North Real Estate

listing_office_number__c,24343

pba__listingprice_pb__c,1288000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.436551

mls_id__c,424020347

parkingspaces__c,2

on_market_date__c,2024-04-12

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

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

original_price__c,1288000

overall_days_on_market__c,-81916

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

patio_and_porch_features__c,Balcony/Deck

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,560

pba__propertytype__c,Duplex

ListingId,a0EUd000001jDIIMA2

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

size__c,2300

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Clipper

subdist__c,Noe Valley

ffd_name,514 Clipper 518 Street, San Francisco, CA, 94114

view__c,City;City Lights;Garden/Greenbelt;Downtown;San Francisco;Hills;Varies by Unit

website_property_type__c,Duplex

window_features__c,Bay Window(s);Dual Pane Partial;Varies by Unit

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1712973591

ffd_listing_title,1565 Noe Street, San Francisco, CA, 94131

ffd_mls_id,424020893

ffd_salesforce_id,a0EUd000001j1qcMAA

num_of_rooms__c,14

of_units__c,4

address2__c,1565 Noe Street, San Francisco, CA, 94131

pba__address_pb__c,1565 Noe Street, San Francisco, CA, 94131

agent_only_remarks__c,*2.5% to selling broker. There are 4 units: 3 are tenant occupied, 1 is vacant (1-Bedroom with parking) and can be an owner's residence. Great newer (1975) building for first-time investors! Please bring clients to Listed OHs & Brokers to view tenants' units. Property sold As-Is. Buyer to investigate to their satisfaction. Questions or for disclosures pls email: [email protected] or call LA. Please include a signed disclosure cover page, proof of funds, pre-approval letter w/offer. Seller & brokers do not warrant accuracy of square footage in tax records. Buyer to investigate square footage to their satisfaction. Pre-escrow with FNT (Michael Gaffney).

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

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,6

year_build_text__c,1975

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Mike Tekulsky

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-12T19:48:01.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Situated on a lovely street in Noe Valley, this superb investment opportunity was built in 1975 and has smart upgrades that offer timeless appeal. This 4-unit building was well-constructed and will stand as a coveted asset in your portfolio, or a fantastic first-time investment too! Comprising two 2-BR and two 1-BR apartments in 3,030 SF (re: property tax records), there are 4 parking spaces, common laundry, storage, skylit stairwell, and landscaped backyard. All units have modern kitchens w/ a full suite of appliances, beautiful bathrooms, spacious rooms, plenty of natural light, pleasant city outlooks towards neighboring hills. Splendid curb appeal with walkability is a huge selling point. Residents take advantage of an amazing pedestrian experience with Slow Street Sanchez a block away. Whole Foods, 24th Street eateries & Upper Noe Rec Center ensures an unparalleled convenient lifestyle. Not to be restricted by the Noe border, you can easily reach Mitchell's Ice Cream, Mission St, Glen Canyon Park & BART. For commuters there is easy access to MUNI & freeways South. This Noe Valley location has endured as very popular. With an unoccupied unit, owner-occupants and investors can both view this as an enticing chance to own a piece of this wonderful community.

district__c,SF District 5

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,Wall Furnace

interior_features__c,Formal Entry;Skylight(s)

ffd_lastmodifieddate,2024-04-13T01:47:23.000+0000

pba__latitude_pb__c,37.7439182

pba__latitude_property__c,37.7439182

laundry_features__c,In Common Area;Washer/Dryer Owned;Varies by Unit

listed_date__c,2024-03-14

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ron

pba__listing_agent_lastname__c,Wong

listing_agent_mls_id__c,806373

ffd_listingagentname,Ron Wong

listing_agent_number__c,164505277

listing_co_agent_mls_id__c,806372

listing_co_agent_number__c,164505236

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.1565Noe.com

pba__longitude_pb__c,-122.4308277

mls_id__c,424020893

parkingspaces__c,4

on_market_date__c,2024-04-12

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

overall_days_on_market__c,-81916

parking_features__c,Garage,Garage Door Opener,Interior Access

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,709.57

pba__propertytype__c,Quadruplex

ListingId,a0EUd000001j1qcMAA

roof__c,Tar/Gravel

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Extinguisher;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,3030

size__c,3030

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Noe

subdist__c,Noe Valley

ffd_name,1565 Noe Street, San Francisco, CA, 94131

view__c,City;Garden/Greenbelt

website_property_type__c,Quadruplex

window_features__c,Window Coverings;Dual Pane Partial

pba__yearbuilt_pb__c,1975

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713005973

ffd_listing_title,27 Fountain 29 Street, San Francisco, CA, 94114

ffd_mls_id,424022401

ffd_salesforce_id,a0EUd000001iYbiMAE

num_of_fireplaces__c,1

num_of_rooms__c,9

of_units__c,0

address2__c,27 Fountain 29 Street, San Francisco, CA, 94114

pba__address_pb__c,27 Fountain 29 Street, San Francisco, CA, 94114

agent_only_remarks__c,Schedule a private showing by emailing [email protected]. Feel free to text Wendy 415-519-6091 with questions. Disclosures:https://app.disclosures.io/link/2729-Fountain-Street-85vjmkul

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Wine Refrigerator

architectural_style__c,Contemporary;Edwardian;Modern/High Tech;See Remarks

bath_features__c,Tile;Low-Flow Toilet(s);Radiant Heat;Stone

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1905

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-12T02:46:46.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Conceived & built with a supple interplay of airy, luminous energy & hand-crafted warmth, this home's fresh design is anchored on a rigorous link to nature, impressive views & its serene Noe location. A classic Edwardian framework has been opened, embracing a 2-level open space at its core, glowing like a lantern, an inviting, permeable axis point from which to explore its indoor/outdoor essence. A majestic entry is the central navigation point to all parts of the main home. Purposeful, flexible spaces for life & entertainment include an impressive foyer, formal living & central study, populated by bespoke, thoughtfully designed storage, all flooded with natural light. Exquisite custom kitchen, family & dining, decks on both sides offer easy access to the VIEWS, lush, deep lot, hot tub & outdoor shower. Upstairs are 3 bedrooms, 2 baths with a soul-of-a-classic-home generosity & charm. Primary suite is a study in privacy & repose, vessel tub, separate shower & private view deck. The garden flat is a perfect, robust guest, party/ family space or discrete well-appointed residence & street entry. A restrained range of elemental materials: wood, stone, metal & home tech; solid building practices inform this rare residence the ultimate in stealth luxury, a durable forthright home.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

electric__c,220 Volts

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Piped

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant;Radiant Floor;Central;Fireplace(s)

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

ffd_lastmodifieddate,2024-04-13T10:47:27.000+0000

pba__latitude_pb__c,37.750365

pba__latitude_property__c,37.750365

laundry_features__c,Laundry Closet;Inside Area

listed_date__c,2024-04-11

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Wendy

pba__listing_agent_lastname__c,Storch

listing_agent_mls_id__c,803139

ffd_listingagentname,Wendy Storch

listing_agent_number__c,803139

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,5985000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.44132

lower_level__c,Bedroom(s),Family Room,Kitchen,Living Room,Loft,Retreat,Street Entrance

mls_id__c,424022401

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

master_bathroom_features__c,Double Sinks;Soaking Tub;Radiant Heat

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,3

on_market_date__c,2024-04-11

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

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

original_price__c,5985000

overall_days_on_market__c,-81915

parking_access__c,Independent

parking_features__c,Attached,Enclosed,Garage Door Opener

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,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,1554.55

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001iYbiMAE

road_surface_type__c,Asphalt

roof__c,Bitumen;Shingle

room_type__c,Office;Laundry;Kitchen;Library;In Law Apartment;Living Room;Guest Quarters;Dining Room;Great Room;Primary Bathroom

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

size__c,3850

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Fountain

subdist__c,Noe Valley

ffd_name,27 Fountain 29 Street, San Francisco, CA, 94114

view__c,City;Garden/Greenbelt;Bay;Downtown;San Francisco;Mountains

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1905

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1712969785

ffd_listing_title,4171 24th Street #301, San Francisco, CA, 94114

ffd_mls_id,424022609

ffd_salesforce_id,a0EUd000001iXr2MAE

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,6

address2__c,4171 24th Street #301, San Francisco, CA, 94114

pba__address_pb__c,4171 24th Street #301, San Francisco, CA, 94114

agent_only_remarks__c,Monthly HOA due for this unit is $ 559.19. Two square footages: 1450 sq. ft. from Assessor's Report and 1275 sq. ft. from Condo Plan. Buyer to verify square footage accuracy. www.417124th-301.com

appliances__c,Dishwasher;Disposal;Tankless Water Heater;Free Standing Refrigerator;Gas Cook Top;Gas Plumbed

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,2018

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-12T00:47:11.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Upscale delightful 3BR/2BA sunlit residence situated in the heart of Noe Valley, one of San Francisco's most coveted neighborhoods. Built in 2018, #301 boasts many luxuries including south-facing private deck with views, Nest Thermostat, iPad enabled Sonos home audio and video intercom system, Wide Plank White Oak floors, Quartz Countertops, Porcelain Tile, gleaming Custom Cabinetry, Gas Cooktop, Grohe & Blanco fixtures and in-unit W/D. Open-concept living/dining room, convenient access to trendy eateries & transportation, additional dedicated storage & bicycle parking and private elevator access make this a residence you will proud to call home.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,559

pba__hoafrequency_pb__c,Monthly

hoa_name__c,4171 24th Street Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-04-13T00:47:15.000+0000

pba__latitude_pb__c,37.751082

pba__latitude_property__c,37.751082

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-04-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Luke

pba__listing_agent_lastname__c,O'Brien

listing_agent_mls_id__c,804903

ffd_listingagentname,Luke A O'Brien

listing_agent_number__c,166014623

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,SFCITY

listing_office_name__c,SF City Properties

listing_office_number__c,28315

pba__listingprice_pb__c,1950000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.435558

mls_id__c,424022609

master_property__c,a0O1I000001xhbmUAA

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-11

open_house_end__c,2024-04-13T15:30:00.000+0000

open_house_start__c,2024-04-13T13:00:00.000+0000

original_price__c,1950000

overall_days_on_market__c,-81915

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001iXr2MAE

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

size__c,1450

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,24th

subdist__c,Noe Valley

ffd_name,4171 24th Street #301, San Francisco, CA, 94114

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2018

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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