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, 454 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 421536957
ffd_salesforce_id, a0E1I00000Ty8CRUAZ
num_of_fireplaces__c, 3
num_of_rooms__c, 7
of_units__c, 0
address2__c, 454 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 454 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offers, if any, due Friday, April 16th by 10am. Please copy my team member, Hollis at [email protected] on all offers. Please send PEAD and book your showing here: https://calendly.com/marylou-castellanos/454-joost-showing . Disclosures are available on disclosures.io - https://app.disclosures.io/link/454-Joost-Avenue-lc28ghwx
appliances__c, Dishwasher;Microwave;Free Standing Gas Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 2006
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-11T02:15:07.000+0000
days_on_market__c, 831
dom__c, 7
ffd_description_pb, Standing tall on a serene tree lined street, this contemporary 4BR/3.5BA, 2 level view home has it all. Featuring a reverse floorplan with all 4 bedrooms on one level, the primary BR has a gas fireplace framed by double closets and city light views. The bath boasts an oversized soaking tub with steam shower and double vanity. A 2nd suite is located towards the middle of this level, while two additional BRs with direct access to rear patio, and a 3rd bath complete the level. Take the elevator (or stairway) up to the main living level, the star of the home, with sweeping city light views plus dramatic vaulted ceilings, skylights, and an open floor plan. The open family room has a fireplace, a spacious dining area, and direct access to the rear deck and yard, extending the space to enjoy quality indoor/outdoor entertaining. A chef's kitchen with large center island opens to the living/dining area, and features marble counters and top of the line appliances. 2+ car pkg.
454 Joost Avenue, San Francisco, CA, 94127 - Property Description
Standing tall on a serene tree lined street, this contemporary 4BR/3.5BA, 2 level view home has it all. Featuring a reverse floorplan with all 4 bedrooms on one level, the primary BR has a gas fireplace framed by double closets and city light views. The bath boasts an oversized soaking tub with steam shower and double vanity. A 2nd suite is located towards the middle of this level, while two additional BRs with direct access to rear patio, and a 3rd bath complete the level. Take the elevator (or stairway) up to the main living level, the star of the home, with sweeping city light views plus dramatic vaulted ceilings, skylights, and an open floor plan. The open family room has a fireplace, a spacious dining area, and direct access to the rear deck and yard, extending the space to enjoy quality indoor/outdoor entertaining. A chef's kitchen with large center island opens to the living/dining area, and features marble counters and top of the line appliances. 2+ car pkg.
