meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216968' 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, 971 Le Conte Avenue, San Francisco, CA, 94124
ffd_mls_id, 421517092
ffd_salesforce_id, a0E1I00000Tvv0hUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 971 Le Conte Avenue, San Francisco, CA, 94124
pba__address_pb__c, 971 Le Conte Avenue, San Francisco, CA, 94124
agent_only_remarks__c, BOM due to court confirmation needed. Probate sale with court confirmation. Death in the house due to natural cause at elder age. Show by appointment through Calendly Link here: https://calendly.com/jennyyinghe/971-le-conte. Seller requests buyers to pay transfer tax and takes responsibility of water/energy compliances. Escrow is opened with Linda Yee at Old Republic Title. Disclosures link: https://app.disclosures.io/link/971-Le-Conte-Avenue-skdc5ivt. All offers should be in probate purchase contract with 10% cashier's check pay to "Old Republic Title".Court hearing date scheduled for 6/1/21 9am in Dept 204 at San Francisco Superior Court, 400 McAllister Street, San Francisco, CA 94102. Minimum overbid $910,000.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-02-16T00:53:10.000+0000
days_on_market__c, 894
dom__c, 116
ffd_description_pb, Le Conte is a quiet street in Bayview Heights. Well Kept View house with two bedrooms one bath. Updated kitchen with stainless steel appliances and full mosaic backsplash. Beautiful city views from living room and dining area. Private back yard with deck. New furnace. Bonus room at garage level. One car garage with parking on the drive way. Walk to T-line bus stop. Court hearing date scheduled for 6/1/21 9am in Dept 204 at San Francisco Superior Court, 400 McAllister Street, San Francisco, CA 94102. Minimum overbid $910,000.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:44:16.000+0000
pba__latitude_pb__c, 37.7178533
pba__latitude_property__c, 37.7178533
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-02-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ying
pba__listing_agent_lastname__c, He
listing_agent_mls_id__c, 805815
ffd_listingagentname, Jenny Ying He
listing_agent_number__c, 166015869
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CAFH
listing_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
listing_office_number__c, 166014509
pba__listingprice_pb__c, 914000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3960617
mls_id__c, 421517092
main_level__c, Full Bath(s);Bedroom(s);Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-02-05
original_price__c, 849000
overall_days_on_market__c, 163
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-06-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1034.48
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tvv0hUAB
roof__c, Bitumen
room_type__c, Storage
sale_date__c, 2021-06-10
sale_price__c, 870000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL472247
selling_agent_number__c, 981205332
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Voyage Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 841
size__c, 841
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Le Conte
subdist__c, Bayview Heights
ffd_name, 971 Le Conte Avenue, San Francisco, CA, 94124
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530178633-1.jpg
ListingId, a0E1I00000Tvv0hUAB