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/648797/31486-Big-River-Way/Coarsegold/https://www.londonproperties.com/images/props/fresno/full/648797.jpgLondon Properties Coarsegold Real Estate | 31486 Big River Way
Welcome to this beautifully maintained home nestled on a tranquil cul-de-sac where privacy meets views. Inside, you'll find durable tile flooring throughout and charming window shutters that frame rooms with warmth and style. The 200-amp electrical service sets this home apart, already prepped for solar panels or a hot tub a rare and valuable upgrade. All appliances are included for a seamless move-in experience, while abundant storage with two sheds and 3 bay garage ensures a place for everything. Whether you're relaxing in your private backyard retreat or taking in the views, this well-loved home delivers lifestyle and value in one complete package.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1975
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$338
Price Per Acre
$231,783
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Lilley Mountain Dr
Directions
from 41 N, take Yosemite Springs Pkwy, Then take Corral Dr to Big River Way in Yosemite Lakes
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Propane
Sewer / Water
Public Water, Septic Tank
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
APN
092 020 009 000
Association / Park Amenities
Pool, Club House, Lake/Pond
HOA Dues
200.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Coarsegold
School Type 3
Grade School
School Name 3
Coarsegold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 284050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 313950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 634 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1134 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` = 1705132 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1726456 OR `props-main`.`id` = 1726449 OR `props-main`.`id` = 1703646 OR `props-main`.`id` = 1703657 OR `props-main`.`id` = 1703656 OR `props-main`.`id` = 1702537 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1709899 OR `props-main`.`id` = 1709957 OR `props-main`.`id` = 1674929 OR `props-main`.`id` = 1717964 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1718019 OR `props-main`.`id` = 1717272 OR `props-main`.`id` = 1725475 OR `props-main`.`id` = 1723707 OR `props-main`.`id` = 1725481 OR `props-main`.`id` = 1714054 OR `props-main`.`id` = 1714048 OR `props-main`.`id` = 1721524 OR `props-main`.`id` = 1716191 OR `props-main`.`id` = 1716166 OR `props-main`.`id` = 1719419 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1665857 OR `props-main`.`id` = 1704611 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` = 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` = 1693727 OR `props-main`.`id` = 1693832 OR `props-main`.`id` = 1703830 OR `props-main`.`id` = 1703810 OR `props-main`.`id` = 1684942 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1708115 OR `props-main`.`id` = 1708102 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` = 1666171 OR `props-main`.`id` = 1726842 OR `props-main`.`id` = 1676323 OR `props-main`.`id` = 1676330 OR `props-main`.`id` = 1725363 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` = 1693882 OR `props-main`.`id` = 1726490 OR `props-main`.`id` = 1665763 OR `props-main`.`id` = 1687544)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648797' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-14' 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 Mark Campbell, Modern Broker - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 9 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.
