meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235279' 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-04-15 08:18:31
[post_modified_gmt] => 2024-04-15 15:18:31
[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
(
)
)
ffd_listing_title, 6 Scenic Way, San Francisco, CA, 94121
ffd_mls_id, 422633399
ffd_salesforce_id, a0E8W00000Vt18YUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 6 Scenic Way, San Francisco, CA, 94121
pba__address_pb__c, 6 Scenic Way, San Francisco, CA, 94121
agent_only_remarks__c, Sellers request that all visitors wear a face covering during showings. Shown by appointment only, to schedule contact Laurie Nierenberg at 415-710-6900 or Bruce Lyon at 415-305-3637. Property website: www.6Scenic.com
appliances__c, Hood Over Range;Free Standing Refrigerator;Built-In Electric Range;Built-In Electric Oven
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over;Double Sinks
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1964
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bruce Lyon
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-02-26T20:46:35.000+0000
days_on_market__c, 508
dom__c, 18
ffd_description_pb, Golden opportunity in Sea Cliff to purchase this dramatic, unobstructed Golden Gate Bridge view residence, circa 1964, on a 40' wide lot (per SF tax records) on one of Sea Cliff's most sought-after blocks. Still owned by the same family who built the home, the next owner can bring their own personal vision to redesign this outstanding property. ENTRY LEVEL: eat-in kitchen, formal dining room and great room with fireplace enjoying some views, bedroom, bath, and laundry room. UPPER LEVEL: Breathtaking GG Bridge and ocean view living room and primary en-suite bedroom with large picture windows, a unique center atrium/solarium, office, two additional bedrooms and bath. LOWER LEVEL: Once called the 'rec room' - perfect for media room, additional guest quarters, home gym, etc. with door leading out to the oversized yard with patio. Extra storage areas. Two-car side by side garage has interior access. Wonderful neighborhood by the beach!
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Carpet;Linoleum;Wood;Parquet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-04-15T10:47:48.000+0000
pba__latitude_pb__c, 37.7885154
pba__latitude_property__c, 37.7885154
laundry_features__c, Inside Room;Washer Included;Dryer Included;Cabinets;Sink;Chute
listed_date__c, 2022-02-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Laurie
pba__listing_agent_lastname__c, Nierenberg
listing_agent_mls_id__c, 069620
ffd_listingagentname, Laurie Nierenberg
listing_agent_number__c, 69620
listing_co_agent_mls_id__c, 802384
listing_co_agent_number__c, 802384
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 4880000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/682221017
pba__longitude_pb__c, -122.4856038
lower_level__c, Retreat
mls_id__c, 422633399
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Garage;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-02-26
original_price__c, 4880000
overall_days_on_market__c, -81140
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-03-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-14T15:44:18.000+0000
price_per_square_foot__c, 1189.9
pba__propertytype__c, Single Family Residence
id, a0E8W00000Vt18YUAR
roof__c, Composition;Shingle
room_type__c, Storage;Office;Kitchen;Atrium;Living Room;Master Bathroom;Dining Room;Master Bedroom;Great Room;Media Room
sale_date__c, 2022-04-14
sale_price__c, 4950000
security_features__c, Smoke Detector;Carbon Mon Detector;Security System Owned
selling_agent_mls_id__c, 361136
selling_agent_number__c, 361136
selling_co_agent_mls_id__c, 814864
selling_co_agent_number__c, 1068736
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 4160
size__c, 4160
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Scenic
subdist__c, Sea Cliff
ffd_name, 6 Scenic Way, San Francisco, CA, 94121
view__c, Ocean;Water;Golden Gate Bridge;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1964
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530409336-1.jpg
ListingId, a0E8W00000Vt18YUAR