meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214409' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15556
[post_author] => 4
[post_date] => 2018-11-01 21:53:52
[post_date_gmt] => 2018-11-01 21:53:52
[post_content] => Not always sunny, shameless neighborhood self-promotion aside. Within walking distance to Glen Park BART, mostly single-family homes, bisected by Monterey Ave. Above, Sunnyside on a hill with some great southern views. Below, Sunnyside flatlands bounded by I-280 and City College to the south.
[post_title] => Sunnyside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sunnyside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-22 11:37:36
[post_modified_gmt] => 2024-11-22 19:37:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15556
[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, 154 Hearst Avenue, San Francisco, CA, 94131
ffd_mls_id, 504992
ffd_salesforce_id, a0E1I00000TGB4xUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 154 Hearst Avenue, San Francisco, CA, 94131
pba__address_pb__c, 154 Hearst Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Please send signed PEAD V in order to receive appointment time and CBS code. In person viewing is to follow the advised Covid health safety protocols when entering the property. Please provide yourself and your clients with necessary PPE. Disclosure package is available. Buyer to research square footage and room count if desired. Tax Record and existing space wasn't verified by Seller or Agent. All the windows have been boarded for security/safety. Pre Sale Escrow with North American Title, Katerina Rosignuolo, #20-01671
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-31T21:46:09.000+0000
days_on_market__c, 1052
dom__c, 10
ffd_description_pb, This is a Wonderful Opportunity for someone looking for an Edwardian Fixer in the Sunnyside Neighborhood. Take this home to the next level. The large yard plus curb appeal will help in the transformation. The ability to walk to BART and Downtown Glen Park will increase the desirability.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:32:48.000+0000
pba__latitude_pb__c, 37.7309129
pba__latitude_property__c, 37.7309129
listed_date__c, 2020-08-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Kenny
listing_agent_mls_id__c, 800922
ffd_listingagentname, John Kenny
listing_agent_number__c, 800922
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, C-BA
listing_office_name__c, Century 21 Baldini Realty
listing_office_number__c, 770
pba__listingprice_pb__c, 899995
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4410108
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Partial Bath(s)
mls_id__c, 504992
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-31
original_price__c, 899995
overall_days_on_market__c, 122
parking__c, Attached,Garage,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-09-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 642.86
pba__propertytype__c, Single Family Residence
id, a0E1I00000TGB4xUAH
sale_date__c, 2020-09-24
sale_price__c, 855000
selling_agent_mls_id__c, 800922
selling_agent_name__c, John J. Kenny
selling_agent_number__c, 800922
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Century 21 Baldini Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1330
size__c, 1330
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hearst
subdist__c, Sunnyside
ffd_name, 154 Hearst Avenue, San Francisco, CA, 94131
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369365-1.jpg
ListingId, a0E1I00000TGB4xUAH