Welcome to your dream staycation home! This beautifully appointed 3-bedroom, 2.5-bathroom residence offers generous living space, thoughtful design, and a stunning backyard retreat. Inside, you'll find two separate living areas with endless options to fit your family's lifestyle. The spacious family room features a warm fireplace and flows seamlessly into the large kitchen, perfect for everyday living and entertaining. The primary suite and the family room offer direct access to the show-stopping backyard, where resort-style living awaits. Enjoy a brand-new swimming pool and spa (built in 2022), a mini golf course, and views of the adjacent Pheasant Run Golf Course. The expansive covered patio features ceiling fans for comfort on warm days and is ideal for outdoor dining or evening relaxation. The front patio and drought-tolerant landscaping add curb appeal while keeping maintenance low. Energy-efficient solar panels provide long-term savings and peace of mind.If you're looking for comfort, flexibility, and luxuryall in one placethis home truly has it all.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$260
Price Per Acre
$1,513,158
Days On Market
21
Cumulative Days On Market
103
County
Madera
REO / Bank Owned
No
Cross Street Address
Robertson Blvd/Golf Drive West
Directions
Heading E on Robinson turn right Golf Drive W Make first right than Left on Spyglass Cir
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave
Primary Bedroom Level
Lower
Extra Rooms
Office, Den/Study
# of Fireplaces
1
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Patio Features
Covered
Yard
Synthetic Lawn
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Lease
Garage Type
Attached
Garage Spaces
3
Site Amenities
Golf Course, Lake View
APN
014 233 008 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Security Guard, Lake/Pond, Other/None
HOA Dues
219.00
Frequency
Monthly
School District
Chowchilla
School Type 1
High School
School Name 1
Chowchilla
School Type 2
Junior High School
School Name 2
Wilson
School Type 3
Grade School
School Name 3
Wilson
Seller Will Consider
Government, Conventional, Cash
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 546250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 603750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1961 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2461 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` = 1657495 OR `props-main`.`id` = 1657502 OR `props-main`.`id` = 1668318 OR `props-main`.`id` = 1668319 OR `props-main`.`id` = 1668314 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1647284 OR `props-main`.`id` = 1675030 OR `props-main`.`id` = 1675091 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1678773 OR `props-main`.`id` = 1686266 OR `props-main`.`id` = 1686293 OR `props-main`.`id` = 1661810 OR `props-main`.`id` = 1687217 OR `props-main`.`id` = 1687858 OR `props-main`.`id` = 1646822 OR `props-main`.`id` = 1646820 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1683488 OR `props-main`.`id` = 1679983 OR `props-main`.`id` = 1682742 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1678053 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1663753 OR `props-main`.`id` = 1663836 OR `props-main`.`id` = 1685347 OR `props-main`.`id` = 1663766 OR `props-main`.`id` = 1688450 OR `props-main`.`id` = 1677288 OR `props-main`.`id` = 1675277 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1682090 OR `props-main`.`id` = 1654660 OR `props-main`.`id` = 1688341 OR `props-main`.`id` = 1688357 OR `props-main`.`id` = 1682292 OR `props-main`.`id` = 1681682 OR `props-main`.`id` = 1688214 OR `props-main`.`id` = 1681686 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1678917 OR `props-main`.`id` = 1678911 OR `props-main`.`id` = 1679908 OR `props-main`.`id` = 1679929 OR `props-main`.`id` = 1679911 OR `props-main`.`id` = 1683718 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 OR `props-main`.`id` = 1683550 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1663347 OR `props-main`.`id` = 1637622)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634686' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-03' 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();
2
Similar Properties
$587,500
4
3
2,168
0.25
8385 Lake Shore Dr
Chowchilla, CA 93610
$567,500
4
3
2,168
0.24
8440 Lake Shore Dr
Chowchilla, CA 93610
Courtesy of Chase Holland, Real Broker - chaseholland00@gmail.com Last modified 2 weeks ago Fresno MLS last checked for updates 20 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.
