_yoast_indexnow_last_ping,1725540721
ffd_listing_title,248 Ordway Street, San Francisco, CA, 94134
ffd_mls_id,424055234
ffd_salesforce_id,a0EUd0000031kzxMAA
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,0
address2__c,248 Ordway Street, San Francisco, CA, 94134
pba__address_pb__c,248 Ordway Street, San Francisco, CA, 94134
agent_only_remarks__c,Shows beautifully. Show and sell. Contact agent for disclosures and offers. Down to the studs renovation, new Andersen windows throughout, tankless water heater and new central heat, new plumbing and electrical. All completed with permits. Stunning views from all windows!
appliances__c,Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Ice Maker
architectural_style__c,Contemporary;Modern/High Tech
bath_features__c,Dual Flush Toilet;Double Sinks
pba__fullbathrooms_pb__c,3
pba__bedrooms_pb__c,4
year_build_text__c,1952
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
cooling__c,None
ffd_createddate,2024-09-04T16:46:23.000+0000
days_on_market__c,27
dom__c,25
ffd_description_pb,This exquisite 2,031-square-foot residence features 4 spacious bedrooms and 3 luxurious bathrooms, offering breathtaking views from every room through impressive floor-to-ceiling windows. Marvel at the entire downtown skyline and both spans of the Bay Bridge, as these awe-inspiring vistas rejuvenate you. The home has been meticulously renovated to blend modern design with swank amenities, providing the perfect backdrop for sophisticated living. Welcome to your new home!
district__c,SF District 10
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard;Fenced
pba__floortype_pb__c,Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2024-09-05T12:47:00.000+0000
pba__latitude_pb__c,37.7198477
pba__latitude_property__c,37.7198477
laundry_features__c,In Garage
listed_date__c,2024-08-06
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Karen
pba__listing_agent_lastname__c,Cai
listing_agent_mls_id__c,062290
ffd_listingagentname,Karen C Cai
listing_agent_number__c,166017571
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,STERL1
listing_office_name__c,Sterling Real Estate
listing_office_number__c,25589
pba__listingprice_pb__c,1635000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.4034659
lower_level__c,Bedroom(s),Family Room,Retreat
mls_id__c,424055234
main_level__c,Bedroom(s)
master_bathroom_features__c,Double Sinks
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2024-08-09
open_house_end__c,2024-09-07T16:00:00.000+0000
open_house_start__c,2024-09-07T14:00:00.000+0000
original_price__c,1635000
overall_days_on_market__c,-82035
parking_access__c,Independent
parking_features__c,Attached,Garage Door Opener,Interior Access
parking_type__c,On Site (Single Family 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,805.02
pba__propertytype__c,Single Family Residence
ListingId,a0EUd0000031kzxMAA
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,2031
size__c,2031
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Ordway
subdist__c,Visitacion Valley
ffd_name,248 Ordway Street, San Francisco, CA, 94134
view__c,City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Sutro Tower
website_property_type__c,Single Family Home
window_features__c,Dual Pane Full;Window Screens
pba__yearbuilt_pb__c,1952
pba__postalcode_pb__c,94134
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530822201-1.jpg