Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/646990/41797-River-Knolls-Way/Coarsegold/https://www.londonproperties.com/images/props/fresno/full/646990.jpgLondon Properties Coarsegold Real Estate | 41797 River Knolls Way
With incredible curb appeal and a backyard oasis to match, let someone else's regret be your win. This beautiful, fully remodeled 4-bed, 2-bath home sits on nearly 5 acres at the end of a peaceful cul-de-sac in a dream neighborhood known for its privacy, natural beauty, and pride of ownership. Every inch of this home has been thoughtfully upgraded with care and intention, blending modern design with warmth and soul. The kitchen shines with quartz countertops, freshly painted cabinetry, an extra-large deep sink, extended backsplash, new hardware, new faucet, and brand-new stainless steel appliances. Both bathrooms have been fully remodeled with clean, modern finishes. Enjoy vaulted ceilings, a ton of natural light, and everyday moments surrounded by nature and local wildlife. This home also features a whole house fan plus a brand-new HVAC unit for year-round comfort and efficiency. The 3-car garage, mudroom entry, and spacious laundry room add practical touches, while the large walk-in pantry offers plenty of storage space. A long driveway enhances that tucked-away feeling, while the circular drive adds elegance and convenience. The backyard is a dream - beautifully landscaped with unmatched views you'll enjoy every single day. Whether you're hosting friends or just living your everyday life, the peaceful setting and surrounding nature make it feel like a retreat at home. Not to mention, a designated space for RV parking, complete with electric and water hookups. This is more than a house, it's a home filled with heart, care, and intentional upgrades!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$291
Price Per Acre
$139,619
Days On London
61
Cumulative Days On London
61
County
Madera
Reports Available
Septic
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
HWY 41 & Road 415
Directions
Off of Road 415 and River Knolls
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Tile, Vinyl
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Stucco
Pool
No
Pool
No
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto, Mature Landscape, Drip System
Gas & Electric
Propane
Sewer / Water
Septic Tank, Shared Well
Solar
No
Parking Features
Existing RV Parking, Circular Driveway
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
Site Amenities
Cul De Sac
APN
054 293 036 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 626050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 691950 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) >= 2016 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2516 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` = 91486 OR `props-main`.`id` = 1728398 OR `props-main`.`id` = 1725795 OR `props-main`.`id` = 1726113 OR `props-main`.`id` = 1722603 OR `props-main`.`id` = 1713573 OR `props-main`.`id` = 1683078 OR `props-main`.`id` = 1706819 OR `props-main`.`id` = 1722853 OR `props-main`.`id` = 1667788 OR `props-main`.`id` = 1715021 OR `props-main`.`id` = 1731509 OR `props-main`.`id` = 1714993 OR `props-main`.`id` = 1715010 OR `props-main`.`id` = 1711485 OR `props-main`.`id` = 1711501 OR `props-main`.`id` = 1717498 OR `props-main`.`id` = 1722589 OR `props-main`.`id` = 1723500 OR `props-main`.`id` = 1725496 OR `props-main`.`id` = 1728752 OR `props-main`.`id` = 1728755 OR `props-main`.`id` = 1733236 OR `props-main`.`id` = 1733607 OR `props-main`.`id` = 1703830 OR `props-main`.`id` = 1703810 OR `props-main`.`id` = 1684942 OR `props-main`.`id` = 1732154 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1729602 OR `props-main`.`id` = 1708115 OR `props-main`.`id` = 1731399 OR `props-main`.`id` = 1708102 OR `props-main`.`id` = 1731167 OR `props-main`.`id` = 1731183 OR `props-main`.`id` = 1720098 OR `props-main`.`id` = 1702353 OR `props-main`.`id` = 1718550 OR `props-main`.`id` = 1687573 OR `props-main`.`id` = 1718266 OR `props-main`.`id` = 1665915 OR `props-main`.`id` = 1726842 OR `props-main`.`id` = 1676323 OR `props-main`.`id` = 1731342 OR `props-main`.`id` = 1676330 OR `props-main`.`id` = 1723177 OR `props-main`.`id` = 1719041 OR `props-main`.`id` = 1719083 OR `props-main`.`id` = 1726382 OR `props-main`.`id` = 1726362 OR `props-main`.`id` = 1725794 OR `props-main`.`id` = 1725813 OR `props-main`.`id` = 1721416 OR `props-main`.`id` = 1732309 OR `props-main`.`id` = 1726490 OR `props-main`.`id` = 1665763 OR `props-main`.`id` = 1687544 OR `props-main`.`id` = 1728256 OR `props-main`.`id` = 1728260 OR `props-main`.`id` = 1731455 OR `props-main`.`id` = 1731653 OR `props-main`.`id` = 1724372 OR `props-main`.`id` = 1705347 OR `props-main`.`id` = 1719794 OR `props-main`.`id` = 1722098)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646990' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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 1 month ago Fresno MLS last checked for updates 52 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.
