meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213128' 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, 2961 Broderick Street, San Francisco, CA, 94123
ffd_mls_id, 500624
ffd_salesforce_id, a0E1I00000SxvjbUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2961 Broderick Street, San Francisco, CA, 94123
pba__address_pb__c, 2961 Broderick Street, San Francisco, CA, 94123
agent_only_remarks__c, For disclosures, questions, or showings please contact Neill Bassi ([email protected]) or Tori Andrews ([email protected], 650.269.1357). INSTRUCTIONS FOR SHOWINGS: (1) Need signed CAR PEAD form. (2) Need Pre-Approval Letter or Proof of Funds at (or above) asking price. (3) Need confirmation that client has reviewed the photos, video, and floor plan. (4) All showings are by appointment with Neill or Tori. WWW.2961BRODERICK.COM.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Freezer
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-06T16:46:11.000+0000
days_on_market__c, 1108
dom__c, 17
ffd_description_pb, Resting on the western edge of Cow Hollow, 2961 Broderick St has been thoughtfully renovated throughout. Upon entering the home, one immediately notices the incredible attention to detail including the Crema Europa honed limestone foyer, white oak hardwood floors, floating walls, radiant heating, and a central skylight that floods the home with light. The main level hosts a gracious secondary foyer and entertainment spaces that seamlessly flow through a wall of sliding-glass doors to the spacious deck, providing the ideal setting for indoor and outdoor entertaining. The stunning chef's kitchen boasts white shaker cabinetry, stainless steel appliances, and a central island that overlooks the dining area. All three bedrooms and two bathrooms grace the top floor of the home, including the master suite. The beautifully manicured yard, enclosed patio, laundry area, and attached garage complete the home. Perfectly positioned on a quiet street near the Presidio and Chestnut St.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:27:07.000+0000
pba__latitude_pb__c, 37.79769
pba__latitude_property__c, 37.79769
laundry_features__c, Washer/Dryer Included;In Basement
listed_date__c, 2020-07-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neill
pba__listing_agent_lastname__c, Bassi
listing_agent_mls_id__c, 807780
ffd_listingagentname, Neill Bassi
listing_agent_number__c, 1027326
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 3650000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.2961broderick.com
pba__longitude_pb__c, -122.444355
pba__lotsize_pb__c, 0.04
mls_id__c, 500624
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-07-06
original_price__c, 3650000
overall_days_on_market__c, 178
parking__c, Garage,Interior Access
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Covered Patio
pba__pendingdate__c, 2020-07-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1850
pba__propertytype__c, Single Family Residence
id, a0E1I00000SxvjbUAB
sale_date__c, 2020-08-12
sale_price__c, 3700000
selling_agent_mls_id__c, 301994
selling_agent_name__c, Mary Lou Castellanos
selling_agent_number__c, 301994
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2000
size__c, 2000
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Broderick
subdist__c, Cow Hollow
ffd_name, 2961 Broderick Street, San Francisco, CA, 94123
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/365841-1.jpg
ListingId, a0E1I00000SxvjbUAB