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, 2519 Harrison Street, San Francisco, CA, 94110
ffd_mls_id, 423747667
ffd_salesforce_id, a0E8W00000cJHbZUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2519 Harrison Street, San Francisco, CA, 94110
pba__address_pb__c, 2519 Harrison Street, San Francisco, CA, 94110
agent_only_remarks__c, Email [email protected] for ALL showing requests. No text Messages or Showing Time. www.2519Harrison.com Escrow opened with Kevin Thompson of First American. Buyer to satisfy themselves with sqft measurements and parking. Please use most current SFAR Purchase Contract, allow 24 hours to respond, include fully executed disclosure package, and 1 business day for the initial deposit.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Double Oven;Gas Plumbed
ffd_description_pb, Experience spectacular modern design, supreme comfort, and seamless functionality in this stunning Mission residence. Meticulously renovated into an architectural masterpiece, this home boasts 5 en-suite bedrooms and 5.5 bathrooms. The 3 story layout features a main level with formal living and dining rooms, an amazing chef's kitchen, and a spectacular family room with direct access to the backyard. The upper level features the coveted 3 bedrooms on the same floor, complete with air-conditioning for added comfort. The lower level offers an expansive family/media room with wet bar, along with 2 additional bedroom suites. Outdoor spaces are exquisite, including a magnificent 360 rooftop deck with panoramic views and a contemporary landscaped backyard with artificial turf. Located in the sought-after Mission District, this home offers unrivaled convenience and walkability, with access to upscale restaurants, trendy cafes, stylish boutiques, and beautiful parks, rendering it the ultimate urban sanctuary.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Concrete;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Skylight(s);Storage Area(s);Wet Bar
2519 Harrison Street, San Francisco, CA, 94110 - Property Description
Experience spectacular modern design, supreme comfort, and seamless functionality in this stunning Mission residence. Meticulously renovated into an architectural masterpiece, this home boasts 5 en-suite bedrooms and 5.5 bathrooms. The 3 story layout features a main level with formal living and dining rooms, an amazing chef's kitchen, and a spectacular family room with direct access to the backyard. The upper level features the coveted 3 bedrooms on the same floor, complete with air-conditioning for added comfort. The lower level offers an expansive family/media room with wet bar, along with 2 additional bedroom suites. Outdoor spaces are exquisite, including a magnificent 360 rooftop deck with panoramic views and a contemporary landscaped backyard with artificial turf. Located in the sought-after Mission District, this home offers unrivaled convenience and walkability, with access to upscale restaurants, trendy cafes, stylish boutiques, and beautiful parks, rendering it the ultimate urban sanctuary.
