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
(
)
)
_yoast_indexnow_last_ping, 1713567498
ffd_listing_title, 2848 Union Street, San Francisco, CA, 94123
ffd_mls_id, 424001569
ffd_salesforce_id, a0EUd000001Dl0ZMAS
num_of_fireplaces__c, 3
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2848 Union Street, San Francisco, CA, 94123
pba__address_pb__c, 2848 Union Street, San Francisco, CA, 94123
agent_only_remarks__c, Call Janet for info. New roof.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Wine Refrigerator;Built-In Refrigerator;Gas Cook Top;Warming Drawer
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s);Window;Stone
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-21T20:47:05.000+0000
days_on_market__c, 58
dom__c, 58
ffd_description_pb, Coveted location at the eastern edge of the Presidio! The classic shingled facade is a stand-out with its show-stopping bougainvillea. Inside, tremendous natural light, sleek contemporary design, & gallery-style volume are featured throughout this chic, renovated home with a flexible floor plan. There are 4-6BD & 4.5BA. The dramatic, 2 story living room with clerestory windows & Alcatraz/bay views opens to a large view deck with stairs to the garden. The custom, Italian-style kitchen with island seating & top of the line appliances is open to the dining area but may be closed off by hidden folding panels. 2-3BD on the 2nd floor, Spectacular GG/bay/Palace/Alcatraz view primary suite with office/bedroom on the top floor. Guest suite w/new BA on the lower level, & a bonus family rm w/new BA, laundry rm, & storage. Garden by Topher Delaney, 4 decks, and 2-car garage. Exceptional attention to detail in both design and finishes. Must see!
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Den;Primary Bedroom
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant
interior_features__c, Skylight(s);Storage Area(s);Cathedral Ceiling;Wet Bar
2848 Union Street, San Francisco, CA, 94123 - Property Description
Coveted location at the eastern edge of the Presidio! The classic shingled facade is a stand-out with its show-stopping bougainvillea. Inside, tremendous natural light, sleek contemporary design, & gallery-style volume are featured throughout this chic, renovated home with a flexible floor plan. There are 4-6BD & 4.5BA. The dramatic, 2 story living room with clerestory windows & Alcatraz/bay views opens to a large view deck with stairs to the garden. The custom, Italian-style kitchen with island seating & top of the line appliances is open to the dining area but may be closed off by hidden folding panels. 2-3BD on the 2nd floor, Spectacular GG/bay/Palace/Alcatraz view primary suite with office/bedroom on the top floor. Guest suite w/new BA on the lower level, & a bonus family rm w/new BA, laundry rm, & storage. Garden by Topher Delaney, 4 decks, and 2-car garage. Exceptional attention to detail in both design and finishes. Must see!
