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, 262 Frederick Street #5, San Francisco, CA, 94117
ffd_mls_id, 423721208
ffd_salesforce_id, a0E8W00000bEmOJUA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 5
address2__c, 262 Frederick Street #5, San Francisco, CA, 94117
pba__address_pb__c, 262 Frederick Street #5, San Francisco, CA, 94117
agent_only_remarks__c, Offers as they come, property is owner occupied with a small child, please book showing through Calendly - https://calendly.com/helena7x7/262-frederick-5-showing-schedule Pre-escrow opened up with Kallie Castro at 1st American.
appliances__c, Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Arts & Crafts
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1903
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-27T17:48:22.000+0000
days_on_market__c, 142
dom__c, 12
ffd_description_pb, This stunning 2-bedroom, 2-bath condo boasts a formal dining room, working fireplace, and coveted Cole Valley mid-block location that's serene. With a view deck adjacent to the dining room, you can enjoy stunning views of the Golden Gate Bridge and downtown. The condo also features a renovated kitchen and baths, dual-paned windows, and a shared backyard. Located near all the parks, public transportation, and excellent schools, this pet-friendly building is ideal for anyone seeking turn-key style in the heart of SF. With easy street parking, awesome neighbors, and a recent ten-year renovation with Nordic-style design, this central location makes it easy to commute anywhere in the city.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Maintenance Exterior,Trash,Water
262 Frederick Street #5, San Francisco, CA, 94117 - Property Description
This stunning 2-bedroom, 2-bath condo boasts a formal dining room, working fireplace, and coveted Cole Valley mid-block location that's serene. With a view deck adjacent to the dining room, you can enjoy stunning views of the Golden Gate Bridge and downtown. The condo also features a renovated kitchen and baths, dual-paned windows, and a shared backyard. Located near all the parks, public transportation, and excellent schools, this pet-friendly building is ideal for anyone seeking turn-key style in the heart of SF. With easy street parking, awesome neighbors, and a recent ten-year renovation with Nordic-style design, this central location makes it easy to commute anywhere in the city.
