meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337140' 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] => 2023-06-23 07:03:09
[post_modified_gmt] => 2023-06-23 14:03:09
[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, 3284 Jackson Street, San Francisco, CA, 94118
ffd_mls_id, 423755237
ffd_salesforce_id, a0E8W00000cpwuIUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 2
address2__c, 3284 Jackson Street, San Francisco, CA, 94118
pba__address_pb__c, 3284 Jackson Street, San Francisco, CA, 94118
agent_only_remarks__c, Tenant occupied but easy to show - Property will be delivered vacant (tenant has a new place) Book your tour on Calendly here > https://calendly.com/3284jackson/tour. Showing must be confirmed in separate email/text by our agent and Pls follow showing instructions you receive via email. Call/text Mia 415.728.2596 | [email protected] for more info. Offers to be on SFAR 7 page contract. Escrow opened with Mijael Schmidt at First American Title. Pls follow offer instructions on the disclosure.io > https://app.disclosures.io/link/3284-Jackson-Street-mlc4a821 Parking options: https://docs.google.com/document/d/1Txfxay6A4PSgPK22KO7a30aT_Ci0026WlqWvD2B7YXw/edit?usp=sharing
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tile;Double Sinks
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-08-28T21:03:39.000+0000
days_on_market__c, 23
dom__c, 23
ffd_description_pb, Exquisite Presidio Heights 2-level, house-like condo in elegant 2-unit building. Completely rebuilt in 2018 w meticulous attention to detail & modern luxury features. With a separate entrance, this private residence boasts 4beds, 3baths, 2powder rooms w abundant natural light, expansive private deck & breathtaking views of Golden Gate Bridge frm primary suite. Upper level showcases an open layout w nine-foot ceilings. Custom fireplace in living room opens to dining space, breakfast area & spacious home office. Gourmet kitchen is a true masterpiece, complete w Thermador appliances, gas range & bar seating. Luxurious primary view suite w en suite bathroom, sitting area & walk-in closet. Inviting entertaining space downstairs includes family room w wet bar overlooking lush garden, expansive private view deck w Lynx BBQ, brick wall guest suite with walk-in closet, mirrored wall fitness room & laundry room. Additional highlights include 5-zone radiant heat, Lutron lighting system, built-in surround sound, Pella windows, and a large storage room. Located on one of the best tree lined blocks of Presidio Heights, just blocks away from the amazing trails, scenery, and upscale amenities of Presidio & Sacramento St. Pre-paid 3 year parking nearby & all furniture can be included in the sale
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Family Room
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Water
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 2
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central
ffd_lastmodifieddate, 2023-09-19T12:45:56.000+0000
pba__latitude_pb__c, 37.790919
pba__latitude_property__c, 37.790919
laundry_features__c, Laundry Closet
listed_date__c, 2023-07-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Miyuki Mia
pba__listing_agent_lastname__c, Takami
listing_agent_mls_id__c, 806485
ffd_listingagentname, Miyuki Mia Takami
listing_agent_number__c, 166017050
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 3675000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.448891
lower_level__c, Bedroom(s),Family Room,Partial Bath(s)
mls_id__c, 423755237
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile;Walk-In Closet;Soaking Tub;Radiant Heat
master_property__c, a0O1I000004VYE8UAO
monthly_parking_fees__c, 175
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-27
original_price__c, 3770000
overall_days_on_market__c, -81687
parking_access__c, Independent
parking_features__c, Other
parking_type__c, Other
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-18T23:00:58.000+0000
price_per_square_foot__c, 1055.73
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000cpwuIUAQ
room_type__c, Storage;Office;Laundry;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
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, 3481
size__c, 3481
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Jackson
subdist__c, Presidio Heights
ffd_name, 3284 Jackson Street, San Francisco, CA, 94118
view__c, Garden/Greenbelt;San Francisco;Golden Gate Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530650658-1.jpg