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] => 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, 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, 257
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, 2023-07-13T17:57:45.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, [email protected]
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, 1800-01-01T00:00:00.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