Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 1248 Utah Street, San Francisco, CA, 94110
ffd_mls_id, 421536979
ffd_salesforce_id, a0E1I00000Ty8CQUAZ
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1248 Utah Street, San Francisco, CA, 94110
pba__address_pb__c, 1248 Utah Street, San Francisco, CA, 94110
agent_only_remarks__c, Please book all showings through calendly - https://calendly.com/helena7x7/1248-utah-one-on-one-showings
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Double Sinks
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1915
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-04-11T02:15:07.000+0000
days_on_market__c, 831
dom__c, 14
ffd_description_pb, An ultra-modern SFH in Inner Mission. Rebuilt in 2015, this 4bd/3.5ba home impresses with a generous floorplan, high-tech design, and indoor/outdoor living. An innovative moving glass wall opens the main level's entertaining areas to a walkout patio and lush bamboo garden below. Perfect for hosting, it allows guests to mingle outside, cozy up in front of the fireplace, or linger at the breakfast bar as you cook in the chef's kitchen (ft. wide island, marble counters, upscale S/S appliances.) When the sun sets, enjoy vivid skyline views incl. the Sutro Tower. 3 bdrms are on the upper level - a rare find in the city! The main bedroom boasts a gas fireplace, double closets, and luxury en suite bath with deep soaking tub and double stall shower. The lower level can serve as an in-law unit with an en suite bedroom, media room, W/D, and direct access to yard and garage. Glass sliders open to the backyard where you'll find dreamy landscaping, BBQ and fire pit. 1-car garage. Amazing storage.
1248 Utah Street, San Francisco, CA, 94110 - Property Description
An ultra-modern SFH in Inner Mission. Rebuilt in 2015, this 4bd/3.5ba home impresses with a generous floorplan, high-tech design, and indoor/outdoor living. An innovative moving glass wall opens the main level's entertaining areas to a walkout patio and lush bamboo garden below. Perfect for hosting, it allows guests to mingle outside, cozy up in front of the fireplace, or linger at the breakfast bar as you cook in the chef's kitchen (ft. wide island, marble counters, upscale S/S appliances.) When the sun sets, enjoy vivid skyline views incl. the Sutro Tower. 3 bdrms are on the upper level - a rare find in the city! The main bedroom boasts a gas fireplace, double closets, and luxury en suite bath with deep soaking tub and double stall shower. The lower level can serve as an in-law unit with an en suite bedroom, media room, W/D, and direct access to yard and garage. Glass sliders open to the backyard where you'll find dreamy landscaping, BBQ and fire pit. 1-car garage. Amazing storage.
