Come experience a tour of this one-of-a-kind, pristine residence, with OWNED SOLAR Classically designed, this home exudes sophistication at every turn, from imported Italian tile and exquisite light fixtures to blush-toned cabinetry in the absolutely gorgeous gourmet kitchen, with upgraded island and appliances. Thoughtfully appointed bathroom vanities and hand-hewn wooden beams crafted by a local artisan, adds warmth and character throughout.The luxurious primary bathroom is a sanctuary unto itself, featuring a freestanding clawfoot tub and a dazzling gold and glass chandelier, creating an atmosphere of serene opulence. A ceiling-mounted rainfall shower, precisely regulated by a Moen thermostatic valve, ensures the perfect water temperature with every use. Each bedroom offers a unique and thoughtfully curated design, making this home as individual as it is inspiring.The backyard is a true oasis, thoughtfully designed for both relaxation and entertainment. It features two elegant pergolas equipped with outdoor speakers, creating the perfect ambiance for gatherings. A sparkling pool and spa are enhanced by a tranquil waterfall and a convenient outdoor shower. The expansive Koi pond, complete with a professional filtration system and protective mesh. The outdoor space is as sustainable as it is stunning. An exceptional setting for outdoor living at its finest.Just minutes away from fine dining and entertainment! Call for a tour today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2014
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$372
Price Per Acre
$3,470,368
Days On Market
5
Cumulative Days On Market
151
County
Fresno
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Friant Rd & Marina Dr
Directions
Head north on Friant Rd, turn right on Marina Dr, Turn left onto Bella Vista Ln, Turn left onto Ruscello Ln
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 617500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' 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` = 1648036 OR `props-main`.`id` = 1678497 OR `props-main`.`id` = 1679972 OR `props-main`.`id` = 1677209 OR `props-main`.`id` = 1687288 OR `props-main`.`id` = 1695816 OR `props-main`.`id` = 1679409 OR `props-main`.`id` = 1665810 OR `props-main`.`id` = 1666174 OR `props-main`.`id` = 1694176 OR `props-main`.`id` = 1666175 OR `props-main`.`id` = 1696300 OR `props-main`.`id` = 1680696 OR `props-main`.`id` = 1680697 OR `props-main`.`id` = 1683158)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640287' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-17' 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 Lety Castaneda, Real Broker - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 13 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.
