Array
(
[ID] => 15734
[post_author] => 4
[post_date] => 2018-11-02 19:54:59
[post_date_gmt] => 2018-11-02 19:54:59
[post_content] => Jimi Hendrix, Janis Joplin, The Grateful Dead. 1968. Victorians, Edwardians, street punks, and skater kids. Everyone has an idea of what the Haight should be. Come discover what it actually is for yourself.
[post_title] => Haight Ashbury
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => haight-ashbury
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-22 10:15:44
[post_modified_gmt] => 2024-11-22 18:15:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15734
[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, 404 Ashbury Street #1, San Francisco, CA, 94117
ffd_mls_id, 423912951
ffd_salesforce_id, a0E8W00000dTw73UAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 7
address2__c, 404 Ashbury Street #1, San Francisco, CA, 94117
pba__address_pb__c, 404 Ashbury Street #1, San Francisco, CA, 94117
agent_only_remarks__c, 30-year fixed fractional loans are now available! For more information and showing requests, please contact Mark Brown 415-359-5576.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 2023-10-07
ffd_createddate, 2023-09-29T10:47:40.000+0000
days_on_market__c, 74
dom__c, 53
ffd_description_pb, Newly remodeled one-bed home in the fabulous Haight-Ashbury neighborhood! Step out of the front door of this trophy building and enjoy the eclectic shops and hip entertainment on Haight Street. Go for a stroll or exercise on the picturesque Panhandle of Golden Gate Park, opposite your new home. A gorgeous, spacious kitchen has plentiful shaker-style cabinets, gleaming quartz counters, and LG stainless steel appliances. The open concept kitchen/living area suits modern living and is enhanced by the tall ceilings and new double pane windows which fill the home with sunlight. The large bathroom is equipped with a deep soaking tub, modern tile, and shower, plus space for a stackable washer/dryer. New features include recessed LED lighting, beautiful wide-plank oak floors, and an efficient gas furnace to keep you cozy. Upgraded for the 21st century, this historic building is equipped with a fire sprinkler system and an upgraded foundation. With a Walk Score of 97, this is the perfect City home!
404 Ashbury Street #1, San Francisco, CA, 94117 - Property Description
Newly remodeled one-bed home in the fabulous Haight-Ashbury neighborhood! Step out of the front door of this trophy building and enjoy the eclectic shops and hip entertainment on Haight Street. Go for a stroll or exercise on the picturesque Panhandle of Golden Gate Park, opposite your new home. A gorgeous, spacious kitchen has plentiful shaker-style cabinets, gleaming quartz counters, and LG stainless steel appliances. The open concept kitchen/living area suits modern living and is enhanced by the tall ceilings and new double pane windows which fill the home with sunlight. The large bathroom is equipped with a deep soaking tub, modern tile, and shower, plus space for a stackable washer/dryer. New features include recessed LED lighting, beautiful wide-plank oak floors, and an efficient gas furnace to keep you cozy. Upgraded for the 21st century, this historic building is equipped with a fire sprinkler system and an upgraded foundation. With a Walk Score of 97, this is the perfect City home!
