meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237491' 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, 143 Marston Avenue, San Francisco, CA, 94112
ffd_mls_id, 422672658
ffd_salesforce_id, a0E8W00000XjXTJUA3
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 143 Marston Avenue, San Francisco, CA, 94112
pba__address_pb__c, 143 Marston Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Hello Agents! 1. Supra located on chain link fence in front, go direct 2. Disclosures can be pulled through disclosures.io 3. Escrow officer is Katie Berggren ([email protected] or 650-343-6282). 4. Offers deadline is Tuesday 7/5/22 by 12pm. Please submit offers through disclosures.io & on a SFAR purchase agreement, provide pre-approval letter (if applicable) and proof of funds document. 5. Note that measurements of property tend to vary from source to source and often conflict. There is no official source or standard method of calculation. Buyer(s) and buyer agent(s) should perform their own investigation of the number of rooms.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1912
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Joe Polyak
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-24T19:47:57.000+0000
days_on_market__c, 390
dom__c, 13
ffd_description_pb, Welcome to this charming single-family home located in the beautiful and serene Sunnyside neighborhood. This home features a living room and dining room that lead to the modern upgraded kitchen. Make meals & memories with your brand new stove & fridge! Upstairs you'll find a family room with a fireplace, two bedrooms, and a bathroom. Step outside onto the deck overlooking the extremely spacious backyard! Plenty of room for gathering and entertainment! Attached single car garage, expansive driveway, and additional basement includedmaking storage very convenient. This home is also perfectly positioned to enjoy the proximity to parks, cafes and restaurants, supermarkets, schools, and public transit. Balboa Park, Glen Park, BART stations, and MUNI station are just a couple of blocks away. Quick access to HWY 280/101. Enjoy everything this Sunnyside home has to offer!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Family Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T17:16:33.000+0000
pba__latitude_pb__c, 37.7273147
pba__latitude_property__c, 37.7273147
listed_date__c, 2022-05-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sean
pba__listing_agent_lastname__c, Kelly
listing_agent_mls_id__c, 815659
ffd_listingagentname, Sean Kelly
listing_agent_number__c, 1073852
listing_co_agent_mls_id__c, 814792
listing_co_agent_number__c, 1068311
listing_co_office_mls_id__c, RISEHOME
listing_co_office_name__c, Rise Homes
listing_co_office_number__c, 28134
listing_office_mls_id__c, RISEHOME
listing_office_name__c, Rise Homes
listing_office_number__c, 28134
pba__listingprice_pb__c, 898000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.youtube.com/watch?v=BRMZ6N0852Y
pba__longitude_pb__c, -122.4472948
mls_id__c, 422672658
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-06-24
original_price__c, 898000
overall_days_on_market__c, -81258
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-07-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000XjXTJUA3
roof__c, Shingle
sale_date__c, 2022-08-12
sale_price__c, 1050000
selling_agent_mls_id__c, EB92994
selling_agent_number__c, 981300441
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Marston
subdist__c, Sunnyside
ffd_name, 143 Marston Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530485070-1.jpg
ListingId, a0E8W00000XjXTJUA3