This is your chance to secure the current waitlisted floorplan The Royal at Kings Estates. PRICED TO SELL - Seller is motivated - Don't miss your opportunity to close escrow before the new school year begins.A highly upgraded, move-in-ready home on a large lot. This home features extensive premium builder upgrades, including smooth interior and exterior wall finishes, owned solar, landscaped backyard complete with timed irrigation, and an additonal half bathroom with door to the backyard and large 4 car garage. Situated on a pool-sized lot, there's plenty of space for your dream backyard, plus discreet RV and boat parking. The property is also equipped with rough-ins for future ADU; ideal for multigenerational living, a private guest suite, or an at home office.Inside, you'll find a spacious and thoughtfully designed floor plan featuring 4 bedrooms, 3.5 bathrooms, and an open-concept living area that's perfect for entertaining. The beautifully appointed kitchen offers abundant workspace, quality finishes, and a layout designed to bring everyone together. The luxurious primary suite is a true retreat, featuring a spa-inspired bathroom with a freestanding soaking tub, oversized walk-in shower, and dual walk-in closets.Soaring ceilings paired with expansive windows allow an abundance of natural light to fill this home, creating a welcoming atmosphere.Step outside to enjoy a generously sized backyard with time irrigated lawn, covered patios, and raised garden beds with irrigationready for your next harvest. Just down the street, you'll find a neighborhood park and pickleball courts, adding to the appeal of this exceptional community.This is a rare opportunity to own a like-new home without the construction wait time. Simply unpack and start enjoying luxury living from day one.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$276
Price Per Acre
$3,378,378
Days On London
0
Cumulative Days On London
0
County
Fresno
Reports Available
Pest, Financial Statement, NHD, Prelim Title Report
Special Features
Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
S Mendocino Ave / S Madsen Ave
Directions
From HWY 99 exit Mountain view head East, take right onto S Mendicino Ave turn left onto Solig Ave and property is on your right.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 736250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 813750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2554 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3054 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` = 1736105 OR `props-main`.`id` = 1725462 OR `props-main`.`id` = 1725480 OR `props-main`.`id` = 1738616 OR `props-main`.`id` = 1739591 OR `props-main`.`id` = 1750665 OR `props-main`.`id` = 1750677 OR `props-main`.`id` = 1724795 OR `props-main`.`id` = 1751167 OR `props-main`.`id` = 1751264 OR `props-main`.`id` = 1753549 OR `props-main`.`id` = 1751290 OR `props-main`.`id` = 235510 OR `props-main`.`id` = 1700911 OR `props-main`.`id` = 1721267 OR `props-main`.`id` = 1717730 OR `props-main`.`id` = 1747526 OR `props-main`.`id` = 1731047 OR `props-main`.`id` = 1745715 OR `props-main`.`id` = 1731159 OR `props-main`.`id` = 1746862 OR `props-main`.`id` = 1734807 OR `props-main`.`id` = 1748530 OR `props-main`.`id` = 1748344 OR `props-main`.`id` = 1749201 OR `props-main`.`id` = 1688521 OR `props-main`.`id` = 1726432 OR `props-main`.`id` = 1725565 OR `props-main`.`id` = 1753838 OR `props-main`.`id` = 1728847 OR `props-main`.`id` = 1728921 OR `props-main`.`id` = 1721620 OR `props-main`.`id` = 1739569 OR `props-main`.`id` = 1723198 OR `props-main`.`id` = 1740563 OR `props-main`.`id` = 1737847 OR `props-main`.`id` = 1741731 OR `props-main`.`id` = 1739012 OR `props-main`.`id` = 1724174 OR `props-main`.`id` = 1746924)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652615' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-25' 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 53 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.
