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/223187/40863-Sierra-Dr-D/Three-Rivers/https://www.londonproperties.com/images/props/tulare/full/223187.jpgLondon Properties Three Rivers Real Estate | 40863 Sierra Dr #D
Rare Opportunity to have 800 ft of riverfront that abuts the up-and-coming golf course at hole 3! Invite family and friends to come play on your very own indoor pickleball court! This area is projected to be activity central and is Zoned O for commercial/recreation! This 2 home riverfront compound is absolutely breathtaking! The massive parklike lawn meanders to 800 ft of river frontage! The property includes the island across the river, plus the channel of the river on the opposite side and it doesn't end there. Also included is the property across the river, approximately three quarters to the top of the mountain! No need to worry about homes being built across the way. Just sit back on the sandy beach and enjoy the river life. Occasionally, in the springtime and early summer, you will experience the excitement of watching the rafters and kayakers maneuvering by! For those of you that don't wish to sit on the sidelines and watch others having all of the fun, just stroll on over to your very own Indoor pickleball court! Many of the people in Three Rivers are very action packed. Need a partner? They will come. When you want to relax , stretch out on large viewing deck that soars above the main home offering spectacular views of the river and mountains beyond. It's an entertainer's delight! This 4 bedroom, 2 bath home offers high ceilings, a large chef's kitchen that opens to the spacious living and dining areas. Awesome river views from most rooms. The 6 car garage is a car collector's dream! The 3 bed/2 bath guest house is just a few feet from the main home. This home has it's own private entertaining area with spa to boot! The 2 homes together provide 4,100 sq ft of resort living! Step outside and bring your game on! There is a 3 hole pitch and putt mini golf course to keep you up to par. The solar is owned.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2006
Year Built Source
Owner
Days On Market
904
Cumulative Days On Market
904
County
Tulare
New Construction
No
Stories
1
Directions to Property
198 East into town.
Left at Post Office and Village Market.
Go straight over the small bridge.
House will be 2nd house on left, passed the big metal shop.
Construction Materials
Frame, Stucco
Foundation Details
Slab
Roof
Spanish Tile
Heating
Central
Cooling
Central Air
Laundry Features
Inside
Other Structures
Guest House, Second Garage, Storage, Workshop
Interior Features
Built-in Features, Beamed Ceilings, Breakfast Bar, Ceiling Fan(s), Granite Counters, High Ceilings, Kitchen Island, Kitchen Open to Family Room, Open Floorplan, Pantry
Bathrooms Total (Integer)
5
Full Baths
4.75
Full Baths
4
Three Quarter Baths
1
Appliances
Convection Oven, Dishwasher, Disposal, Electric Oven, Exhaust Fan, Microwave, Range Hood, Refrigerator, Water Heater
Fireplace Y/N
Yes
Fireplace Features
Guest House, Living Room, Primary Retreat, Propane
Flooring
Carpet, Ceramic Tile
Exterior Features
Barbecue, Outdoor Grill, Outdoor Shower
Spa
Yes
Spa Features
Above Ground
Patio and Porch Features
Multiple Patios, Covered, Deck, Front Porch, Patio
Utilities
Electricity Connected, Propane, Water Connected
Electric
200+ Amp Service
Water Source
Shared Well
Sewer
Septic Tank
Parking Features
Attached, Garage Door Opener, RV Access/Parking
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
8.0
APN
068 070 031 000
Lot Features
Back Yard, Front Yard, Garden, Gentle Sloping, Landscaped, Level, Sprinklers In Front, Sprinklers In Rear, Sprinklers on Side
Lot Dimensions
irregular
Zoning Description
Zone O, F-1, AE-80
Additional Parcels Y/N
No
View
Garden, Mountain(s), River
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2085250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2304750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '7' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3850 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4350 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` = 1679469 OR `props-main`.`id` = 1695757 OR `props-main`.`id` = 1674747 OR `props-main`.`id` = 1633152 OR `props-main`.`id` = 1649097 OR `props-main`.`id` = 1697152 OR `props-main`.`id` = 1697128 OR `props-main`.`id` = 1686404 OR `props-main`.`id` = 1697127 OR `props-main`.`id` = 1697131 OR `props-main`.`id` = 1648516 OR `props-main`.`id` = 1659540 OR `props-main`.`id` = 1671876 OR `props-main`.`id` = 1686841 OR `props-main`.`id` = 1684606 OR `props-main`.`id` = 1684601 OR `props-main`.`id` = 1695337 OR `props-main`.`id` = 1691120 OR `props-main`.`id` = 1672861 OR `props-main`.`id` = 1648368 OR `props-main`.`id` = 1632224 OR `props-main`.`id` = 1697819 OR `props-main`.`id` = 1696970 OR `props-main`.`id` = 1673115 OR `props-main`.`id` = 1684224 OR `props-main`.`id` = 1587884 OR `props-main`.`id` = 1696367 OR `props-main`.`id` = 1696327 OR `props-main`.`id` = 1696341)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare223187' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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 Nancy Vevoda, STARRE
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.
