Courtesy of Lysha Payseno, Valley Land & Investment Co. - [email protected]
Experience the ultimate in luxury living with this stunning 4-bedroom, 3-bathroom home nestled in the prestigious Kings River Estates. Step into a spacious family room with a private wet bar, perfect for entertaining or relaxing. The kitchen has been meticulously remodeled with top-of-the-line appliances to cater the descering tastes of its owner.The main suite offers a private retreat, complete with a luxurious bath area featuring a variety of indulgent features. For this who enjoy gaming, a dedicated game room or den provides a prefect space for the family fun.One of the four bedrooms boasts it own private bathroom, conveniently located at the opposite end of the home. The expansive 3-car garage offers ample storage space, while the beautiful custom backyard features a large covered patio and outdoor kitchen, creating an oasis for the outdoor entertaining. Don't miss the opportunity to explore the spacious loft inside the Shop, accessible via an easement from the back of the property. This incredible estate home is a must-see and experience for anyone seeking the epitome of luxury living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1982
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$379
Price Per Acre
$1,931,818
Days On London
0
Cumulative Days On London
0
County
Tulare
Reports Available
NHD, Prelim Title Report, Seller Disclosure
Special Features
Isolated Bedroom, Isolated Bathroom, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
400 Avenue
Directions
Just West of the Kings River Golf & Country club Avenue 400, (sierra), South on Kings River Dr. west on Bonander Dr.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 969000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1071000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2439 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2939 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` = 1657301 OR `props-main`.`id` = 1657541 OR `props-main`.`id` = 1769383 OR `props-main`.`id` = 1719523 OR `props-main`.`id` = 1719551)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654513' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-29' 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
Last modified 3 hours ago
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.
