meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325788' 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] => 2018-11-01 21:53:52
[post_modified_gmt] => 2018-11-01 21:53:52
[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, 528 Hearst Avenue, San Francisco, CA, 94112
ffd_mls_id, 423714876
ffd_salesforce_id, a0E8W00000a71kbUAA
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 528 Hearst Avenue, San Francisco, CA, 94112
pba__address_pb__c, 528 Hearst Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Supra lockbox 9 a.m. to 6 p.m. daily. Disclosures available upon request. 528hearst.com
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker;Self/Cont Clean Oven;Gas Cook Top;Plumbed For Ice Maker;Gas Plumbed
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-13T23:46:17.000+0000
days_on_market__c, 36
dom__c, 5
ffd_description_pb, Spacious bright and airy fully detached home on best block in Sunnyside. Situated on wide lot this home enjoys 1,300 square feet of charming space on the main level. Entry foyer, living room with fireplace, formal dining room, eat-in updated kitchen, pantry, 2 bedrooms, full bath, deck to yard and patio with lanai. 1,300 square foot lower level with non-conforming bonus room, laundry, storage, workbench and 2 car garage. located close to all amenities. 100 years in the same family.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Fireplace
external_listing__c, 1
fencing__c, Back Yard;Wood;Vinyl
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Linoleum;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-02-18T11:49:09.000+0000
pba__latitude_pb__c, 37.7308943
pba__latitude_property__c, 37.7308943
laundry_features__c, In Garage;Laundry Closet;In Basement;Washer Included;Dryer Included;Electric;Sink
listed_date__c, 2023-01-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, James
pba__listing_agent_lastname__c, McInerney
listing_agent_mls_id__c, 040543
ffd_listingagentname, James S McInerney
listing_agent_number__c, 40543
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MCIN
listing_office_name__c, McInerney Real Estate
listing_office_number__c, 1502
pba__listingprice_pb__c, 1249000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4495382
lower_level__c, Garage,Street Entrance
mls_id__c, 423714876
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-01-13
original_price__c, 1249000
overall_days_on_market__c, -81461
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Covered Patio
pba__pendingdate__c, 2023-01-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-02-17T19:49:00.000+0000
price_per_square_foot__c, 923.08
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a71kbUAA
road_surface_type__c, Asphalt
roof__c, Shingle
room_type__c, Storage;Bonus Room;Kitchen;Converted Garage;Living Room;Workshop;Primary Bedroom
sale_date__c, 2023-02-17
sale_price__c, 1200000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 809013
selling_agent_number__c, 1039719
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, 1300
size__c, 1300
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hearst
subdist__c, Sunnyside
ffd_name, 528 Hearst Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568656-1.jpg