meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='233958' 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
(
)
)
ffd_listing_title, 3351 Clay Street #3, San Francisco, CA, 94118
ffd_mls_id, 487384
ffd_salesforce_id, a0E1I00000EHGd5UAH
address2__c, 3351 Clay Street #3, San Francisco, CA, 94118
pba__address_pb__c, 3351 Clay Street #3, San Francisco, CA, 94118
agent_only_remarks__c, **Major price improvement! Motivated, out-of-state Seller. Additionally, per Sterling Bank, 8/20/19: Their rates have dropped .50%, for ex: 7/1 ARM is at 3.625%. Rates are on par with 30-year fixed rates. 15% down program available on case-by-case basis.** Pre-escrow opened with Steve Salviejo at North American Title Company. For more info visit www.3351Clay.com. For showings, disclosure requests and questions please contact Gina Blancarte at [email protected] or 415-879-8690, or Alexander Lurie at [email protected] or 415-696-0288.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1972
pba__city_pb__c, San Francisco
ffd_createddate, 2019-07-18T10:46:48.000+0000
days_on_market__c, 1462
dom__c, 65
ffd_description_pb, This modern penthouse residence sits on a serene, flat block of Presidio Heights and includes 3 bedrooms, 2 bathrooms, and 2-car side-by-side parking. Bright and airy, the home features luxurious finishes, warm hardwoods & wonderful space for creativity and entertaining guests. Wall-to-wall windows overlooking the neighborhood bathe the open concept living - dining - kitchen rooms with natural light. The chef's kitchen features marble counters, stainless Miele, Bosch, Gaggenau appliances, custom cabinets, wine fridge, & contemporary gas range. The large master bedroom with en-suite bath has plentiful closet space and access to a private deck w/ south-facing city views. A generous 2nd bedroom also accesses the sunny deck. A 3rd bedroom, in-unit W/D, and 3 large storage rooms complete this residence. The home is ideally situated a few blocks to the Presidio's pristine trails, Laurel Village, acclaimed schools, city parks, California & Sacramento Street eateries, bakeries, & boutiques.
district__c, SF District 7
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 294.16
hoa_fee_includes__c, Water,Garbage,Ext Bldg Maintenance,Grounds Maintenance,Homeowners Insurance
hoa__c, Yes
ffd_lastmodifieddate, 2022-03-01T20:27:42.000+0000
pba__latitude_pb__c, 37.7887189
pba__latitude_property__c, 37.7887189
laundry_appliances__c, Washer/Dryer,In Laundry Room
listed_date__c, 2019-07-18
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Lurie
listing_agent_mls_id__c, 810063
listing_agent_number__c, 1044526
listing_co_agent_mls_id__c, 813228
listing_co_agent_number__c, 1060322
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1949000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4480494
pba__lotsize_pb__c, 0
mls_id__c, 487384
master_property__c, a0O1I000004VXY8UAO
monthly_parking_fees__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-07-18
original_price__c, 2095000
overall_days_on_market__c, 1462
parking_access__c, Side-by-Side
parking_features__c, Uncovered,Carport/Pad
parking_type__c, Designated On Site
price_per_square_foot__c, 0
pba__propertytype__c, Tenancy In Common
id, a0E1I00000EHGd5UAH
sale_date__c, 2019-10-22
sale_price__c, 1885000
selling_agent_mls_id__c, 804674
selling_agent_name__c, Ana T. L. Dierkhising
selling_agent_number__c, 166014319
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, 0
size__c, 0
pba__state_pb__c, CA
pba__street_pb__c, Clay
subdist__c, Presidio Heights
ffd_name, 3351 Clay Street #3, San Francisco, CA, 94118
transportation__c, 1 Block
unit_number__c, 3
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1972
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/353542-1.jpg
ListingId, a0E1I00000EHGd5UAH