meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='229674' 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-08-28 09:06:37
[post_modified_gmt] => 2024-08-28 16:06: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, 3993 Washington Street, San Francisco, CA, 94118
ffd_mls_id, 490725
ffd_salesforce_id, a0E1I00000H1N0qUAF
num_of_fireplaces__c, 3
num_of_rooms__c, 0
of_units__c, 4
address2__c, 3993 Washington Street, San Francisco, CA, 94118
pba__address_pb__c, 3993 Washington Street, San Francisco, CA, 94118
agent_only_remarks__c, BACK ON THE MLS in Sept - please do not reach out to Seller - STILL SHOWING in August while temporarily off market. This residence was a down to the studs remodel approx. 18 years ago and the current owners invested considerably in upgrades. Unit #3997 in the same building sold last May for $3.3MM. Please visit PresidioHeights3993.com for additional information and 3D tour.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Low-Flow Toilet(s);Skylight/Solar Tube;Radiant Heat;Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1905
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2019-09-28T01:47:12.000+0000
days_on_market__c, 1525
dom__c, 0
ffd_description_pb, Situated on a beautiful tree-lined street, this top floor condo embraces its handsome Edwardian architectural heritage while offering a stylish interior infused with warmth and modern day luxuries. Meticulously renovated, the open floor plan is anchored by a spacious dining room with dramatic light fixture and a living room w/separate sitting area and balcony. The family room features expansive windows and fireplace. The bedrooms, including master suite, are located in their own wing. In the well-appointed kitchen, you will find beautiful Vadara quartz counters, exquisite custom backsplash, and quality appliances (Viking, Miele, Sub-Zero). Both full baths boast limestone finishes and the guest powder room whimsical Ingo Mauer lighting and custom mural walls. Private 750+ bottle wine cellar, in-unit W/D, skylights, inlaid wood floors, ~9 1/2 foot ceilings, Sonos sound, boutique building w/shared courtyard. Super location close to Presidio National Park and renowned restaurants & shops.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Family Room;Dining Room
pba__floor__c, 0
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 500
hoa_fee_includes__c, Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 500
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Central
ffd_lastmodifieddate, 2023-11-30T11:47:42.000+0000
pba__latitude_pb__c, 37.788285
pba__latitude_property__c, 37.788285
laundry_appliances__c, Washer/Dryer
laundry_features__c, Washer/Dryer Included
listed_date__c, 2019-09-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sara
pba__listing_agent_lastname__c, Khan
listing_agent_mls_id__c, 803453
ffd_listingagentname, Sara B Khan
listing_agent_number__c, 803453
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 3095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.459025
pba__lotsize_pb__c, 0
mls_id__c, 490725
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom
master_property__c, a0OUd000000ihAxMAI
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-09-27
original_price__c, 3095000
overall_days_on_market__c, -80257
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2019-09-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1428.57
pba__propertytype__c, Condominium
id, a0E1I00000H1N0qUAF
room_type__c, Wine Cellar
sale_date__c, 2019-09-27
sale_price__c, 3000000
selling_agent_mls_id__c, 981678
selling_agent_name__c, Justin Goldberg
selling_agent_number__c, 1017282
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, 2100
size__c, 2100
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Washington
subdist__c, Presidio Heights
ffd_name, 3993 Washington Street, San Francisco, CA, 94118
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/356560-1.jpg
ListingId, a0E1I00000H1N0qUAF
_yoast_indexnow_last_ping, 1701346339