meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='324241' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70652
[post_author] => 4
[post_date] => 2018-11-30 20:30:25
[post_date_gmt] => 2018-11-30 20:30:25
[post_content] => A thin sliver of streets as north as you can be on the west side of town without being in the Presidio. Compared to the Richmond, you'll generally find larger homes on shorter streets with select homes opening up to back-door Presidio access. West Clay is an exclusive enclave of special homes within a special neighborhood.
[post_title] => Lake Street
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lake-street
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 13:15:32
[post_modified_gmt] => 2024-04-09 20:15:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70652
[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, 164 24th Avenue, San Francisco, CA, 94121
ffd_mls_id, 422689875
ffd_salesforce_id, a0E8W00000YYoW0UAL
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 164 24th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 164 24th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Offers welcome anytime! Seller reserves the right to reject, counter or accept any offers. Easy to show! Seller's family is house-sitting, do not crash! Please contact Betty for showings or questions @ 415-690-8288. Pre-sale escrow with DOMA (Carla Williams). Thank you for showing!
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Built-In Gas Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Contemporary;Modern/High Tech;Art Deco
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1970
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-08-26T01:47:47.000+0000
days_on_market__c, 328
dom__c, 110
ffd_description_pb, Calling all Sea Cliff Buyers! One block away from the world famous locations: Sea Cliff and the Presidio. Located in the highly coveted West Clay Park! One of a kind renowned architectural designed home. 3-stories home with desirable floor plan: 3 Beds/3.5 Baths, laundry, 2-3 car side by side garage. The main living area is perfect for entertaining, bursting with natural sunlight, highlighted by double-height floor-to-ceiling windows and a one of most unique retractable skylight! The Zen-like tranquil primary suite has panoramic views of the Golden Gate Bridge with a spa-like bath. In addition to the 3 spacious bedrooms there is an office area and bonus rooms. Enjoy the view of the Golden Gate Bridge from your deck! Nearby Parks, Lincoln park Golf, China Beach, Land's End trails, Shopping areas, restaurants, and more. Easy access to HWY 1/101.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced;Front Yard
pba__floortype_pb__c, Carpet;Laminate;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T17:35:02.000+0000
pba__latitude_pb__c, 37.786306
pba__latitude_property__c, 37.786306
laundry_features__c, Laundry Closet;Ground Floor;Stacked Only
listed_date__c, 2022-06-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Betty
pba__listing_agent_lastname__c, Chen
listing_agent_mls_id__c, 806668
ffd_listingagentname, Betty Chen
listing_agent_number__c, 166017409
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AJ&C
listing_office_name__c, Andersen, Jung & Co.
listing_office_number__c, 576
pba__listingprice_pb__c, 3990000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=dvXv8FUJ9jF&mls=1
pba__longitude_pb__c, -122.483836
mls_id__c, 422689875
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Double Sinks;Tile;Jetted Tub;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-08-25
original_price__c, 5280000
overall_days_on_market__c, -81320
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Garage Facing Rear,Private
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Deck
pba__pendingdate__c, 2023-01-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 968.7
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YYoW0UAL
road_surface_type__c, Paved
roof__c, Bitumen
sale_date__c, 2023-01-30
sale_price__c, 3930000
security_features__c, Smoke Detector;Security Fence;Carbon Mon Detector;Security System Prewired
selling_agent_mls_id__c, 810769
selling_agent_number__c, 1047912
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, 4057
size__c, 4057
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 24th
subdist__c, Lake Street
ffd_name, 164 24th Avenue, San Francisco, CA, 94121
view__c, Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1970
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530519012-1.jpg