meta_query='key:subdist__c;value:Presidio Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='227455' 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, 3990 Washington Street, San Francisco, CA, 94118
ffd_mls_id, 481387
ffd_salesforce_id, a0E1I000006brbgUAA
address2__c, 3990 Washington Street, San Francisco, CA, 94118
pba__address_pb__c, 3990 Washington Street, San Francisco, CA, 94118
agent_only_remarks__c, Visit 3990Washington.com for video and more info - >10,000 sq ft of gorgeous home = incredible value and the price dropped by ONE MILLION dollars. This home is now priced to sell and there is no question the seller is looking for offers. Detached on ALL 4 sides, on a double lot, this spectacular home is truly one of a kind with its architectural detailing, incredible floor plan and all it has to offer with finishes and its overall integrity. Accommodates large families, live-in help, guests and is a very comfortable home while being a showcase for entertaining. The amenities include built-in sound system, Marvin double pane windows, 4 working fireplaces and the list goes on .... Do not miss this opportunity.
pba__fullbathrooms_pb__c, 6
pba__bedrooms_pb__c, 6
year_build_text__c, 1909
pba__city_pb__c, San Francisco
ffd_createddate, 2019-03-02T01:46:23.000+0000
days_on_market__c, 1601
dom__c, 188
ffd_description_pb, $$$ ONE MILLION Dollars Price DROP - >10,000 sq ft of gorgeous living space. This extraordinary, stately, fully detached home has been beautifully & meticulously renovated & restored w/ the highest quality of construction, all new systems & seismic upgrades. Owners attention to detail was unparalleled. Includes 6+ bedrooms, 6 full & 3 half bathrooms, grand foyer, formal living & dining rooms, large family room w/ fireplace & wet bar & an entire TOP floor dedicated and designed for ENTERTAINMENT & features a media center w/big screen TV, game room, billiard room & sitting area, ALL perfectly suited for entertaining friends or just enjoying it day-to-day for relaxing and family fun. Multiple home offices, State-of-the-Art eat-in kitchen, 4-5 car garage w/built-in workshop, xtra storage & all updated systems. Detached on ALL 4 sides, 100' of the home fronts on Washington St w/Southern exposure providing an abundance of light everywhere in the home.
district__c, SF District 7
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T19:52:12.000+0000
pba__latitude_pb__c, 37.7886056
pba__latitude_property__c, 37.7886056
listed_date__c, 2019-03-01
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Bellings
listing_agent_mls_id__c, 215754
listing_agent_number__c, 215754
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 8950000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/332755559
pba__longitude_pb__c, -122.4590863
pba__lotsize_pb__c, 0.1
mls_id__c, 481387
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2019-03-01
original_price__c, 11500000
overall_days_on_market__c, 1601
parking__c, Attached,Garage,Auto Door,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 910
pba__propertytype__c, Single-Family Home
id, a0E1I000006brbgUAA
sale_date__c, 2019-09-13
sale_price__c, 9100000
selling_agent_mls_id__c, 215760
selling_agent_name__c, Barbara J. Callan
selling_agent_number__c, 215760
selling_co_agent_mls_id__c, 804668
selling_co_agent_name__c, Robert R. Callan Jr.
selling_co_agent_number__c, 166014312
selling_co_office_mls_id__c, MCGU
selling_co_office_name__c, McGuire Real Estate
selling_co_office_number__c, 1497
selling_office_name__c, McGuire Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 10000
size__c, 10000
pba__state_pb__c, CA
pba__street_pb__c, Washington
subdist__c, Presidio Heights
ffd_name, 3990 Washington Street, San Francisco, CA, 94118
transportation__c, 2 Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/347398-1.jpg
ListingId, a0E1I000006brbgUAA