Courtesy of Khushmeen Dhother, HomeSmart PV and Associates - [email protected]
Welcome to this beautiful 6 bedroom, 3 bathroom foothill home in Friant, conveniently located near Table Mountain Casino and Milerton Lake! This property offers a wonderful blend of comfort, functionality, and outdoor enjoyment. The home features owned, free and clear solar and a four-zone A/C system for added comfort throughout the seasons, a whole house fan, as well as recent upgrades to the flooring. Downstairs offers an open concept living areas and a bedroom or potential office with an adjacent bathroom for next-gen living. Upstairs, the primary suite includes a spacious bathroom offers dual shower heads and a relaxing soaking tub. Step outside to enjoy the covered patio complete with lighting and a ceiling fan, perfect for entertaining or unwinding outdoors. The property also features established fruit trees, a dedicated dog run, and a brand-new sprinkler control system to help maintain the outdoor spaces. Located within the Clovis Unified School District, this home offers a unique opportunity to enjoy foothill living. Don't miss the opportunity to make this special property your own!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2014
Region
Foothill
# of Stories
Two
Price Per Square Foot
$204
Price Per Acre
$3,356,643
Days On London
1
Cumulative Days On London
1
County
Fresno
REO / Bank Owned
No
Cross Street Address
Milerton RD and Marina DR
Directions
Head north on Friant Road, which continues onto Millerton Road. Turn right onto Marina Drive. Turn left onto Bella Vista Lane. Turn right onto Tramonto Lane. Continue to 21333 Tramonto Lane.
Heating & Cooling
Central Heat & Cool, Whole House Fan
Laundry
Inside, On Lower Level, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed, Green House
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 684000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 756000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3287 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3787 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` = 1747379 OR `props-main`.`id` = 1734864 OR `props-main`.`id` = 1760131 OR `props-main`.`id` = 1751421 OR `props-main`.`id` = 1751411 OR `props-main`.`id` = 1751412 OR `props-main`.`id` = 1765390 OR `props-main`.`id` = 1751400 OR `props-main`.`id` = 1780408 OR `props-main`.`id` = 1754246 OR `props-main`.`id` = 1776679 OR `props-main`.`id` = 1723756 OR `props-main`.`id` = 1789915 OR `props-main`.`id` = 1777784 OR `props-main`.`id` = 1712949 OR `props-main`.`id` = 1713014 OR `props-main`.`id` = 1779593 OR `props-main`.`id` = 1751420 OR `props-main`.`id` = 1721647 OR `props-main`.`id` = 1762355 OR `props-main`.`id` = 1762354 OR `props-main`.`id` = 1747609 OR `props-main`.`id` = 1738618 OR `props-main`.`id` = 1744677 OR `props-main`.`id` = 1759509 OR `props-main`.`id` = 1775438 OR `props-main`.`id` = 1726211 OR `props-main`.`id` = 1765446 OR `props-main`.`id` = 1766870 OR `props-main`.`id` = 1766872)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656554' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-11' 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 2 hours ago Fresno MLS last checked for updates 5 minutes 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.
