meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218645' 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, 454 Lake Street, San Francisco, CA, 94118
ffd_mls_id, 421543309
ffd_salesforce_id, a0E1I00000USQpbUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 5
address2__c, 454 Lake Street, San Francisco, CA, 94118
pba__address_pb__c, 454 Lake Street, San Francisco, CA, 94118
agent_only_remarks__c, Please use Calendly to schedule Covid compliant showings. https://calendly.com/tomcooke/454-lake Escrow opened with Kelley Kish at First American.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s);Tile;Dual Flush Toilet;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-03T16:47:16.000+0000
days_on_market__c, 807
dom__c, 4
ffd_description_pb, The perfect blend of Edwardian charm combined with a just remodeled kitchen and bath, makes this condo in the desirable Lake District a wonderful city home! Stunning new kitchen features Thermador appliances, quartz countertops, and beautiful new cabinetry. Open floor plan with large living room and formal dining room with boxed-beam ceiling and decorative fireplace, creates the perfect entertaining space. New bathroom is stunning with luxurious tile work and fittings. There are two spacious bedrooms, one with charming window seats, plus an in-unit laundry. The home also has exquisite new windows throughout. Garage parking and additional large storage space are included. With Mountain Lake Park and the shops and restaurants of Clement Street nearby, this thoughtfully and beautifully remodeled Lake Street home offers the best in city living!
district__c, SF District 1
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only;Dining Room
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Heat,Homeowners Insurance,Security
pba__hoafees__c, 610
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2022-01-25T15:51:15.000+0000
pba__latitude_pb__c, 37.786906
pba__latitude_property__c, 37.786906
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2021-05-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Thomas
pba__listing_agent_lastname__c, Cooke
listing_agent_mls_id__c, 404543
ffd_listingagentname, Tom Cooke
listing_agent_number__c, 404543
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1575000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.tourfactory.com/2854874
pba__longitude_pb__c, -122.464544
mls_id__c, 421543309
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000003BgWlUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-03
original_price__c, 1575000
overall_days_on_market__c, 84
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Facing Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-05-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000USQpbUAH
room_type__c, Laundry;Kitchen;Living Room;Dining Room
sale_date__c, 2021-06-07
sale_price__c, 1675000
selling_agent_mls_id__c, 803120
selling_agent_number__c, 803120
selling_co_agent_mls_id__c, 806303
selling_co_agent_number__c, 166016715
selling_co_office_mls_id__c, COMP7PAR
selling_co_office_name__c, Compass SF
selling_co_office_number__c, 27677
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lake
subdist__c, Lake Street
ffd_name, 454 Lake Street, San Francisco, CA, 94118
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530230745-1.jpg
ListingId, a0E1I00000USQpbUAH
