meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211117' 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-03-19 13:31:56
[post_modified_gmt] => 2024-03-19 20:31:56
[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, 359 Hearst 361 Avenue, San Francisco, CA, 94112
ffd_mls_id, 514238
ffd_salesforce_id, a0E1I00000TvvJkUAJ
num_of_rooms__c, 11
of_units__c, 2
address2__c, 359 Hearst 361 Avenue, San Francisco, CA, 94112
pba__address_pb__c, 359 Hearst 361 Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Easy to show the vacant unit and basement level. Please text Aimee Huang at (415)819-6580 for the showing appointments. The tenant-occupied unit has limited showings and will be shown to the interested buyers after they have visited the property. Disclosure is ready in io.
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-16T13:44:54.000+0000
days_on_market__c, 904
dom__c, 44
ffd_description_pb, Rare opportunity to own this unique duplex building in the desirable Sunnyside neighborhood. Nestled in the heart of Sunnyside, this semi-detached Edwardian building provides one vacant unit and one rental-income-producing unit. It is ideal for someone to create a new home or looking for an income investment opportunity. 359 Hearst Ave is currently vacant with two bedrooms and one bath, tall ceilings, and a light-filled environment. 361 Hearst Ave is tenant-occupied with three bedrooms and one bath, tall ceilings, period details, and plenty of natural light. Beautiful views of surrounding hills and valleys from both units. Additional full basement level and large flat backyard have huge upside potential for expansion. Conveniently proximity to schools, Safeway, Wholefoods, BART, buses, parks, and freeway entry.
district__c, SF District 4
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Vinyl
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s);Fireplace Insert
interior_features__c, Skylight(s);Storage Area(s);Vaulted Ceiling(s)
ffd_lastmodifieddate, 2022-01-25T13:32:49.000+0000
pba__latitude_pb__c, 37.730452
pba__latitude_property__c, 37.730452
laundry_features__c, Other;In Common Area
listed_date__c, 2021-01-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Juanjuan
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 808889
ffd_listingagentname, Aimee J Huang
listing_agent_number__c, 1038314
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.445654
mls_id__c, 514238
master_property__c, a0O8W00000DaF7wUAF
parkingspaces__c, 0
on_market_date__c, 2021-01-26
original_price__c, 1095000
overall_days_on_market__c, 125
parking_features__c, Street
pba__pendingdate__c, 2021-03-11
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 538.1
pba__propertytype__c, Duplex
id, a0E1I00000TvvJkUAJ
sale_date__c, 2021-04-21
sale_price__c, 1130000
selling_agent_mls_id__c, 808889
selling_agent_number__c, 1038314
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2100
size__c, 2100
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Hearst
subdist__c, Sunnyside
ffd_name, 359 Hearst 361 Avenue, San Francisco, CA, 94112
view__c, Hills;Valley
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530173243-1.jpg
ListingId, a0E1I00000TvvJkUAJ