meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374183' 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] => 2024-08-28 09:06:37
[post_modified_gmt] => 2024-08-28 16:06:37
[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
(
)
)
_yoast_indexnow_last_ping, 1710550613
ffd_listing_title, 3447 Clay Street, San Francisco, CA, 94118
ffd_mls_id, 423927312
ffd_salesforce_id, a0EUd00000166LVMAY
num_of_fireplaces__c, 3
num_of_rooms__c, 10
of_units__c, 0
address2__c, 3447 Clay Street, San Francisco, CA, 94118
pba__address_pb__c, 3447 Clay Street, San Francisco, CA, 94118
agent_only_remarks__c, Offers will be considered by the trustee on February 26, 2024 at 11:00 AM. Please include As-Is Addendum. Per the trustee's instructions, no pre-emptive offers will be presented. Extensive inspection reports are included in the disclosures. Three versions of the floor plans are attached (color, sqft, room sizes), plus a sketch of possible elevator placement from Thayer Hopkins, architect. Sqft is per floor plan tech. Neither Seller nor Broker warrant the home's condition or sqft measurements. Various sqft measurements exist from over the years. Buyers are advised to investigate all aspects to their own satisfaction. www.3447Clay.com
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-12T01:48:10.000+0000
days_on_market__c, 33
dom__c, 15
ffd_description_pb, Trustee, As-Is, sale. Large corner home in Presidio Heights. Gracious four-story floor plan with exceptional principal rooms and natural light. Potential for elevator. Needs infrastructure and cosmetic improvements. The envelope and volume are all there. Bring your dream team! 3447 Clay was built in 1896, has been enjoyed since 1958 by one family, survived two major earthquakes and now offers an outstanding renovation opportunity. The home is located in a walking/hiking/shopping paradise near the Presidio National Park, Presidio Wall Playground and the Sacramento+California street neighborhood amenities district. In addition to the 4 bedrooms and 3 baths, there are multiple additional rooms throughout suitable for offices, media or family rooms. The living room and primary suite are each comprised of two-interconnected rooms facing west. The main level foyer and paneled dining room are architecturally stunning. The kitchen, untouched for many years, opens directly to the large deck with side garden above the 2-car garage.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only;Dining Room;Primary Bedroom
pba__floortype_pb__c, Carpet;Linoleum;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2024-03-16T00:47:06.000+0000
pba__latitude_pb__c, 37.7885465
pba__latitude_property__c, 37.7885465
laundry_features__c, Hookups Only;Inside Area
listed_date__c, 2023-12-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rebecca
pba__listing_agent_lastname__c, Schumacher
listing_agent_mls_id__c, 805929
ffd_listingagentname, Rebecca Schumacher
listing_agent_number__c, 166016017
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, 3900000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.3447Clay.com
pba__longitude_pb__c, -122.4501864
lower_level__c, Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 423927312
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Closet;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-02-11
original_price__c, 3900000
overall_days_on_market__c, -81855
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2024-02-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-15T10:30:42.000+0000
price_per_square_foot__c, 842.11
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000166LVMAY
room_type__c, Office;Laundry;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Media Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-03-15
sale_price__c, 4000000
security_features__c, Video System;Security System Leased
selling_agent_mls_id__c, 197853
selling_agent_number__c, 197853
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 4750
size__c, 4750
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Clay
subdist__c, Presidio Heights
ffd_name, 3447 Clay Street, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530730435-1.jpg