meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217281' 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, 286 24th Avenue, San Francisco, CA, 94121
ffd_mls_id, 421521775
ffd_salesforce_id, a0E1I00000TvzniUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 2
address2__c, 286 24th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 286 24th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Please Email: [email protected] for all showings. Please send PEAD forms before viewing. All current Covid-19 protocols shall be followed. Buyers agent is to provide PPE / Covid compliances for viewings. ----- Please removes shoes. You may want to carry them up to go down back stairs to see garage. (go to left at bottom of back stairs to get to this Condo's garage. Please leave back door to garage unlocked. Supra lockbox only with email confirmed viewing time. Matterport: https://my.matterport.com/show/?m=xaZERKPmgji . Hoa dues pay for Hoa insurance and building maintenance. Pets allowed are 2 four legged pets. See CCRs for full details. Two Condo informal / intimate Association. Pre-emptive offers have been made despite the request for an offer timing.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Free Standing Gas Range
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-25
ffd_createddate, 2021-02-22T11:59:10.000+0000
days_on_market__c, 877
dom__c, 4
ffd_description_pb, --- Lake District --- Light Lover's Dream! This almost fully detached Top Floor Flat boasts natural light with East, West, & South Facing Windows. The Formal Entry with Spacious Landing leads to Living Room with Bay Window, Wood Burning Fireplace, Built in Cabinets, & French Doors for an Open Feel to the Formal Dining Room, also with Bay Window. The updated Kitchen is appointed with Modern touches of Stone Counters, Subway Tile Backsplash and Stainless Steel Appliances; Gas Range, Dishwasher and Large bottom freezer, French Door refrigerator. The Main Bedroom of the 2 bedrooms is Very Large with Walk in Closet and 2nd large closet. The bathroom has also been Updated with New Tile Flooring, Vanity, Toilet and has a Tile Surround, Shower over Tub with Glass Door enclosure. The Large Separate and Independent Garage has a workbench, room for Storage, Private Laundry, and allows for inside access to the flat through the back staircase. Move in Quality Condition with Location Welcomes Home
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance,Maintenance Exterior
pba__hoafees__c, 260
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 284 - 286 24th Avenue Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:45:29.000+0000
pba__latitude_pb__c, 37.784267
pba__latitude_property__c, 37.784267
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-02-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jack
pba__listing_agent_lastname__c, Murray
listing_agent_mls_id__c, 802217
ffd_listingagentname, Jack P Murray
listing_agent_number__c, 802217
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=xaZERKPmgji
pba__longitude_pb__c, -122.483787
mls_id__c, 421521775
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001VhtaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-02-22
original_price__c, 1195000
overall_days_on_market__c, 150
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-02-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1187.5
pba__propertytype__c, Condominium
id, a0E1I00000TvzniUAB
room_type__c, Living Room;Dining Room;Master Bedroom
sale_date__c, 2021-03-25
sale_price__c, 1425000
security_features__c, Security Gate
selling_agent_mls_id__c, 805607
selling_agent_number__c, 166015599
selling_co_agent_mls_id__c, 807626
selling_co_agent_number__c, 1022603
selling_co_office_mls_id__c, CORE7
selling_co_office_name__c, Core7 Real Estate
selling_co_office_number__c, 25190
selling_office_name__c, Core7 Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1200
size__c, 1200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Lake Street
ffd_name, 286 24th Avenue, San Francisco, CA, 94121
website_property_type__c, Condominium
window_features__c, Bay Window(s);Dual Pane Partial
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530186958-1.jpg
ListingId, a0E1I00000TvzniUAB