meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338135' posts_per_page=4 post_type=property
bool(false)
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, 2824 Scott Street, San Francisco, CA, 94123
ffd_mls_id, 422683889
ffd_salesforce_id, a0E8W00000YZSDgUAP
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2824 Scott Street, San Francisco, CA, 94123
pba__address_pb__c, 2824 Scott Street, San Francisco, CA, 94123
agent_only_remarks__c, Call Lori at (415) 254-7016 for Showings during the holidays.
appliances__c, Free Standing Gas Oven;Free Standing Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 7
pba__bedrooms_pb__c, 6
year_build_text__c, 1908
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Lori S Docherty
pba__contingentdate__c, 2023-08-18
ffd_createddate, 2022-09-12T19:46:43.000+0000
days_on_market__c, 380
dom__c, 334
ffd_description_pb, Classically rebuilt 7,410 sqft view home in Cow Hollow offers 6 bed, 7 bath, 3 half bath, 3+ car garage, and elevator to all levels. Every inch of this residence has been lovingly reimagined with the finest materials, thoughtfully considered finishes, the latest technology, and expansive rooms to maximize City and Bay views. The main entry flows seamlessly into the formal living & dining while the great room with chef's kitchen, family living, & dining stuns with glowing sunrise views of the City. The rare bedroom level offers 4 bedroom suites, including a primary w/ dual baths, & laundry on the same level. Abundant outdoor living spaces include a spacious turfed backyard and terrace, terrace off living and study, balcony off great room, and upper-level lounge w/ 2 expansive terraces w/ views of the City, Alcatraz, and Golden Gate Bridge. Additional amenities include upper-level bed/office, lower guest suite, gym, theatre/media room, laundry with dog wash station, & wine storage.
district__c, SF District 7
driveway_sidewalks__c, Gated
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 3
pba__heatingtype_pb__c, Radiant;Central
interior_features__c, Formal Entry;Skylight(s);Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2023-09-27T10:48:21.000+0000
pba__latitude_pb__c, 37.796023
pba__latitude_property__c, 37.796023
laundry_features__c, Inside Room;Laundry Closet;Upper Floor;Ground Floor;Washer Included;Dryer Included;Sink
listed_date__c, 2022-04-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neal
pba__listing_agent_lastname__c, Ward
listing_agent_mls_id__c, 308772
ffd_listingagentname, Neal A Ward
listing_agent_number__c, 308772
listing_co_agent_mls_id__c, 803331
listing_co_agent_number__c, 803331
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 18450000
pba__listingtype__c, Sale
pba__listing_website__c, https://nealward-wp-offload.s3.us-west-1.amazonaws.com/content/uploads/2022/05/12111405/2824-Scott-Floor-Plans-3.pdf
pba__longitude_pb__c, -122.439983
mls_id__c, 422683889
master_bathroom_features__c, Shower Stall(s);Soaking Tub;Marble
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-09-12
original_price__c, 19000000
overall_days_on_market__c, -81338
parking_access__c, Side by Side
parking_features__c, Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2023-08-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 2209.85
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YZSDgUAP
road_surface_type__c, Paved
roof__c, Slate
sale_date__c, 2023-09-08
sale_price__c, 16375000
security_features__c, Security System Prewired
selling_agent_mls_id__c, 308772
selling_agent_number__c, 308772
selling_co_agent_mls_id__c, 803331
selling_co_agent_number__c, 803331
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 7410
size__c, 7410
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Scott
subdist__c, Cow Hollow
ffd_name, 2824 Scott Street, San Francisco, CA, 94123
view__c, City;City Lights;Garden/Greenbelt;Bay
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530527067-1.jpg