Eric R. Cogdill559.917.3246ecogdill@londonproperties.comEmail Agent
Property Description
Motivated Seller! This home is now priced below new construction of the same model and you will already have backyard landscaping. Welcome to this darling 3-bedroom, 2-bath home, nestled in the highly sought-after Riverstone Community! Built by Lennar, the Charm model offers a perfect blend of comfort and functionality. Featuring an open, inviting floor plan, this home is ideal for both everyday living and entertaining.Step outside into the large backyard, which offers plenty of space to create your dream oasis whether it's a sparkling pool, an expansive patio for family gatherings, or the perfect outdoor entertaining area. The possibilities are endless!Riverstone is a vibrant community designed for active living, offering a stunning Lodge, resort-style pool, multiple parks including a dog park for your furry friend sand scenic walking trails perfect for leisurely strolls. Families will appreciate the highly rated schools in the area, making Riverstone an ideal place to grow and thrive. Exciting additions are on the way, with a brand-new Lodge and a second elementary school scheduled for completion in 2026.Don't miss your chance to live in one of the most desirable neighborhoods in the area. Schedule a showing today and come see all that this home and community have to offer!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2024
Region
Urban
Unique Conditions
Relo Company
# of Stories
Single Story
Price Per Square Foot
$287
Price Per Acre
$3,500,000
Days On Market
27
Cumulative Days On Market
27
County
Madera
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Cathedral Ct
Directions
From Fresno North on 41 to Ave. 12 to rd 40 turn left to Root Creek turn left to milestone turn left to cathedral turn left to Wayfarer turn right.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Basement
None
Flooring
Carpet, Vinyl
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa Type
Community Spa
Yard
Sprinklers Front, Sprinklers Auto
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C, Tankless Water Heater
Solar
Yes
Solar Type
Lease
Garage Type
Attached
Garage Spaces
2
APN
080 343 031 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Security Guard, Playground
HOA Dues
124.00
Frequency
Monthly
School District
Golden Valley
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Webster
72870
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 365750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 404250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1091 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1591 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` = 1574826 OR `props-main`.`id` = 1689058 OR `props-main`.`id` = 1686759 OR `props-main`.`id` = 1688126 OR `props-main`.`id` = 1682088 OR `props-main`.`id` = 1695324 OR `props-main`.`id` = 1680641 OR `props-main`.`id` = 1680630 OR `props-main`.`id` = 1685740 OR `props-main`.`id` = 1685741 OR `props-main`.`id` = 1676304 OR `props-main`.`id` = 1676311 OR `props-main`.`id` = 1650911 OR `props-main`.`id` = 1659420 OR `props-main`.`id` = 1680897 OR `props-main`.`id` = 1674430 OR `props-main`.`id` = 1691765 OR `props-main`.`id` = 1691079 OR `props-main`.`id` = 1690933 OR `props-main`.`id` = 1680213 OR `props-main`.`id` = 1673842 OR `props-main`.`id` = 1680120 OR `props-main`.`id` = 1694038 OR `props-main`.`id` = 1670995 OR `props-main`.`id` = 1669671 OR `props-main`.`id` = 1671318 OR `props-main`.`id` = 1691591 OR `props-main`.`id` = 1690090 OR `props-main`.`id` = 1669691 OR `props-main`.`id` = 1690744 OR `props-main`.`id` = 1664689 OR `props-main`.`id` = 1671666 OR `props-main`.`id` = 1696170 OR `props-main`.`id` = 1696274 OR `props-main`.`id` = 1690952 OR `props-main`.`id` = 1689042 OR `props-main`.`id` = 1690954 OR `props-main`.`id` = 1690938 OR `props-main`.`id` = 1692326 OR `props-main`.`id` = 1678329 OR `props-main`.`id` = 1695759 OR `props-main`.`id` = 1679787 OR `props-main`.`id` = 1686394 OR `props-main`.`id` = 1695087 OR `props-main`.`id` = 1687286 OR `props-main`.`id` = 1671535 OR `props-main`.`id` = 1671823 OR `props-main`.`id` = 1671802 OR `props-main`.`id` = 1683036 OR `props-main`.`id` = 1683548 OR `props-main`.`id` = 1683733 OR `props-main`.`id` = 1693469 OR `props-main`.`id` = 1673582 OR `props-main`.`id` = 1694473 OR `props-main`.`id` = 1692105 OR `props-main`.`id` = 1684659 OR `props-main`.`id` = 1669630 OR `props-main`.`id` = 1696021 OR `props-main`.`id` = 1694074 OR `props-main`.`id` = 1694691 OR `props-main`.`id` = 1688462 OR `props-main`.`id` = 1690136 OR `props-main`.`id` = 1688445 OR `props-main`.`id` = 1673738 OR `props-main`.`id` = 1685862 OR `props-main`.`id` = 1695835 OR `props-main`.`id` = 1689731)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638894' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-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();
8
Similar Properties
$399,999
3
2.5
1,398
0.04
915 Winchell Way W
Madera, CA 93636
$397,000
3
2.5
1,512
0.04
157 Capstone Way S
Madera, CA 93636
$390,000
3
2.5
1,579
0.05
933 Winchell Way W
Madera, CA 93636
$382,000
3
2.5
1,227
0.04
1106 Significant Way W
Madera, CA 93636
Courtesy of Michele Shadle, Century 21 Select Real Estate - michele.shadle@c21selectgroup.com Last modified 1 week ago Fresno MLS last checked for updates 17 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.
