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-11-15 13:36:25
[post_modified_gmt] => 2024-11-15 21:36:25
[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, 2856 Scott Street #3, San Francisco, CA, 94123
ffd_mls_id, 421530621
ffd_salesforce_id, a0E1I00000Tx5JFUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 6
address2__c, 2856 Scott Street #3, San Francisco, CA, 94123
pba__address_pb__c, 2856 Scott Street #3, San Francisco, CA, 94123
agent_only_remarks__c, Property is staged as a 1 bedroom but many owners in the building utilize the DR as the 2nd bedroom which has a window & closet.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-23T12:44:20.000+0000
days_on_market__c, 1380
dom__c, 10
ffd_description_pb, Rarely available, large scale condo in A+ Cow Hollow location w/stunning Bay views! Move-in ready, this spectacular home has an intelligent floor plan that is staged as a 1 bedroom but can easily be used as a 2 bedroom. Classic Edwardian bldg with one of the most spectacular common roof decks in the city - vistas from GGBridge to the Salesforce Tower! The deck includes lounge chairs & built-in seating ideal for outdoor gatherings. As you enter the unit, the long hallway leads to the spacious view LR w/gas frplc, ample seating & room for a desk or two. Large Formal DR includes a deep closet. Remodeled Kitchen w/SS appliances, gas range & stone countertops! Enjoy views from the large bdrm with custom walk-in closet that leads to the remodeled bath w/glass surround shower stall & gorgeous stone detail. The long hallway offers another option for an office nook. 1 car pkg + strg. An ideal home for buyers seeking more space or as a pied-a-terre in one of the city's most desirable locations!
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Wood;Stone
hoa_fee_includes__c, Common Areas,Insurance on Structure,Management,Roof,Sewer,Trash,Water
2856 Scott Street #3, San Francisco, CA, 94123 - Property Description
Rarely available, large scale condo in A+ Cow Hollow location w/stunning Bay views! Move-in ready, this spectacular home has an intelligent floor plan that is staged as a 1 bedroom but can easily be used as a 2 bedroom. Classic Edwardian bldg with one of the most spectacular common roof decks in the city - vistas from GGBridge to the Salesforce Tower! The deck includes lounge chairs & built-in seating ideal for outdoor gatherings. As you enter the unit, the long hallway leads to the spacious view LR w/gas frplc, ample seating & room for a desk or two. Large Formal DR includes a deep closet. Remodeled Kitchen w/SS appliances, gas range & stone countertops! Enjoy views from the large bdrm with custom walk-in closet that leads to the remodeled bath w/glass surround shower stall & gorgeous stone detail. The long hallway offers another option for an office nook. 1 car pkg + strg. An ideal home for buyers seeking more space or as a pied-a-terre in one of the city's most desirable locations!
