meta_query='key:subdist__c;value:Pine Lake Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234535' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70662
[post_author] => 4
[post_date] => 2018-11-30 20:30:36
[post_date_gmt] => 2018-11-30 20:30:36
[post_content] => Where Yorba meets Crestlake meets Escondido, and a couple dozen homes perch above Pine Lake Park. It's a slight sliver of a neighborhood defined by Crestlake Street encircling the top of -- wait for it -- Pine Lake Park. Welcome to a dog lover's paradise.
[post_title] => Pine Lake Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pine-lake-park
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-30 20:30:36
[post_modified_gmt] => 2018-11-30 20:30:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70662
[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, 2788 35th Avenue, San Francisco, CA, 94116
ffd_mls_id, 422621993
ffd_salesforce_id, a0E8W00000V3ADbUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2788 35th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2788 35th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Dear Agent, Please go directly to property and thank you for showing to your client. Please follow Covid-19 protocol. Please leave business card. There is un-warranted bedroom and full bathroom on the basement. Disclosure is available on Homelight upon request. Escrow with Kim Diep 415-405-1304 Chicago Title Company. Seller is very motivated!
appliances__c, Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Bidet;Skylight/Solar Tube;Jack & Jill
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Budi Hartono
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-01-20T11:48:00.000+0000
days_on_market__c, 273
dom__c, 21
ffd_description_pb, Rare opportunity to own a house in this quiet neighborhood with easy access to highway. Lovely 3 Bedrooms/2 Bathrooms home with lots of natural light located between Pine Lake Park and Lake Merced. Walking distance to Stern Grove, Lakeshore Shopping Center and Stonestown Mall with great schools nearby. Spacious living room with fireplace and an open kitchen with dining area. Master bedroom and a family room/office on the main level. Additional 2 Bedrooms with a Jack & Jill bathroom on the 3rd level. One-car garage with lots of storage space and an expansive backyard with lots of potential for gardening and entertaining.
district__c, SF District 3
entry_level__c, 0
exterior_features__c, Balcony
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
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2022-03-11T17:36:38.000+0000
pba__latitude_pb__c, 37.735496
pba__latitude_property__c, 37.735496
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2022-01-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Siok Ming
pba__listing_agent_lastname__c, Tjong
listing_agent_mls_id__c, 815368
ffd_listingagentname, Siok Ming Tjong
listing_agent_number__c, 1072551
listing_co_agent_mls_id__c, 816245
listing_co_agent_number__c, 1075214
listing_co_office_mls_id__c, COLD02
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 874
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1599000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4921169
mls_id__c, 422621993
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Living Room;Family Room
master_bathroom_features__c, Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-20
original_price__c, 1599000
overall_days_on_market__c, 42
parking_access__c, Independent
parking_features__c, Private
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-02-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-03-07T22:10:02.000+0000
price_per_square_foot__c, 969.3
pba__propertytype__c, Single Family Residence
id, a0E8W00000V3ADbUAN
road_surface_type__c, Asphalt
sale_date__c, 2022-03-07
sale_price__c, 1768000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL5087505
selling_agent_number__c, 981367945
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, eXp Realty of California Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 1824
size__c, 1824
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 35th
subdist__c, Pine Lake Park
ffd_name, 2788 35th Avenue, San Francisco, CA, 94116
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530387770-1.jpg
ListingId, a0E8W00000V3ADbUAN