ffd_listing_title,2552 24th Avenue, San Francisco, CA, 94116
ffd_mls_id,423721561
ffd_salesforce_id,a0E8W00000bEChGUAW
num_of_fireplaces__c,0
num_of_rooms__c,5
of_units__c,0
address2__c,2552 24th Avenue, San Francisco, CA, 94116
pba__address_pb__c,2552 24th Avenue, San Francisco, CA, 94116
agent_only_remarks__c,Offer to be entertained as come in. Disclosure link https://app.disclosures.io/link/2552-24th-Avenue-es5viug3 Seller would like to keep escrow with First American Title w/Heather Shiffer([email protected]). Call or Text 6502886600 with any question.
appliances__c,Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c,Mid-Century
bath_features__c,Shower Stall(s);Dual Flush Toilet;Skylight/Solar Tube;Quartz
pba__fullbathrooms_pb__c,3
pba__bedrooms_pb__c,3
year_build_text__c,1925
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
cooling__c,None
ffd_createddate,2023-02-16T11:50:27.000+0000
days_on_market__c,28
dom__c,28
ffd_description_pb,A rare find! Fully detached custom home in desirable parkside neighborhood. This gorgeous smart home underwent extensive remodeled w/permits by finest designer's touch. Signature accent paneling stair wall with seemless uniform LED backdrop, new electrical, plumbing, custom cabinets w/ Bertazzoni appliances, keyless entries, stylish signature lighting fixtures and seamless recessed lighting all around house, nest thermostats, integrated ceiling speakers, and EV charging in stylish epoxied garage. Main level features a spacious living room w/ fireplace, open chef's kitchen, inviting dining area, 2 bedrooms w/ customized liner closets, a full bath, and media control closet. 3 skylights throughout bring in natural light. Lower level offers a versatile and iconic guest room/home office/ media room, its hidden premium floor-length mirror/bookshelf door conceals secret entrance/exit, telescopic triple bypass door for versatile privacy and entertainment. An elegant mud room seating area with expansive custom wall storage potential, 24' wine fridge with Unique Coffee Bar, a full bath w/ WD hookups, a master suite w/ bathroom showcases a huge WIC & a free standing tub with large waterfall tub spout. Backyard is drought resistant landscape. Look no further, claim this home yours!
district__c,SF District 2
driveway_sidewalks__c,Paved Driveway
electric__c,220 Volts,220 Volts in Laundry
entry_level__c,0
exterior_features__c,Entry Gate
external_listing__c,1
fencing__c,Back Yard
pba__floortype_pb__c,Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
has_3d_tour__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2023-03-16T10:48:54.000+0000
pba__latitude_pb__c,37.739933
pba__latitude_property__c,37.739933
laundry_features__c,Hookups Only;Electric
listed_date__c,2023-02-15
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Lu
pba__listing_agent_lastname__c,Wang
listing_agent_mls_id__c,816565
ffd_listingagentname,Jenny L Wang
listing_agent_number__c,1075525
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,COMP31
listing_office_name__c,Compass
listing_office_number__c,27894
pba__listingprice_pb__c,1988000
pba__listingtype__c,Sale
pba__listing_website__c,https://my.matterport.com/show/?m=uqwCDUcVcnE
pba__longitude_pb__c,-122.4806035
lower_level__c,Full Bath(s),Garage,Primary Bedroom,Retreat,Street Entrance
mls_id__c,423721561
main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Walk-In Closet;Granite;Dual Flush Toilet
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-02-16
open_house_end__c,2023-03-18T16:00:00.000+0000
open_house_start__c,2023-03-18T14:00:00.000+0000
original_price__c,1988000
overall_days_on_market__c,-81495
parking_access__c,Independent
parking_features__c,Attached,Enclosed,EV Charging,Garage Door Opener,Interior Access
parking_type__c,On Site (Single Family 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,1009.14
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000bEChGUAW
road_surface_type__c,Paved
roof__c,Bitumen;Shingle
room_type__c,Storage;Office;Laundry;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Wine Storage Area;Primary Bathroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;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,1970
size__c,1970
pba__state_pb__c,CA
stories__c,2
pba__street_pb__c,24th
subdist__c,Parkside
ffd_name,2552 24th Avenue, San Francisco, CA, 94116
view__c,City Lights;Water;San Francisco
website_property_type__c,Single Family Home
window_features__c,Dual Pane Full
pba__yearbuilt_pb__c,1925
pba__postalcode_pb__c,94116
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530580104-1.jpg