Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/tulare/240488/34453-Sierra-Dr/Lemon-Cove/https://www.londonproperties.com/images/props/tulare/full/240488.jpgLondon Properties Lemon Cove Real Estate | 34453 Sierra Dr
Rare opportunity to own a private hillside retreat on approximately 37 acres with panoramic views of Lake Kaweah and the surrounding valley. This well-maintained property offers space, privacy, and a truly scenic setting. The home features 3 bedrooms plus multiple bonus rooms, providing flexible space for a variety of uses. Additional interior highlights include a flex space with sitting bar and mini refrigerator, ideal for a game room, media area, office, or retreat space Functional layout with comfortable living areas and ongoing updates throughout. Property includes laundry hookups both inside and outside for added convenience. Enjoy expansive acreage, rolling hills, and breathtaking lake and valley views from your own property. Ideal for a primary residence, second home, or investment opportunity.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2006
Year Built Source
Public Records
Days On London
0
Cumulative Days On London
0
County
Tulare
Property Condition
Updated/Remodeled
New Construction
No
Stories
2
Directions to Property
From Visalia take Hwy 198 East, just before first Lake Kaweah boat ramp, driveway is on the right.
Construction Materials
Stucco
Foundation Details
Raised
Roof
Shingle
Heating
Central
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Inside, Outside
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Direction Faces
North
# of Main Level Bathrooms
2
Bathrooms Total (Integer)
3
Full Baths
2.5
Full Baths
2
Half Baths
1
Fireplace Y/N
No
Flooring
Combination
Spa
No
Utilities
Electricity Connected, Propane
Water Source
Well
Sewer
Septic Tank
Garage
No
APN
064 030 011 000
Lot Dimensions
1 , 2 7 2 . 9 6 f t × 1 , 2 7 2 . 9 6 f t
Horse Property
No
Additional Parcels Y/N
No
View
Hills, Lake
Waterfront Y/N
No
Road Surface Type
Paved
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 854905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 944895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2550 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1713637 OR `props-main`.`id` = 1712436 OR `props-main`.`id` = 1712406 OR `props-main`.`id` = 1717349)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240488' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-20' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Jesus Flores, Legacy Real Estate Inc
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
