ffd_listing_title,41 Delmar Street, San Francisco, CA, 94117
ffd_mls_id,423724832
ffd_salesforce_id,a0E8W00000bEzXIUA0
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,2
address2__c,41 Delmar Street, San Francisco, CA, 94117
pba__address_pb__c,41 Delmar Street, San Francisco, CA, 94117
agent_only_remarks__c,Rare Condo with Fully Deeded Garden - Call John for highest best use of bonus lower level rooms.
appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Gas Cook Top;Free Standing Freezer;Warming Drawer
architectural_style__c,Edwardian
bath_features__c,Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,2
year_build_text__c,1904
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-03-03T16:49:27.000+0000
days_on_market__c,28
dom__c,28
ffd_description_pb,Sophisticated finishes, custom design, full floor 2BD/1.5BA condo w/ DEEDED GARDEN; the condo also includes two spacious, deeded, unwarranted rooms and a bath on the garden level with awesome potential. Lavish detail in spa-like baths, professionally equipped Italian Scavolini kitchen: Stainless Chef's range Range, Carrera bar, cherry cabinets, custom stainless counters. Full size, in-unit laundry custom closets & polished period detail create the ultimate, practical, urban retreat. Deeded to the property on the lower level are two unwarranted rooms and a bath with high ceilings, & direct walkout access to a landscaped exclusive-use garden. Parking for 1 car + storage. This perfect neighborly location keeps you firmly in the mix at the intersection of Cole Valley, Buena Vista Park, Ashbury Heights & the Divisadero Corridor.
district__c,SF District 5
entry_level__c,0
exterior_features__c,Dog Run
external_listing__c,1
fencing__c,Back Yard;Fenced
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,400
pba__hoafrequency_pb__c,Monthly
hoa_name__c,39-41 Delmar HOA
hoa__c,Yes
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2023-03-30T10:48:16.000+0000
pba__latitude_pb__c,37.768377
pba__latitude_property__c,37.768377
laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included
listed_date__c,2023-03-01
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,John
pba__listing_agent_lastname__c,DiDomenico
listing_agent_mls_id__c,276181
ffd_listingagentname,John R DiDomenico
listing_agent_number__c,276181
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,1695000
pba__listingtype__c,Sale
pba__listing_website__c,https://vimeo.com/803954984/41fa1d55d8
pba__longitude_pb__c,-122.44598
lower_level__c,Family Room,Full Bath(s),Retreat
mls_id__c,423724832
main_level__c,Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_property__c,a0O8W00000HtdcZUAR
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-03-02
open_house_end__c,2023-04-01T16:00:00.000+0000
open_house_start__c,2023-04-01T14:00:00.000+0000
original_price__c,1695000
overall_days_on_market__c,-81509
parking_access__c,Tandem
parking_features__c,Tandem Garage
parking_type__c,On Site - Unassigned (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,1070.08
pba__propertytype__c,Condominium
ListingId,a0E8W00000bEzXIUA0
roof__c,Flat
room_type__c,Bonus Room;Kitchen;Living Room;Dining Room;Possible Guest;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,1584
size__c,1584
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Delmar
subdist__c,Haight Ashbury
ffd_name,41 Delmar Street, San Francisco, CA, 94117
website_property_type__c,Condominium
window_features__c,Bay Window(s)
pba__yearbuilt_pb__c,1904
pba__postalcode_pb__c,94117
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530586463-1.jpg