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
(
)
)
_yoast_indexnow_last_ping, 1735680747
ffd_listing_title, 1754 Waller 1756 Street, San Francisco, CA, 94117
ffd_mls_id, 424001727
ffd_salesforce_id, a0EUd000000rqyAMAQ
num_of_rooms__c, 8
of_units__c, 2
address2__c, 1754 Waller 1756 Street, San Francisco, CA, 94117
pba__address_pb__c, 1754 Waller 1756 Street, San Francisco, CA, 94117
agent_only_remarks__c, Clean eviction history and qualifies for fast track conversion! Disclosures https://app.disclosures.io/link/1754-1756-Waller-Street-xicxydpq
appliances__c, Dishwasher;Gas Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-01-19T01:52:27.000+0000
days_on_market__c, 348
dom__c, 11
ffd_description_pb, Fully vacant two unit property that exemplifies San Francisco's rich culture and lifestyle! Located right next to Golden Gate Park, bordering Cole Valley and Haight-Ashbury, it's situated in one of the most desirable areas in the City. The classic Victorian architecture, complemented by a tasteful and elegant remodel, adds a unique charm and character. The stunning blend of modern and classic finishes enhances its appeal. The top unit, spread across two floors, is impressive with its flexibility of two or three bedrooms and two full bathrooms. Thermador appliances in the kitchen, along with ample storage, make it ideal for those who love cooking. The private deck accessible from the kitchen offers an outdoor space for relaxation and entertainment. The soaring 10.5' ceilings create an airy, light-filled atmosphere throughout. The lower unit, with its one bedroom and one and a half bathrooms, also boasts a gorgeous chef's kitchen and soaring 10.5' ceilings, mirroring the luxurious feel of the building. This property is perfect for any type of buyer, whether you're looking for an investment property, an owner that wants extra income, or multi-generational families looking for their own compound, this property has it all. This duplex qualifies for fast track condo conversion.
1754 Waller 1756 Street, San Francisco, CA, 94117 - Property Description
Fully vacant two unit property that exemplifies San Francisco's rich culture and lifestyle! Located right next to Golden Gate Park, bordering Cole Valley and Haight-Ashbury, it's situated in one of the most desirable areas in the City. The classic Victorian architecture, complemented by a tasteful and elegant remodel, adds a unique charm and character. The stunning blend of modern and classic finishes enhances its appeal. The top unit, spread across two floors, is impressive with its flexibility of two or three bedrooms and two full bathrooms. Thermador appliances in the kitchen, along with ample storage, make it ideal for those who love cooking. The private deck accessible from the kitchen offers an outdoor space for relaxation and entertainment. The soaring 10.5' ceilings create an airy, light-filled atmosphere throughout. The lower unit, with its one bedroom and one and a half bathrooms, also boasts a gorgeous chef's kitchen and soaring 10.5' ceilings, mirroring the luxurious feel of the building. This property is perfect for any type of buyer, whether you're looking for an investment property, an owner that wants extra income, or multi-generational families looking for their own compound, this property has it all. This duplex qualifies for fast track condo conversion.
