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, 663 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 423714080
ffd_salesforce_id, a0E8W00000a8GLnUAM
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 663 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 663 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Accepted offer during Coming Soon Period.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Double Oven;Ice Maker
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-30T20:46:27.000+0000
days_on_market__c, 19
dom__c, 0
ffd_description_pb, This crisp clean 4BR/2.5BA Sunnyside home is ready to love. This home features the ideal balance of original charm and open concept living in an upgraded modernized home with designer detail finishes and functionality. Entertaining is a breeze with a formal dining room and a large living room with a decorative fireplace that opens to the Chef-grade kitchen featuring a sit-at-peninsula quartz countertop, five-burner double-oven gas range and stainless-steel appliances. Upstairs bedrooms have hardwood floors and Southern views. The remodeled bathrooms, a full bath and powder room, feature crisp white subway tile trimmed in matte black and designer fixtures. An interior staircase leads to the lower level's two large rooms and a full bathroom (shower only). Rooms and bath are not warranted. Both rooms enjoy direct access to the landscaped yard and patio with built-in redwood seating, turf lawn, flowering shrubs, lemon, peach & fig trees. This home is complete with interior access to the one car garage with additional storage, laundry, wired for EV charger and an additional car parking on driveway. This home has it all! Conveniently located close to BART and HWY 280, Whole Foods, Mt. Davidson, Glen Park & West Portal, this home will not last long!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
This crisp clean 4BR/2.5BA Sunnyside home is ready to love. This home features the ideal balance of original charm and open concept living in an upgraded modernized home with designer detail finishes and functionality. Entertaining is a breeze with a formal dining room and a large living room with a decorative fireplace that opens to the Chef-grade kitchen featuring a sit-at-peninsula quartz countertop, five-burner double-oven gas range and stainless-steel appliances. Upstairs bedrooms have hardwood floors and Southern views. The remodeled bathrooms, a full bath and powder room, feature crisp white subway tile trimmed in matte black and designer fixtures. An interior staircase leads to the lower level's two large rooms and a full bathroom (shower only). Rooms and bath are not warranted. Both rooms enjoy direct access to the landscaped yard and patio with built-in redwood seating, turf lawn, flowering shrubs, lemon, peach & fig trees. This home is complete with interior access to the one car garage with additional storage, laundry, wired for EV charger and an additional car parking on driveway. This home has it all! Conveniently located close to BART and HWY 280, Whole Foods, Mt. Davidson, Glen Park & West Portal, this home will not last long!
