Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-19 12:01:01
[post_modified_gmt] => 2024-11-19 20:01:01
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 597 Castro Street, San Francisco, CA, 94114
ffd_mls_id, 423755238
ffd_salesforce_id, a0E8W00000cKRWIUA4
num_of_rooms__c, 14
of_units__c, 4
address2__c, 597 Castro Street, San Francisco, CA, 94114
pba__address_pb__c, 597 Castro Street, San Francisco, CA, 94114
agent_only_remarks__c, Seller has entertained carrying financing, please call Gino or Sandy for terms and details.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sanford Skeie
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-07-11T17:48:24.000+0000
days_on_market__c, 48
dom__c, 31
ffd_description_pb, 597 Castro is a unique mixed-use property conveniently situated in the retail corridor of the historic Castro district. This five-unit gem features a popular Thai restaurant on the ground floor and a stylish barber shop with a separate office space on the top floor. At the rear, you'll find a well-appointed two-bedroom apartment and a cozy studio. The 2-bedroom unit has been more recently renovated with modern finishes and the studio has high ceilings with lots of natural light.The barbershop is expansive with original wainscotting & moldings promoting the space's original historic ambiance. The Thai restaurant has been at this location since the early 2000's and has done substantial amount of tenant improvements that makes it a neighborhood favorite. The area is dotted with local shops, restaurants, and entertainment options, providing residents with a convenient and vibrant lifestyle. Dolores Park & Castro Theatre, two renowned San Francisco gems, are just a short distance away. This is the first time this property has been on the market since the 1970's and is a rare find located in this centrally located high volume retail corridor of San Francisco's most recognized neighborhood!
597 Castro Street, San Francisco, CA, 94114 - Property Description
597 Castro is a unique mixed-use property conveniently situated in the retail corridor of the historic Castro district. This five-unit gem features a popular Thai restaurant on the ground floor and a stylish barber shop with a separate office space on the top floor. At the rear, you'll find a well-appointed two-bedroom apartment and a cozy studio. The 2-bedroom unit has been more recently renovated with modern finishes and the studio has high ceilings with lots of natural light.The barbershop is expansive with original wainscotting & moldings promoting the space's original historic ambiance. The Thai restaurant has been at this location since the early 2000's and has done substantial amount of tenant improvements that makes it a neighborhood favorite. The area is dotted with local shops, restaurants, and entertainment options, providing residents with a convenient and vibrant lifestyle. Dolores Park & Castro Theatre, two renowned San Francisco gems, are just a short distance away. This is the first time this property has been on the market since the 1970's and is a rare find located in this centrally located high volume retail corridor of San Francisco's most recognized neighborhood!
