_yoast_indexnow_last_ping,1700050208
ffd_listing_title,404 Ashbury Street #2, San Francisco, CA, 94117
ffd_mls_id,423920521
ffd_salesforce_id,a0E8W00000dxXnOUAU
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,7
address2__c,404 Ashbury Street #2, San Francisco, CA, 94117
pba__address_pb__c,404 Ashbury Street #2, San Francisco, CA, 94117
agent_only_remarks__c,First time sold as TICs: DRE approved purchase contract and budget are in disclosures. 30-year fixed fractional loans are now available! For more information and showing requests, please contact Mark Brown 415-359-5576.
appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c,Tub w/Shower Over;Shower Stall(s);Tile;Double Sinks;Window
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,1900
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Mark Brown
pba__contingentdate__c,2023-11-12
ffd_createddate,2023-11-03T10:48:42.000+0000
days_on_market__c,12
dom__c,12
ffd_description_pb,Newly remodeled three-bed home in the fabulous Haight-Ashbury neighborhood! Step out of the front door of this trophy building and enjoy the eclectic shops and hip entertainment on Haight Street. Go for a stroll or exercise in the picturesque Panhandle of Golden Gate Park, opposite your new home. A gorgeous, spacious kitchen has plentiful shaker-style cabinets, gleaming quartz counters, designer tile backsplash, and LG stainless steel appliances. The open concept kitchen/living area suits modern living. Tall ceilings and new double-pane windows fill the home with sunlight. The large hall bathroom boasts a luxurious tub with shower, modern tile, sleek new vanity, and laundry hook-ups. The rear bedroom includes an en-suite bath with tiled walk-in shower and double-vanity. New features include pendant and LED lighting and beautiful wide-plank oak floors. This historic building is ready for the 21st century with fire sprinkler and fire alarm systems plus an upgraded foundation. With a Walk Score of 97, this is the perfect City home!
district__c,SF District 5
entry_level__c,0
external_listing__c,1
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,468
pba__hoafrequency_pb__c,Monthly
hoa__c,Yes
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Wall Furnace;Fireplace(s)
ffd_lastmodifieddate,2023-11-15T11:47:30.000+0000
pba__latitude_pb__c,37.7715633
pba__latitude_property__c,37.7715633
laundry_features__c,Hookups Only
listed_date__c,2023-11-02
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Tim
pba__listing_agent_lastname__c,Brown
listing_agent_mls_id__c,197834
ffd_listingagentname,Tim A Brown
listing_agent_number__c,197834
listing_co_agent_mls_id__c,807124
listing_co_agent_number__c,166018264
listing_co_office_mls_id__c,KWADVSF
listing_co_office_name__c,KW Advisors
listing_co_office_number__c,28861
listing_office_mls_id__c,KWADVSF
listing_office_name__c,KW Advisors
listing_office_number__c,28861
pba__listingprice_pb__c,995000
pba__listingtype__c,Sale
pba__listing_website__c,https://haight-ashburyhomes.com
pba__longitude_pb__c,-122.4474275
mls_id__c,423920521
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,0
on_market_date__c,2023-11-03
original_price__c,995000
overall_days_on_market__c,-81755
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,847.53
pba__propertytype__c,Tenancy In Common
ListingId,a0E8W00000dxXnOUAU
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,Contingent - Show
pba__totalarea_pb__c,1174
size__c,1174
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Ashbury
subdist__c,Haight Ashbury
ffd_name,404 Ashbury Street #2, San Francisco, CA, 94117
website_property_type__c,Tenancy In Common
window_features__c,Dual Pane Full;Window Screens
pba__yearbuilt_pb__c,1900
pba__postalcode_pb__c,94117
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530700414-1.jpg