One-of-a-kind home inspired by the elegance of Italy and Spain. No detailhas been overlooked in this fully updated, custom-designed residence. Imported Italiantile flows throughout, complemented by custom cabinetry in the kitchen and hallway thatoffers both ample storage and a sleek, refined look. Thoughtful finishes include designerlight fixtures, hand-hewn wood beams, and tasteful gold accents throughout.The primary suite serves as a private retreat, featuring a freestanding soaking tub and arainfall showercreating a spa-like experience at home.The backyard is an entertainer's dream, designed with a resort-style feel reminiscent ofa luxury escape. Enjoy a pool and spa, custom-built pergola, waterfall feature, and atranquil koi pond. Additional highlights include fully owned solar for energy efficiency.Conveniently located near Table Mountain Casino, Millerton Lake, and just a short driveto the city, this home offers the perfect balance of relaxation and accessibility.This exceptional property blends luxury, comfort, and distinctive designtruly unlikeanything else on the market.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2014
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$355
Price Per Acre
$3,310,198
Days On London
76
Cumulative Days On London
76
County
Fresno
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Millerton Dr/Marina Dr
Directions
North on Friant Rd, Right on Marina Dr, Left on Bella Vista Ln, Left on Ruscello Ln.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 589000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 651000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1496 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1996 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` = 1734864 OR `props-main`.`id` = 1678497 OR `props-main`.`id` = 1725961 OR `props-main`.`id` = 1704392 OR `props-main`.`id` = 1731428 OR `props-main`.`id` = 1706992 OR `props-main`.`id` = 1705553 OR `props-main`.`id` = 1725805 OR `props-main`.`id` = 1732205 OR `props-main`.`id` = 1723756 OR `props-main`.`id` = 1718277 OR `props-main`.`id` = 1713587 OR `props-main`.`id` = 1712949 OR `props-main`.`id` = 1713014 OR `props-main`.`id` = 1717113 OR `props-main`.`id` = 1721647 OR `props-main`.`id` = 1725093 OR `props-main`.`id` = 1726211 OR `props-main`.`id` = 1701958)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645654' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 weeks ago Fresno MLS last checked for updates 7 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.
