Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:58:51
[post_modified_gmt] => 2024-04-09 17:58:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[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, 1648 Union Street #A, San Francisco, CA, 94123
ffd_mls_id, 422704021
ffd_salesforce_id, a0E8W00000ZLxdHUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 6
address2__c, 1648 Union Street #A, San Francisco, CA, 94123
pba__address_pb__c, 1648 Union Street #A, San Francisco, CA, 94123
agent_only_remarks__c, Photos do not do the views justice! Quiet end of Union & unit is in rear of building. Incredibly quiet!
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Refrigerator;Built-In Electric Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1984
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Window Unit(s)
ffd_createddate, 2022-10-27T02:46:37.000+0000
days_on_market__c, 266
dom__c, 46
ffd_description_pb, When it's all about the view! This spectacular, top floor condo boasts Expansive Bay & Golden Gate Bridge views from 2 private decks! The perfect backdrop for Fleet Week & July 4th gatherings, this special property is situated in the heart of Cow Hollow offering an unbeatable location that includes easy access to incredible restaurants, nightlife, shopping and parks! SUPER QUIET, 2-level sanctuary, located at the rear of a well-maintained elevator building, features a renovated kitchen w/custom cabinetry, glass tile back splash and top-of-the-line appliances including Sub-Zero, Miele cooktop & Thermador oven. The Living room boasts a wood burning fireplace, hardwood floors & a walkout balcony with stunning GGB views! The quaint dining area completes this level. On the upper level, you find a spacious bedroom w/large closet, plantation shutters & seating area plus an updated full bath. The corner office nook leads directly to a walk-out entertaining deck with stunning 180 degree views! Add'l features include skylights, recessed lighting, 1 car garage prkg, storage, shared laundry & garden. Ideal as a pied-a-terre or for 1st time home buyers looking to enjoy San Francisco lifestyle to the fullest!
1648 Union Street #A, San Francisco, CA, 94123 - Property Description
When it's all about the view! This spectacular, top floor condo boasts Expansive Bay & Golden Gate Bridge views from 2 private decks! The perfect backdrop for Fleet Week & July 4th gatherings, this special property is situated in the heart of Cow Hollow offering an unbeatable location that includes easy access to incredible restaurants, nightlife, shopping and parks! SUPER QUIET, 2-level sanctuary, located at the rear of a well-maintained elevator building, features a renovated kitchen w/custom cabinetry, glass tile back splash and top-of-the-line appliances including Sub-Zero, Miele cooktop & Thermador oven. The Living room boasts a wood burning fireplace, hardwood floors & a walkout balcony with stunning GGB views! The quaint dining area completes this level. On the upper level, you find a spacious bedroom w/large closet, plantation shutters & seating area plus an updated full bath. The corner office nook leads directly to a walk-out entertaining deck with stunning 180 degree views! Add'l features include skylights, recessed lighting, 1 car garage prkg, storage, shared laundry & garden. Ideal as a pied-a-terre or for 1st time home buyers looking to enjoy San Francisco lifestyle to the fullest!
