Courtesy of John Bortz, Century 21 Ditton Realty - [email protected]
Bring your clubs and enjoy the golf-course lifestyle in the desirable River Creek neighborhood! This beautiful custom home offers approximately 3,478 square feet of living space on 1.08 usable acres, with stunning views overlooking the golf course and a peaceful pond.The thoughtfully designed 4-bedroom, 3-full-bath home features spacious living areas, abundant windows, and beautiful outdoor spaces. The upper level welcomes you with a large primary suite complete with two walk-in closets, a separate sitting area, and a cozy fireplace. The primary bathroom features a dual-sink vanity and Jacuzzi tub, creating a relaxing retreat. Step outside to the wraparound deck and enjoy the tranquil surroundings.The well-appointed kitchen offers granite countertops, an abundance of cabinetry, a pantry, and a convenient breakfast bar. A spacious laundry room provides additional storage.The lower level features a generous family room, two additional bedrooms, a flexible bonus area currently arranged as a fourth bedroom, and a full bathroom. A separate entrance, covered concrete patio, and attached two-car garage provide excellent potential for a vacation rental, monthly rental, guest suite, or multigenerational living arrangement.Parking is plentiful with a three-car attached garage upstairs plus an additional two-car garage downstairs. The property also features a concrete driveway, river-rock exterior accents, mature oak trees, natural rock outcroppings, landscaping, and a welcoming fire-pit sitting area.Additional amenities include a tankless water heater, whole-house generator and plenty of storage. Most furnishings are sold with the home.With its golf-course setting, flexible living arrangement, generous garage space, and beautiful natural surroundings, this unique property offers an exceptional opportunity to enjoy the River Creek lifestyle.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Foothill
# of Stories
Two
Price Per Square Foot
$223
Price Per Acre
$717,500
Days On London
2
Cumulative Days On London
2
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 600
Directions
Highway 49 to Toad 600 to Indian Rock to Singing Hills
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Disposal, Trash Compactor, Eating Area, Breakfast Bar, Pantry
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Carpet
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
APN
055 600 002 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Wasuma
School Type 3
Grade School
School Name 3
Wasuma
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 736155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 813645 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3228 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3728 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` = 1751097 OR `props-main`.`id` = 1722250 OR `props-main`.`id` = 1747799 OR `props-main`.`id` = 1750013 OR `props-main`.`id` = 1760663 OR `props-main`.`id` = 1765583 OR `props-main`.`id` = 1765595 OR `props-main`.`id` = 1735991 OR `props-main`.`id` = 1718208 OR `props-main`.`id` = 1718322 OR `props-main`.`id` = 1716342 OR `props-main`.`id` = 1737403 OR `props-main`.`id` = 1737395 OR `props-main`.`id` = 1751304 OR `props-main`.`id` = 1719081 OR `props-main`.`id` = 1719036 OR `props-main`.`id` = 1725507 OR `props-main`.`id` = 1751699 OR `props-main`.`id` = 1752617 OR `props-main`.`id` = 1753413 OR `props-main`.`id` = 1721209 OR `props-main`.`id` = 1721232 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1738609 OR `props-main`.`id` = 1716115 OR `props-main`.`id` = 1716195 OR `props-main`.`id` = 1767696 OR `props-main`.`id` = 1767697 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1748665 OR `props-main`.`id` = 1748616 OR `props-main`.`id` = 1742456 OR `props-main`.`id` = 1765469 OR `props-main`.`id` = 1753382 OR `props-main`.`id` = 1749710 OR `props-main`.`id` = 1749681 OR `props-main`.`id` = 1726581 OR `props-main`.`id` = 1726566 OR `props-main`.`id` = 1723664 OR `props-main`.`id` = 1723658)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654207' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-26' 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 39 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.
