meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212539' 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, 722 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 499197
ffd_salesforce_id, a0E1I00000SK7zRUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 722 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 722 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, *Contact listing agent for an in person appointment. Please preview 722Joost.com prior to any showing request. Buyers are encouraged to have their own inspections. Presale escrow opened with Paula Siegel, Fidelity National Title. Offers are to be written on the SFAR purchase contract; if you don't have access to one, I will provide one to you. Live showings possible with the following procedure: 1) schedule and attend a virtual tour; acknowledge viewing the property virtually; 2) provide a pre-approval letter if buyers are getting a loan, or proof of funds for cash buyers showing capacity to purchase at list price; 3) Buyer signed copy of CAR PEAD V form; 4) Attendance at the showing by the buyers' agent; 5) Sign off and follow social distancing guidelines and property entry rules. 6) All signed documents to be delivered to the listing agent at least 6 hours prior to scheduled appointment. Thank you for helping comply with the SIP ordinance and keeping us all safe. Disclosure package to be reviewed, approved and submitted with an offer. Seller reserves the right to accept, counter or reject any/all offers.
appliances__c, Gas Range;Microwave;Refrigerator
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1905
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Steven C Gerry
pba__contingentdate__c, 2020-07-02
ffd_createddate, 2020-06-04T21:46:27.000+0000
days_on_market__c, 1140
dom__c, 43
ffd_description_pb, New Price-Cozy compound on one of the best blocks in Sunnyside offers an urban sanctuary within San Francisco. An abundance of natural light floods the living room through the bay window with stunning south facing views towards the San Bruno Mountain, formal dining room with period details, kitchen features a breakfast nook with patio access. The main level offers privacy with two rear bedrooms & a full bath. The lower level bonus space offers great flexibility as a guest suite or home office with a laundry alcove. Enjoy BBQs on the private patio in the rear yard. Create a secret garden with dedicated garden sheds and an out door shower. Mature palm trees & garden beds flank the entrance to this unique home. A one car garage plus a tandem parking space in the driveway complete the package. Nestled in the charming Sunnyside Neighborhood nr. Glen Park Village & West Portal shops, restaurants, & cafes. Location offers easy access to transportation;BART stations, tech shuttle & hwy 280.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Tile;Simulated Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:24:11.000+0000
pba__latitude_pb__c, 37.732547
pba__latitude_property__c, 37.732547
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-06-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lauren
pba__listing_agent_lastname__c, O'Brien
listing_agent_mls_id__c, 400152
ffd_listingagentname, Lauren M O'Brien
listing_agent_number__c, 979968042
listing_co_agent_mls_id__c, 808795
listing_co_agent_number__c, 1037611
listing_co_office_mls_id__c, CGL01
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28273
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.asteroommls.com/pviewer?token=gAbYCESw_EWOs96L_zUlUg
pba__longitude_pb__c, -122.451734
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Partial Bath(s)
mls_id__c, 499197
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-06-04
original_price__c, 1198000
overall_days_on_market__c, 214
parking__c, Detached,Garage,Auto Door
parking_features__c, Detached,Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Patio(s)
pba__pendingdate__c, 2020-07-17
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
id, a0E1I00000SK7zRUAT
roof__c, Composition
sale_date__c, 2020-07-30
sale_price__c, 1015000
security_features__c, Security Gate
selling_agent_mls_id__c, MLSL5075891
selling_agent_number__c, 981158800
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Brokerage Technologies
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Sunnyside
ffd_name, 722 Joost Avenue, San Francisco, CA, 94127
transportation__c, 1 Block
view__c, Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364121-1.jpg
ListingId, a0E1I00000SK7zRUAT
