meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326150' 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, 3410 Jackson Street, San Francisco, CA, 94118
ffd_mls_id, 423719913
ffd_salesforce_id, a0E8W00000bETnnUAG
num_of_fireplaces__c, 1
num_of_rooms__c, 15
of_units__c, 0
address2__c, 3410 Jackson Street, San Francisco, CA, 94118
pba__address_pb__c, 3410 Jackson Street, San Francisco, CA, 94118
agent_only_remarks__c, Property Website: https://www.3410jacksonst.com/mls/92332106
appliances__c, Dishwasher;Disposal;Hood Over Range;Compactor;Double Oven;Built-In Refrigerator;Gas Cook Top
bath_features__c, Tub w/Shower Over;Marble
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-21T20:48:27.000+0000
days_on_market__c, 21
dom__c, 20
ffd_description_pb, More photos coming. Ready to show! Exquisitely designed and meticulously renovated view home on one of Presidio Height's best blocks. Boasting full Golden Gate Bridge, Bay and Presidio views, this residence has an elevator to all 4 floors. 5 bedrooms and 5.5 bathrooms, with incredible entertaining and gathering spaces including 2 family rooms, formal living and dining rooms, a lounge with bar, and a fabulous roofdeck. The beautiful open kitchen/family room has a walk-out deck to admire the Bridge and Bay, overlooking the large, level yard. On the second level are 4 bedrooms and 3 bathrooms, including a stunning primary suite with full Golden Gate views. On the top level are a spacious view family room, an office, gym, full bath, and a sprawling, south-facing roofdeck. The lower level features a guest room, full bath, and family room with access to the garden. 2 car garage. All the boxes are checked: gorgeous renovation, fabulous outdoor space, killer views, and ideal location.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-03-13T22:48:04.000+0000
pba__latitude_pb__c, 37.790626
pba__latitude_property__c, 37.790626
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-02-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nina
pba__listing_agent_lastname__c, Hatvany
listing_agent_mls_id__c, 372883
ffd_listingagentname, Nina Hatvany
listing_agent_number__c, 372883
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 23500000
pba__listingtype__c, Sale
pba__listing_website__c, https://teamhatvany.com/
pba__longitude_pb__c, -122.451191
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423719913
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub;Double Sinks;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-02-21
original_price__c, 23500000
overall_days_on_market__c, -81500
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
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, 3291.32
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bETnnUAG
room_type__c, Storage;Office;Kitchen;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, 7140
size__c, 7140
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Jackson
subdist__c, Presidio Heights
ffd_name, 3410 Jackson Street, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530582391-1.jpg