meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='225074' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 842 Waller Street, San Francisco, CA, 94117
ffd_mls_id, 478973
ffd_salesforce_id, a0E1I000006EgaoUAC
address2__c, 842 Waller Street, San Francisco, CA, 94117
pba__address_pb__c, 842 Waller Street, San Francisco, CA, 94117
agent_only_remarks__c, This pride or ownership property is wood frame with a concrete foundation that was redone in 2009. At the same time a steel beam was added and the building was bolted to the foundation. The majority of the units have stunning postcard views of San Francisco and the unit mix consists of three (3 room) one-bedroom one bath units, three (4-room) one-bedroom one bath units, and a large garden in-law unit that is currently owner occupied until the close of escrow.
year_build_text__c, 1900
pba__city_pb__c, San Francisco
ffd_createddate, 2018-11-24T11:45:57.000+0000
days_on_market__c, 1699
dom__c, 21
ffd_description_pb, This pride or ownership property is wood frame with a concrete foundation that was redone in 2009. At the same time a steel beam was added and the building was bolted to the foundation. The majority of the units have stunning postcard views of San Francisco and the unit mix consists of three (3 room) one-bedroom one bath units, three (4-room) one-bedroom one bath units, and a large garden in-law unit that is currently owner occupied until the close of escrow. There is coin operated laundry and abundant storage space. Heat is provided by individual gas wall heaters. Exterior paint 2018, electric service upgraded and all copper plumbing.
district__c, SF District 5
external_listing__c, 1
ffd_lastmodifieddate, 2022-10-14T14:00:25.000+0000
pba__latitude_pb__c, 37.770520
pba__latitude_property__c, 37.770520
listed_date__c, 2018-11-23
pba__listing_agent_firstname__c, Jay
pba__listing_agent_lastname__c, Greenberg
listing_agent_mls_id__c, 980144
listing_agent_number__c, 980144
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, ALPRIG
listing_office_name__c, Alain Pinel Investment Group
listing_office_number__c, 166014583
pba__listingprice_pb__c, 3395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.437691
pba__lotsize_pb__c, 0.08
mls_id__c, 478973
parkingspaces__c, 0
on_market_date__c, 2018-11-23
original_price__c, 3395000
overall_days_on_market__c, 1699
price_per_square_foot__c, 630.2
pba__propertytype__c, 5 - 15 Unit
id, a0E1I000006EgaoUAC
sale_date__c, 2019-01-31
sale_price__c, 3560000
selling_agent_mls_id__c, 806166
selling_agent_name__c, Samantha P. Yu
selling_agent_number__c, 166016385
selling_co_agent_mls_id__c, 398477
selling_co_agent_name__c, Callum C. Hutchins
selling_co_agent_number__c, 398477
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 5649
size__c, 5649
pba__state_pb__c, CA
pba__street_pb__c, Waller
subdist__c, Ashbury Heights;Buena Vista Heights
ffd_name, 842 Waller Street, San Francisco, CA, 94117
website_property_type__c, 5 - 15 Unit
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/344967-1.jpg
ListingId, a0E1I000006EgaoUAC