Array
(
[ID] => 70672
[post_author] => 4
[post_date] => 2018-11-30 20:30:47
[post_date_gmt] => 2018-11-30 20:30:47
[post_content] => Not quite as glamorous as the Financial District, not quite as tough as the Tenderloin. Midrise mixed-use buildings dominate in the district that includes tourist-heavy destinations and world-class shopping district Union Square.
[post_title] => Downtown
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => downtown
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-19 12:01:47
[post_modified_gmt] => 2024-11-19 20:01:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70672
[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, 631 Ofarrell Street #1705, San Francisco, CA, 94109
ffd_mls_id, 495038
ffd_salesforce_id, a0E1I00000Se4DYUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 186
address2__c, 631 Ofarrell Street #1705, San Francisco, CA, 94109
pba__address_pb__c, 631 Ofarrell Street #1705, San Francisco, CA, 94109
agent_only_remarks__c, Please view video tour at www.HamiltonViewCondo.com or attached. SIP rules in place -- virtual tour -- please call LA. Corner view home at Hamilton, perfect pied-a-terre! Call/text for appts or disclosures: 415-531-1301. Amenities: 24-hour concierge, newer gym, garden patio/fountain, 16th Fl roof deck. HOA dues include ALL utilities (except internet). Pet restriction is 2 dogs/cats, 30 lb limit each. Leased parking avail. in nearby garages for ~$300+/mo. In-bldg fee parking has waiting list. Pre-escrow w/ Fidelity Title, Michael Gaffney, 415-345-5012.
appliances__c, Dishwasher;Electric Range;Microwave;Refrigerator;Hood Over Range
architectural_style__c, Art Deco
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1930
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike Tekulsky
pba__contingentdate__c, 2020-05-01
ffd_createddate, 2020-04-17T17:46:37.000+0000
days_on_market__c, 1768
dom__c, 42
ffd_description_pb, Sophisticated panoramic view corner home at full-service Hamilton bldg. One of the largest studio condos with sparkling views to Nob Hill, Transamerica Tower, full western vistas. You'll marvel at the 2 walls of large windows that draw light throughout the day. Flexible space allows for bedroom area, living-dining room with plush carpeting, charming kitchen with spacious island, new and vintage light fixtures & ample storage space. Bathroom has stylish tilework, newly refinished tub. The Hamilton's captivating lobby, award-winning chandeliers, grand piano, fireplace are treasured by residents. Amenities: 24-hr concierge, newly renovated fitness ctr, roof patio, community lounge w/ fountain patio, onsite mgr. HOA incl all utilities, heat. Discover this fabulous condo in a distinctive building walkable to Union Square, Civic Center, downtown.
631 Ofarrell Street #1705, San Francisco, CA, 94109 - Property Description
Sophisticated panoramic view corner home at full-service Hamilton bldg. One of the largest studio condos with sparkling views to Nob Hill, Transamerica Tower, full western vistas. You'll marvel at the 2 walls of large windows that draw light throughout the day. Flexible space allows for bedroom area, living-dining room with plush carpeting, charming kitchen with spacious island, new and vintage light fixtures & ample storage space. Bathroom has stylish tilework, newly refinished tub. The Hamilton's captivating lobby, award-winning chandeliers, grand piano, fireplace are treasured by residents. Amenities: 24-hr concierge, newly renovated fitness ctr, roof patio, community lounge w/ fountain patio, onsite mgr. HOA incl all utilities, heat. Discover this fabulous condo in a distinctive building walkable to Union Square, Civic Center, downtown.
