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-10-31 12:57:08
[post_modified_gmt] => 2024-10-31 19:57:08
[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, 288 29th Avenue, San Francisco, CA, 94121
ffd_mls_id, 421607057
ffd_salesforce_id, a0E8W00000V1QP9UAN
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 288 29th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 288 29th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, This is an as-is, trust sale and will not require court confirmation. Offers to be submitted on SFAR purchase contract with proof of financing or proof of funds for all cash offers. Escrow has been opened with Liz Paglinawan at First American Title. PLEASE ALLOW 48 HOURS TO RESPOND TO OFFERS. ATTORNEY HAS TO CONTACT HEIRS AND SOME LIVE OUTSIDE THE COUNTRY.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Built-In Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1920
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-25T19:50:36.000+0000
days_on_market__c, 1163
dom__c, 40
ffd_description_pb, Situated just inside the gates of Sea Cliff, this classic, fully detached, light-filled, 4BR/3.5BA SFH offers approx 2985sf of living space w/ rear alley access to the garage leaving the streets and sidewalks free of driveways creating a delightful charm & community feel to this wonderful neighborhood. Main level has LR, FDR open to brkfst nook, well-appt kit feat Sub-Zero, Viking & Bosch, office/guest BR w/ensuite BA, plus powder rm. Upper level has large ensuite primary BR, 2 spac guest BR that open to a large sunroom w/ensuite BA. Lower level has fun family rm w/built-in bar and benches - so much potential; plus interior access to the garage. Amazing amount of space and so much potential to customize including adding a rear gate to enclose the driveway and rear patio/yard. What a remarkable opportunity!!
288 29th Avenue, San Francisco, CA, 94121 - Property Description
Situated just inside the gates of Sea Cliff, this classic, fully detached, light-filled, 4BR/3.5BA SFH offers approx 2985sf of living space w/ rear alley access to the garage leaving the streets and sidewalks free of driveways creating a delightful charm & community feel to this wonderful neighborhood. Main level has LR, FDR open to brkfst nook, well-appt kit feat Sub-Zero, Viking & Bosch, office/guest BR w/ensuite BA, plus powder rm. Upper level has large ensuite primary BR, 2 spac guest BR that open to a large sunroom w/ensuite BA. Lower level has fun family rm w/built-in bar and benches - so much potential; plus interior access to the garage. Amazing amount of space and so much potential to customize including adding a rear gate to enclose the driveway and rear patio/yard. What a remarkable opportunity!!
