meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375120' 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-06-04 10:33:45
[post_modified_gmt] => 2024-06-04 17:33:45
[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, 1712055465
ffd_listing_title, 3474 Clay Street, San Francisco, CA, 94118
ffd_mls_id, 424009451
ffd_salesforce_id, a0EUd000001DHX7MAO
num_of_fireplaces__c, 4
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3474 Clay Street, San Francisco, CA, 94118
pba__address_pb__c, 3474 Clay Street, San Francisco, CA, 94118
agent_only_remarks__c, Offers will be reviewed on Friday, March 1st at 1pm. Please see www.3475clay.com. Shown by appointment only. Call or text Dan Fitzpatrick for showings (415.519.5020). 24 hour advance notice preferred. Disclosure package available at: https://app.disclosures.io/link/3474-Clay-Street-wh9dhkr3
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Oven
architectural_style__c, Traditional
bath_features__c, Marble
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-02-20T23:46:47.000+0000
days_on_market__c, 42
dom__c, 13
ffd_description_pb, Perched atop Presidio Heights, 3474 Clay represents S.F. living at its finest, with timeless architecture, exquisite upgrades and sweeping views out to the Golden Gate Bridge. Spanning four floors, this distinctive shingle-style home has been lovingly restored, maintaining much of its original charm. The traditional floor plan is an entertainer's dream, with a grand formal living room which flows into a spacious dining room, perfect for hosting large dinner parties and family gatherings. The second floor features a light-light-filled primary suite with fireplace, seating area and en-suite bathroom with marble-clad shower. Two more bedrooms with views of the Presidio share a full bathroom down the hall. Ascending to the top floor you'll be met with jaw-dropping views out to the G.G. Bridge from the picture window in the bonus room that serves as a home office and additional living area. The top floor also includes a full bathroom, fourth bedroom and oversized cedar closet. The lower level can be accessed directly from the 1-car garage, and features the laundry room and an additional bedroom and bathroom. The garden offers a true sanctuary from the city, featuring a brick patio, manicured landscaping and deck off the dining room. Come experience Presidio Heights living finest!
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Brick
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-04-02T10:48:16.000+0000
pba__latitude_pb__c, 37.7888953
pba__latitude_property__c, 37.7888953
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-01-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dan
pba__listing_agent_lastname__c, Fitzpatrick
listing_agent_mls_id__c, 808275
ffd_listingagentname, Dan T Fitzpatrick
listing_agent_number__c, 1032727
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REEXPERTS
listing_office_name__c, Real Estate Experts
listing_office_number__c, 28684
pba__listingprice_pb__c, 5800000
pba__listingtype__c, Sale
pba__listing_website__c, http://my.matterport.com/show/?m=rxW1Z9Dxos6
pba__longitude_pb__c, -122.45007
mls_id__c, 424009451
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-20
original_price__c, 5800000
overall_days_on_market__c, -81864
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-01T14:41:39.000+0000
price_per_square_foot__c, 1621.62
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001DHX7MAO
road_surface_type__c, Asphalt
room_type__c, Laundry;Living Room;Dining Room;Primary Bathroom
sale_date__c, 2024-04-01
sale_price__c, 6000000
selling_agent_mls_id__c, 215754
selling_agent_number__c, 215754
selling_co_agent_mls_id__c, 308732
selling_co_agent_number__c, 308732
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, 3700
size__c, 3700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clay
subdist__c, Presidio Heights
ffd_name, 3474 Clay Street, San Francisco, CA, 94118
view__c, Bay;Golden Gate Bridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530733040-1.jpg