meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221099' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70678
[post_author] => 4
[post_date] => 2018-11-30 20:31:14
[post_date_gmt] => 2018-11-30 20:31:14
[post_content] => You probably didn't know this neighborhood was a thing -- it's a tiny triangle of land bounded by the 101 to the west, Bayview Park to the east, and the industrial land of the Bayview to the north. It's similar in style to the Bayview, except none of the streets make any sense!
[post_title] => Bayview Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bayview-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:35:30
[post_modified_gmt] => 2023-10-31 16:35:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70678
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 14 Wheat Street, San Francisco, CA, 94124
ffd_mls_id, 421595816
ffd_salesforce_id, a0E1I00000V0GzhUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 14 Wheat Street, San Francisco, CA, 94124
pba__address_pb__c, 14 Wheat Street, San Francisco, CA, 94124
agent_only_remarks__c, Property is not in any showing condition because of much debris needs to be removed first. So, the house is not ready for showing until the debris are cleared. But there is really nothing to show due to extensive fire damage. Please be patient for debris removal first. Meanwhile, make us an offer we cannot refuse. You just never know. Seller reserve the right to refuse any and all offers.
architectural_style__c, A-Frame
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1907
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-09-17T10:49:56.000+0000
days_on_market__c, 670
dom__c, 7
ffd_description_pb, Fire damaged opportunity. Here is a great chance to own you piece of San Francisco. Conveniently located in the south/east corner of The City lies a hidden gem. Upper level was consisted of 2-bedroom, one bathroom, kitchen with dining area, a bathroom, and a porch. Lower level consists of a basement with one car garage. Back yard end to Bayshore Bl. Fire damage back part of the house and extended to roof. Neighborhood has great weather and easy freeway access.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T16:02:11.000+0000
pba__latitude_pb__c, 37.723256
pba__latitude_property__c, 37.723256
listed_date__c, 2021-09-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Herbert
pba__listing_agent_lastname__c, Ng
listing_agent_mls_id__c, 166807
ffd_listingagentname, Herbert K Ng
listing_agent_number__c, 166807
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 499000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.40038
mls_id__c, 421595816
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-09-17
original_price__c, 499000
overall_days_on_market__c, 151
parking_access__c, Independent
parking_features__c, See Remarks
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-09-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 611.58
pba__propertytype__c, Single Family Residence
id, a0E1I00000V0GzhUAF
road_surface_type__c, Asphalt,Paved
roof__c, Composition
sale_date__c, 2021-10-07
sale_price__c, 581000
selling_agent_mls_id__c, 816326
selling_agent_number__c, 1075288
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, The Canlas Brothers
pba__status__c, Closed
pba__totalarea_pb__c, 950
size__c, 950
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Wheat
subdist__c, Bayview Heights
ffd_name, 14 Wheat Street, San Francisco, CA, 94124
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530324691-1.jpg
ListingId, a0E1I00000V0GzhUAF