Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit,The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 16:39:16
[post_modified_gmt] => 2024-11-22 00:39:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[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, 34 Houston Street, San Francisco, CA, 94109
ffd_mls_id, 495414
ffd_salesforce_id, a0E1I00000SP5vaUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 34 Houston Street, San Francisco, CA, 94109
pba__address_pb__c, 34 Houston Street, San Francisco, CA, 94109
agent_only_remarks__c, 3% to buyer's agent! www.34Houston.com. Showing info - Vacant. All agents to send over signed PEAD form from pre-approved buyer only (attached). Agents and buyers must all wash hands, wear gloves and masks and sanitize lockbox, key and front door on the way in and out and must not touch surfaced in the condo. One agent and two buyers at a time. Buyer to verify square footage. 1,460SqFt per MLS, 1375SqFt per Tax record.
appliances__c, Dishwasher;Gas Range;Microwave;Refrigerator;Hood Over Range
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Remodeled
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1992
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julia A Bernardini
pba__contingentdate__c, 2020-04-17
ffd_createddate, 2020-04-08T22:48:45.000+0000
days_on_market__c, 1728
dom__c, 14
ffd_description_pb, In the middle of it all yet tucked away on a quiet/sunny cul-de-sac alley on the border of two quintessential neighborhoods Russian Hill & North Beach is a jewel of a home. House-like condo on 2 levels w/ Deeded Garden. Boutique 2-unit building. No steps to front door! Flexible floor-plan w/ one bedroom up & two bedrooms & bath down. Custom-built closets. Updated kitchen w/ Viking range, Bosch dishwasher & built-in wine cooler. Quiet & private w/ charming outlooks and transom windows. 1-car deeded parking & built-in storage. Nest thermostat & security cameras. Electrolux W/D. Access to Jones St through back stairs. In proximity to Washington Square, Columbus Ave, Trader Joe's & more! Perfect walk score to Downtown/FIDI, Russian Hill/North Beach. Walkable, scenic views, historic architecture, authentic dining/delis & central location define this vibrant neighborhood where everything you want is at your fingertips yet secluded enough to be your private retreat. The best of both worlds!
34 Houston Street, San Francisco, CA, 94109 - Property Description
In the middle of it all yet tucked away on a quiet/sunny cul-de-sac alley on the border of two quintessential neighborhoods Russian Hill & North Beach is a jewel of a home. House-like condo on 2 levels w/ Deeded Garden. Boutique 2-unit building. No steps to front door! Flexible floor-plan w/ one bedroom up & two bedrooms & bath down. Custom-built closets. Updated kitchen w/ Viking range, Bosch dishwasher & built-in wine cooler. Quiet & private w/ charming outlooks and transom windows. 1-car deeded parking & built-in storage. Nest thermostat & security cameras. Electrolux W/D. Access to Jones St through back stairs. In proximity to Washington Square, Columbus Ave, Trader Joe's & more! Perfect walk score to Downtown/FIDI, Russian Hill/North Beach. Walkable, scenic views, historic architecture, authentic dining/delis & central location define this vibrant neighborhood where everything you want is at your fingertips yet secluded enough to be your private retreat. The best of both worlds!
