meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219404' 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-03-07 14:15:37
[post_modified_gmt] => 2024-03-07 22:15: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
(
)
)
ffd_listing_title, 3973 Clay Street, San Francisco, CA, 94118
ffd_mls_id, 421561646
ffd_salesforce_id, a0E1I00000UU7MeUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 3973 Clay Street, San Francisco, CA, 94118
pba__address_pb__c, 3973 Clay Street, San Francisco, CA, 94118
agent_only_remarks__c, Contact Joel Goodrich or Anne Laury for showings; Offer date Wed, June 23, 2pm; no preemptive offers
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1911
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Joel Goodrich
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-10T22:48:33.000+0000
days_on_market__c, 769
dom__c, 14
ffd_description_pb, Looking for a sophisticated and spacious home with a deeded backyard in prime Presidio Heights? This is it! A condo that lives like a single-family home with its own separate entrance. Explore two levels that overlook a southern-exposed backyard. Edwardian architectural details, one car garage and ample storage space. Once inside, a large foyer welcomes with extra room for seating before entering the formal living and dining rooms. The open floor plan is accentuated with box beam ceilings and large windows framed with lead-glass panels. The eat-in kitchen extends to a breakfast nook with access to the lower level and south-facing garden. The primary bedroom suite overlooking the private backyard also includes a separate sunroom that makes a peaceful office space. The sun-filled second bedroom overlooks the backyard garden as well. The third bedroom is filled with natural light from two windows. The lower-level family room provides direct access to the deeded yard.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Insurance,Water
pba__hoafees__c, 130
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3973-3975 Clay Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:54:43.000+0000
pba__latitude_pb__c, 37.78733
pba__latitude_property__c, 37.78733
listed_date__c, 2021-06-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anne
pba__listing_agent_lastname__c, Laury
listing_agent_mls_id__c, 810542
ffd_listingagentname, Anne Laury
listing_agent_number__c, 1046806
listing_co_agent_mls_id__c, 364929
listing_co_agent_number__c, 364929
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2295000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.cbhometour.com/3973-Clay-Street-San-Francisco-CA-94118/index.html
pba__longitude_pb__c, -122.458658
mls_id__c, 421561646
master_property__c, a0O1I000001ViTGUA0
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-06-10
original_price__c, 2295000
overall_days_on_market__c, 183
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-06-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1025.21
pba__propertytype__c, Condominium
id, a0E1I00000UU7MeUAL
sale_date__c, 2021-07-22
sale_price__c, 2440000
selling_agent_mls_id__c, 804302
selling_agent_number__c, 166013814
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2380
size__c, 2380
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Clay
subdist__c, Presidio Heights
ffd_name, 3973 Clay Street, San Francisco, CA, 94118
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1911
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530260068-1.jpg
ListingId, a0E1I00000UU7MeUAL