meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330603' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15723
[post_author] => 4
[post_date] => 2018-11-02 19:54:42
[post_date_gmt] => 2018-11-02 19:54:42
[post_content] => Where palatial estates actually are palatial estates. Le Petit Trianon, to name just one. Notable homes by notable San Francisco architects like Bernard Maybeck, Ernest Coxhead, Julia Morgan, William F. Knowles, and Willis Polk. Walk north to the Presidio & Golden Gate National Recreation Area. Shop a few blocks south in Laurel Village. Life is good.
[post_title] => Presidio Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => presidio-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:42
[post_modified_gmt] => 2018-11-02 19:54:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15723
[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, 3555 Clay Street, San Francisco, CA, 94118
ffd_mls_id, 423736592
ffd_salesforce_id, a0E8W00000bbytiUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 3555 Clay Street, San Francisco, CA, 94118
pba__address_pb__c, 3555 Clay Street, San Francisco, CA, 94118
agent_only_remarks__c, To show, please call/text/email David Werboff at (415) 317-0802 [email protected] - Pre-escrow is open with Kelley Kish at First American Title. Seller nor listing agents have verified any square footage amounts, buyer to verify. 3555Clay.com
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator
bath_features__c, Sauna
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Caroline Kahn Werboff
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-28T17:48:16.000+0000
days_on_market__c, 34
dom__c, 33
ffd_description_pb, Sitting on a picturesque, flat tree-lined block in prestigious Presidio Heights, this 4-story residence combines storybook charm w/ contemporary upgrades & amenities. It offers 5 bedrooms, 2 offices, 4.5 baths & multiple flex use areas. The grand foyer, enhanced by a stately main staircase, is conveniently located at street level. Richly hued refinished hardwood floors span the main level which includes grand scale formal living & dining rooms, a powder room, modern kitchen w/ top-tier appliances, wet bar & breakfast area, family room & a stunning sunny south-facing yard defined by lush colorful landscaping, multiple tiled sitting areas & access directly from the dining room & kitchen/family room. The level above includes the principal suite w/ walk-in closet, 2 additional large bedrooms w/ custom built-ins, another full bath & a large terrace w/ treetop & Sutro Tower views. 4 more private rooms, one with a windowed sitting alcove, an office with casement roof windows & a shared marble & tile bath are tucked amid the eaves on the uppermost level. The lower level has a skylit family/media room w/ Venetian plastered walls, a temperature-controlled wine cellar, a spa-like sauna, bath w/ steam shower & direct access to the yard. 2 car prkg (including 1 in driveway) complete the home.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-06-01T01:48:53.000+0000
pba__latitude_pb__c, 37.788262
pba__latitude_property__c, 37.788262
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2023-02-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Werboff
listing_agent_mls_id__c, 811140
ffd_listingagentname, David E Werboff
listing_agent_number__c, 1050071
listing_co_agent_mls_id__c, 076073
listing_co_agent_number__c, 76073
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 6800000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/821443145
pba__longitude_pb__c, -122.451342
lower_level__c, Family Room,Garage
mls_id__c, 423736592
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-04-28
open_house_end__c, 2023-06-04T16:00:00.000+0000
open_house_start__c, 2023-06-04T14:00:00.000+0000
original_price__c, 6800000
overall_days_on_market__c, -81566
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1548.97
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbytiUAA
room_type__c, Office;Bonus Room;Library;Wine Cellar;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 4390
size__c, 4390
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Clay
subdist__c, Presidio Heights
ffd_name, 3555 Clay Street, San Francisco, CA, 94118
view__c, City;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530610563-1.jpg