meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221878' 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] => 2023-10-31 10:40:22
[post_modified_gmt] => 2023-10-31 17:40:22
[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, 2750 Lake Street, San Francisco, CA, 94121
ffd_mls_id, 421609504
ffd_salesforce_id, a0E8W00000V1jKlUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 2750 Lake Street, San Francisco, CA, 94121
pba__address_pb__c, 2750 Lake Street, San Francisco, CA, 94121
agent_only_remarks__c, Owner occupied. Do not disturb owners. Home not ready to show until 11/13/2021 & by appointment only. Email or text listing agent with questions. Please note that all offers are due by Tuesday 11/23 by 1pm.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven
architectural_style__c, Georgian;Colonial
bath_features__c, Tub;Tile;Double Sinks;Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1916
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Andy Ardila
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-11-10T21:47:07.000+0000
days_on_market__c, 616
dom__c, 13
ffd_description_pb, Stately traditional Georgian Colonial residence located at the corner of 29th & Lake Street. In mint condition with superb detail throughout. Spacious living room, formal dining room, kitchen & bath on main floor with 4 bedrooms and 2 baths on upper floor. Full basement. Includes backyard & and detached 2 car garage. www.2750lake.com
district__c, SF District 1
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Front Yard;Full
fireplace_features__c, Wood Burning;Gas Starter
pba__floortype_pb__c, Carpet;Marble;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T16:05:45.000+0000
pba__latitude_pb__c, 37.7852917
pba__latitude_property__c, 37.7852917
laundry_features__c, Inside Room;Washer Included;Dryer Included;Gas Hook-Up
listed_date__c, 2021-10-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Costello
listing_agent_mls_id__c, 810541
ffd_listingagentname, David S Costello
listing_agent_number__c, 1046798
listing_co_agent_mls_id__c, 815676
listing_co_agent_number__c, 1073945
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3900000
pba__listingtype__c, Sale
pba__listing_website__c, http://2750lake.com/
pba__longitude_pb__c, -122.4891765
mls_id__c, 421609504
master_bathroom_features__c, Shower Stall(s);Tub;Tile;Jetted Tub;Marble;Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-11-10
original_price__c, 3900000
overall_days_on_market__c, 342
parking_access__c, Side by Side
parking_features__c, Detached,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2021-11-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1470.59
pba__propertytype__c, Single Family Residence
id, a0E8W00000V1jKlUAJ
road_surface_type__c, Paved
roof__c, Tar/Gravel
room_type__c, Storage;Office;Laundry;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Wine Storage Area
sale_date__c, 2021-12-23
sale_price__c, 4100000
security_features__c, Smoke Detector;Fire Alarm;Carbon Mon Detector;Double Strapped Water Heater
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, 2788
size__c, 2788
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Lake
subdist__c, Sea Cliff
ffd_name, 2750 Lake Street, San Francisco, CA, 94121
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530353912-1.jpg
ListingId, a0E8W00000V1jKlUAJ