meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326744' 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, 374 Joost Avenue, San Francisco, CA, 94131
ffd_mls_id, 422707539
ffd_salesforce_id, a0E8W00000a7xKYUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 374 Joost Avenue, San Francisco, CA, 94131
pba__address_pb__c, 374 Joost Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Tax records show 936 sq ft. Sellers believe the lower room and bathroom were done prior to their ownership without permit. Buyer to verify legality to their satisfaction. No pre-emptive offers at owner's written request. Offer date Thursday February 2nd at noon. Disclosures: https://app.disclosures.io/link/374-Joost-Avenue-x3d4c8aq
appliances__c, Dishwasher;Free Standing Gas Range
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1955
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-23T11:47:51.000+0000
days_on_market__c, 177
dom__c, 10
ffd_description_pb, Situated on flat portion of Joost Ave, soaking in southern light, this move-in ready single-family home has a clean, interior flow. The main level includes hardwood floor throughout the freshly painted interior. The updated kitchen opens to both the living room and outdoor space encourage entertaining and gatherings. Rise up the backyard steps to a spacious upper patio to unwind and soak in the serene views abound. A front bedroom, bathroom and garden-facing bedroom comprise the main level. Entry level includes small foyer, bonus room and half bath off the garage (room and bathroom not included in publicized square footage). General crawlspace accessible from the garage for storage. Additional 2 car parking in driveway. Nearby Detroit Steps, accessing Monterey Blvd and the jewel of Sunnyside-The Sunnyside Conservatory are within a block and both products of ongoing community engagement. Glen Park Village and BART, Sunnyside Playground and Safeway are all with approximately 1/2 mile. Easy access to 101 and 280 Freeways and public transportation and local schools. This home boasts both a convenient location and amazing views.
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-07-13T18:18:21.000+0000
pba__latitude_pb__c, 37.732548
pba__latitude_property__c, 37.732548
listed_date__c, 2022-11-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Suna Akmese
pba__listing_agent_lastname__c, Mullins
listing_agent_mls_id__c, 814014
ffd_listingagentname, Suna Mullins
listing_agent_number__c, 1063963
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB5
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28396
pba__listingprice_pb__c, 1290000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=gFBoGqUU2LF&mls=1
pba__longitude_pb__c, -122.4437299
lower_level__c, Family Room,Garage,Partial Bath(s),Street Entrance
mls_id__c, 422707539
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-23
original_price__c, 1290000
overall_days_on_market__c, -81471
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-02-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1187.45
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a7xKYUAY
sale_date__c, 2023-02-27
sale_price__c, 1400000
security_features__c, Security Gate
selling_agent_mls_id__c, 317115
selling_agent_number__c, 317115
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1179
size__c, 1179
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Sunnyside
ffd_name, 374 Joost Avenue, San Francisco, CA, 94131
view__c, Bay;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1955
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530571223-1.jpg