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
(
)
)
_yoast_indexnow_last_ping, 1729076015
ffd_listing_title, 678 Capp Street, San Francisco, CA, 94110
ffd_mls_id, 424064630
ffd_salesforce_id, a0EUd0000035ULZMA2
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 678 Capp Street, San Francisco, CA, 94110
pba__address_pb__c, 678 Capp Street, San Francisco, CA, 94110
agent_only_remarks__c, Offer date TBD after first weekend opens. PLease submit your offer on 7-page SFAR Purchase agreement with pre-approval and/or proof of funds. Disclosures are ready on disclosures.io please email. Easy to show text/call Stephanie House 619-964-4709 [email protected] , Mike Stack at 415-580-9095 [email protected] or Jean-Paul at 415-279-0997 [email protected] thank you!
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Electric Cook Top;Ice Maker;Built-In Refrigerator;Built-In Electric Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike R Keane-Stack
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-11T21:47:56.000+0000
days_on_market__c, 35
dom__c, 35
ffd_description_pb, Brand new construction, luxury single family home like residence, spanning 3 levels of living space + an expansive roof terrace. It's the newest release at Mission Luxe, a collection of luxury condominium homes in this newly created boutique 4-unit community in the heart of the vibrant Mission District. The main level boasts a Great Room, perfect for large-scale dining and entertaining, with a well-appointed kitchen featuring top-of-the-line appliances a stylish peninsula, and gorgeous designer finishes. The main living level also boasts a powder room and laundry with side-by-side appliances. The top level features the spacious ensuite primary bedroom plus a 3rd bedroom and lux guest bathroom. Ascend the stairs from the third level to the expansive rooftop terrace, offering outdoor dining and living areas and sweeping panoramic views. The entry offers a bedroom connecting to a sunny patio + a full bathroom. Additional features include under floor radiant heat, built-in ceiling speakers, security, and smart-home capabilities. This is a vibrant Mission District location close to a plethora of award winning restaurants, theaters, shops, cafes, a weekly farmers' market, nighttime entertainment, parks, Bart, Muni + easy access to area freeways.
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Gas,Heat,Insurance on Structure,Sewer,Trash,Water
pba__hoafees__c, 415
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 674-676-678-678A Capp Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Hot Water;Radiant Floor;MultiZone
678 Capp Street, San Francisco, CA, 94110 - Property Description
Brand new construction, luxury single family home like residence, spanning 3 levels of living space + an expansive roof terrace. It's the newest release at Mission Luxe, a collection of luxury condominium homes in this newly created boutique 4-unit community in the heart of the vibrant Mission District. The main level boasts a Great Room, perfect for large-scale dining and entertaining, with a well-appointed kitchen featuring top-of-the-line appliances a stylish peninsula, and gorgeous designer finishes. The main living level also boasts a powder room and laundry with side-by-side appliances. The top level features the spacious ensuite primary bedroom plus a 3rd bedroom and lux guest bathroom. Ascend the stairs from the third level to the expansive rooftop terrace, offering outdoor dining and living areas and sweeping panoramic views. The entry offers a bedroom connecting to a sunny patio + a full bathroom. Additional features include under floor radiant heat, built-in ceiling speakers, security, and smart-home capabilities. This is a vibrant Mission District location close to a plethora of award winning restaurants, theaters, shops, cafes, a weekly farmers' market, nighttime entertainment, parks, Bart, Muni + easy access to area freeways.
