meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425994' 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-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
(
)
)
_yoast_indexnow_last_ping, 1743211379
ffd_listing_title, 150 32nd Avenue, San Francisco, CA, 94121
ffd_mls_id, 425021502
ffd_salesforce_id, a0EUd000004ZUlnMAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
pba__address_pb__c, 150 32nd Avenue, San Francisco, CA, 94121
address2__c, 150 32nd Avenue, San Francisco, CA, 94121
agent_only_remarks__c, For showings, questions, or disclosures please contact Neill Bassi([email protected]). *We have multiple square footage measurements. Buyer is advised to investigate to their own satisfaction. Graphic Artist: 4,405 sqft, Tax Records: 4,408 sqft, MLS (2021): 4,671 sqft, and MLS (2021): 4,861 sqft. **Plans for remodel are approved and permits have been issued.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 6
year_build_text__c, 1914
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-21T18:48:08.000+0000
days_on_market__c, 7
dom__c, 7
ffd_description_pb, This fully detached four-level Sea Cliff home boasts six bedrooms, three full and two half baths, and approximately 4,405 sqft. Built in 1914, this home retains classic details and offers approved plans for a full remodel, providing a rare opportunity to create your dream home. Resting on an extra-wide lot, the home has incredible scale throughout and great natural light. The main level includes a spacious kitchen, large formal living and dining rooms, and a sunny family room with adjacent powder room. The bedroom level features four generously sized bedrooms and two and one half baths, providing ample space and comfort. The primary suite enjoys incredible views of the Presidio and downtown San Francisco. On the upper level, a light-filled family room with panoramic views of the Golden Gate Bridge, downtown, and Sutro Tower is complemented by an additional bedroom, offering a stunning retreat. The garden level includes a guest bedroom, full bath, and flexible space that connects directly to the garden, plus interior access to the garage. Ideally located near China Beach, Lands End, and the dining scene along Clement and California Streets.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
ffd_lastmodifieddate, 2025-03-29T00:46:49.000+0000
pba__latitude_pb__c, 37.7858964
pba__latitude_property__c, 37.7858964
listed_date__c, 2025-03-21
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, 3975000
pba__listingtype__c, Sale
pba__listing_website__c, http://32ndseacliff.com
pba__longitude_pb__c, -122.4928255
mls_id__c, 425021502
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2025-03-21
open_house_end__c, 2025-03-29T11:00:00.000+0000
open_house_start__c, 2025-03-29T09:00:00.000+0000
original_price__c, 3975000
overall_days_on_market__c, -82259
parking_access__c, Independent
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 902.38
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004ZUlnMAG
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 4405
size__c, 4405
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, 32nd
subdist__c, Sea Cliff
ffd_name, 150 32nd Avenue, San Francisco, CA, 94121
view__c, Ocean;Panoramic;Downtown;San Francisco;Golden Gate Bridge;Hills;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1914
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530965383-1.jpg