meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219859' 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, 3249 Jackson Street, San Francisco, CA, 94118
ffd_mls_id, 421571721
ffd_salesforce_id, a0E1I00000UUrqCUAT
num_of_fireplaces__c, 3
num_of_rooms__c, 12
of_units__c, 0
address2__c, 3249 Jackson Street, San Francisco, CA, 94118
pba__address_pb__c, 3249 Jackson Street, San Francisco, CA, 94118
agent_only_remarks__c, Photos are from previous listing. Home is currently unstaged. Please text Gretchen (415) 793-7606 for easy showings by appointment. Full disclosure package available upon request.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Ice Maker;Built-In Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 1898
pba__city_pb__c, San Francisco
listing_co_agent_name__c, JOHN S Adlam
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-07-09T10:54:50.000+0000
days_on_market__c, 741
dom__c, 10
ffd_description_pb, Beautifully renovated family home in prestigious Presidio Heights. Incredible scale and volume, this home spans three levels, offering 6BR, 4.5BA in addition to an in-law, media room, large deck & yard + 2 car garage parking. The main level has a gracious entry, generous formal dining + living rooms, reading room, office/ den, powder room, and eat - in'' kitchen open to the family room. Upper level offers a wonderful family floor plan including a fabulous master suite with a walk-in closet, two additional bedrooms with peek-a-boo views of the golden gate bridge and remodeled bathroom. The lower level features a superb entertaining space for extended family or guests; open media room with two additional bedrooms & bathroom, laundry room & mud rooms plus an in-law/aupair suite with full kitchenette . The lush backyard offers a large deck off the main level great for outdoor entertaining & bbqing with additional patio / garden area below.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Other
pba__floortype_pb__c, Carpet;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:56:47.000+0000
pba__latitude_pb__c, 37.7904785
pba__latitude_property__c, 37.7904785
laundry_features__c, Inside Room;Dryer Included
listed_date__c, 2021-07-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gretchen
pba__listing_agent_lastname__c, Levin
listing_agent_mls_id__c, 808598
ffd_listingagentname, Gretchen Levin
listing_agent_number__c, 1037175
listing_co_agent_mls_id__c, A015129
listing_co_agent_number__c, 981089361
listing_co_office_mls_id__c, ADBR02
listing_co_office_name__c, Golden Gate Sotheby's International Realty
listing_co_office_number__c, 981028800
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 6800000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4483235
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 421571721
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Double Sinks;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-07-08
original_price__c, 6800000
overall_days_on_market__c, 176
parking_access__c, Side by Side
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-07-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1208.46
pba__propertytype__c, Single Family Residence
id, a0E1I00000UUrqCUAT
roof__c, Composition
room_type__c, Storage;Office;In Law Apartment;Living Room;Master Bathroom;Guest Quarters;Dining Room;Family Room
sale_date__c, 2021-07-27
sale_price__c, 6800000
selling_agent_mls_id__c, 902000
selling_agent_number__c, 1027476
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 5627
size__c, 5627
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Jackson
subdist__c, Presidio Heights
ffd_name, 3249 Jackson Street, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1898
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530279308-1.jpg
ListingId, a0E1I00000UUrqCUAT