meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319886' 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 126 Joost Street, San Francisco, CA, 94131
ffd_mls_id 422701827
ffd_salesforce_id a0E8W00000ZMe97UAD
num_of_fireplaces__c 1
num_of_rooms__c 4
of_units__c 0
address2__c 126 Joost Street, San Francisco, CA, 94131
pba__address_pb__c 126 Joost Street, San Francisco, CA, 94131
agent_only_remarks__c Please do not use Showtime, contact agent directly. Transparent pricing! Withdrew from market in summer due to the very slow market. Seller plans to put it back on MLS in January but will sell now. Family guest occupying - please allow some notice to show. Will be delivered vacant. Note graphic artists stated 1125 sq ft. Square footage has not been verified by seller nor agent.As-Is trust sale. Disclosures available on d.io
appliances__c Dishwasher;Disposal;Gas Cook Top
architectural_style__c Modern/High Tech;Mid-Century
bath_features__c Tub w/Shower Over
pba__fullbathrooms_pb__c 1
pba__bedrooms_pb__c 2
year_build_text__c 1949
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
ffd_createddate 2022-11-04T22:46:53.000+0000
days_on_market__c 54
dom__c 0
ffd_description_pb Extensively Remodeled Home with Sleek Finishes blocks from Glen Park. Lovingly maintained and designed by an architect for 18 years, carefully considered finishes anchor the sophisticated design in every room. Be wowed as you enter the beautifully designed spaces with sleek, modern finishes and attention to every detail. The stunning open kitchen is in the heart of the home with an open concept to dining and living room/office area with custom built-in desks & storage. Enjoy indoor/outdoor living with sliding glass doors leading to a beautiful walk-out yard, terraced up to a private oasis with southern views. Completing this home is a custom designed bath, beautiful hardwood floors throughout, a 1-car garage w/interior access, storage, laundry, and a work out room. Unbeatable location! It's close to Glen Park BART and Village. With easy access to public transit, tech shuttles and highways, this home is a commuter's dream. This home is as comfortable and convenient as it is beautiful
district__c SF District 4
entry_level__c 0
external_listing__c 1
fireplace_features__c Living Room;Wood Stove
pba__floortype_pb__c Wood
pba__hoafees__c 0
hoa__c No
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Central
ffd_lastmodifieddate 2022-12-03T11:47:05.000+0000
pba__latitude_pb__c 37.7325463
pba__latitude_property__c 37.7325463
laundry_features__c In Garage
listed_date__c 2022-07-01
pba__listing_agent_email__c reneeg@compass.com
pba__listing_agent_firstname__c Renee
pba__listing_agent_lastname__c Gonsalves
listing_agent_mls_id__c 803247
ffd_listingagentname Renee M Gonsalves
listing_agent_number__c 803247
listing_co_agent_number__c 0
listing_co_office_number__c 0
listing_office_mls_id__c COMP
listing_office_name__c Compass
listing_office_number__c 26293
pba__listingprice_pb__c 1349000
pba__listingtype__c Sale
pba__longitude_pb__c -122.4381278
lower_level__c Garage
mls_id__c 422701827
main_level__c Full Bath(s);Bedroom(s);Dining Room;Primary Bedroom
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2022-11-04
original_price__c 1349000
overall_days_on_market__c -81391
parking_access__c Independent
parking_features__c Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c On Site (Single Family Only)
pba__pendingdate__c 2022-11-04
possible_bedrooms__c 0
pba__pricechangedat__c 2022-12-02T16:31:12.000+0000
price_per_square_foot__c 1104.5
pba__propertytype__c Single Family Residence
ListingId a0E8W00000ZMe97UAD
room_type__c Den
sale_date__c 2022-12-02
sale_price__c 1300000
security_features__c Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c 811520
selling_agent_number__c 1051920
selling_co_agent_mls_id__c 807863
selling_co_agent_number__c 1027872
selling_co_office_mls_id__c COMP3
selling_co_office_name__c Compass
selling_co_office_number__c 27342
selling_office_name__c Compass
pba__status__c Closed
pba__totalarea_pb__c 1177
size__c 1177
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Joost
subdist__c Sunnyside
ffd_name 126 Joost Street, San Francisco, CA, 94131
website_property_type__c Single Family Home
pba__yearbuilt_pb__c 1949
pba__postalcode_pb__c 94131
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530541697-1.jpg