meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375161' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70654
[post_author] => 4
[post_date] => 2018-11-30 20:30:27
[post_date_gmt] => 2018-11-30 20:30:27
[post_content] => No joke, Robin Williams once called the neighborhood home. Sea Cliff is synonymous with stately estates on larger lots. Land's End Park is at your doorstep. Panoramic vistas of the Pacific Ocean, Marin Headlands, and the Golden Gate Bridge.
[post_title] => Sea Cliff
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sea-cliff
[to_ping] =>
[pinged] =>
[post_modified] => 2024-06-04 10:42:16
[post_modified_gmt] => 2024-06-04 17:42:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70654
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1712109539
ffd_listing_title, 20 Sea View Terrace, San Francisco, CA, 94121
ffd_mls_id, 424011556
ffd_salesforce_id, a0EUd000001Jrb9MAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 20 Sea View Terrace, San Francisco, CA, 94121
pba__address_pb__c, 20 Sea View Terrace, San Francisco, CA, 94121
agent_only_remarks__c, *We have multiple square footage measurements. Buyer is advised to investigate to their own satisfaction. Graphic Artist (2023): 3,610 sqft, Tax Records: 3,665 sqft, and MLS (2015): 3,046 sqft. **2 car parking in the garage and 3rd car in uncovered space adjacent to the garage.
architectural_style__c, Spanish
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1929
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Wall Unit(s)
ffd_createddate, 2024-03-01T19:46:52.000+0000
days_on_market__c, 32
dom__c, 11
ffd_description_pb, On a quiet street in coveted Sea Cliff, this four-level Spanish-inspired home was thoroughly remodeled in 2017 to offer inviting living spaces with enviable views of the Golden Gate Bridge, the Pacific Ocean, and the Marin Headlands. The open, airy living room features views of the Golden Gate Bridge, built-in bookshelves, and a balcony overlooking the garden below. The kitchen includes a built-in breakfast nook with a stunning view, a La Cornue range, and ample counter and cabinet space. The classically detailed dining room is appointed with a wall of built-ins and access to a wet bar. Four of the home's bedrooms are secluded on the level above. The principal suite enjoys dramatic views, a windowed walk-in closet, and an ensuite bath. One of the restful guest bedrooms features an ensuite bath; the remaining two share a hall bath with a glass-walled shower. On the uppermost level is a pentroom with a full panorama that sweeps from the Pacific Ocean past the Golden Gate to Sutro Tower. The space is accompanied by a wet bar and a bath. A private guest suite and home office are sequestered on the lower level, which opens to the backyard, an oasis with a tone-tiled patio, a turfed lawn, and mature trees. The property also offers a two-car garage.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-03T01:47:29.000+0000
pba__latitude_pb__c, 37.68493342
pba__latitude_property__c, 37.68493342
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-03-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neill
pba__listing_agent_lastname__c, Bassi
listing_agent_mls_id__c, 807780
ffd_listingagentname, Neill Bassi
listing_agent_number__c, 1027326
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 6100000
pba__listingtype__c, Sale
pba__listing_website__c, http://20seaview.com
pba__longitude_pb__c, -122.49351223
mls_id__c, 424011556
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-03-01
original_price__c, 6100000
overall_days_on_market__c, -81874
parking_access__c, Independent
parking_features__c, Detached,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2024-03-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-02T12:06:08.000+0000
price_per_square_foot__c, 1883.66
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001Jrb9MAC
sale_date__c, 2024-04-02
sale_price__c, 6800000
selling_agent_mls_id__c, 806326
selling_agent_number__c, 166016753
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, 3610
size__c, 3610
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Sea View
subdist__c, Sea Cliff
ffd_name, 20 Sea View Terrace, San Francisco, CA, 94121
view__c, Ocean;Panoramic;City Lights;Golden Gate Bridge;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530738606-1.jpg