meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213811' 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-11-22 11:37:36
[post_modified_gmt] => 2024-11-22 19:37:36
[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, 638 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 503101
ffd_salesforce_id, a0E1I00000S11c0UAB
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 638 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 638 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Call for appointments to show and complete PEAD using link https://app.glide.com/pp/3NFozW4uhbrWWh0jffe4K We will follow all covid guidelines so please review pictures and media. Buyers agents, please bring clients with masks and hand sanitizer, gloves are at the home and will be required as owner occupied (note, new gloves will be required before entry, Thank you for understanding) Listing agent Matthew Goulden is also the owner. SF on appraisal is 1155 sf, tax records 1125 sf. Matterport is estimated Interior dimensions at 1392 which includes unwarranted lower level finished area.
appliances__c, Gas Water Heater;Gas Range;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Double Oven;Freezer;Self/Cont Clean Oven
bath_features__c, Tub w/Shower Over;Shower Stall(s);Low-Flow Toilet(s);Jetted Tub;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1927
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Courtney Behan
pba__contingentdate__c, 1800-01-01
cooling__c, Ceiling Fan(s)
ffd_createddate, 2020-08-12T05:48:33.000+0000
days_on_market__c, 1607
dom__c, 10
ffd_description_pb, Opportunity Knocks. Beautifully updated 2 bed, 2 bath, office, plus a large bonus room (currently used as a bedroom) home in Sunnyside. Your eat-in kitchen has been updated with cherrywood cabinets, stainless appliances & granite counters. Step through the office to the expansive deck with natural gas BBQ, built-in redwood benches and planters making your alfresco dining/entertaining area an oasis with a view of the tranquil garden & your elevated fire pit area. The primary bedroom enjoys the garden view & has a walk-in closet. The main level bathroom was expanded and includes a large spa tub, double sinks, and transom windows for extra natural light. Your living room has new wood dual pane windows with views across the valley to the pillbox houses, the Excelsior, and to the left, you can see the cranes at Hunters point and the bay. Downstairs has a large bonus room plus a laundry/wet room with exterior access and storage. Easy access to 101 & 280 freeways, Glen Park BART & Muni lines.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Tile;Vinyl;Wood;Stone
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:30:11.000+0000
pba__latitude_pb__c, 37.7324971
pba__latitude_property__c, 37.7324971
laundry_features__c, Inside Room;Hookups Only;In Basement
listed_date__c, 2020-07-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Matthew
pba__listing_agent_lastname__c, Goulden CHS
listing_agent_mls_id__c, 981562
ffd_listingagentname, Matthew J Goulden CHS
listing_agent_number__c, 981562
listing_co_agent_mls_id__c, 810156
listing_co_agent_number__c, 1044938
listing_co_office_mls_id__c, CGL
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28240
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=tsu2c8uwKYN&mls=1
pba__longitude_pb__c, -122.4497994
pba__lotsize_pb__c, 0.06
lower_level__c, Full Bath(s)
mls_id__c, 503101
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-07
original_price__c, 1395000
overall_days_on_market__c, 115
parking_access__c, Independent
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-08-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1038.07
pba__propertytype__c, Single Family Residence
id, a0E1I00000S11c0UAB
roof__c, Bitumen
room_type__c, Office;Bonus Room
sale_date__c, 2020-09-10
sale_price__c, 1445000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 804837
selling_agent_name__c, John L. LePage
selling_agent_number__c, 166014530
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1392
size__c, 1392
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Sunnyside
ffd_name, 638 Joost Avenue, San Francisco, CA, 94127
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/367689-1.jpg
ListingId, a0E1I00000S11c0UAB
_yoast_indexnow_last_ping, 1735656364