Please provide the following information and Robin Hillhouse will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.robinsbestnest.com/agent/15022/robin-hillhouse/property/link/metrolist/225126011/8230-Lake-Shore-Dr/Chowchilla/https://www.robinsbestnest.com/images/props/metrolist/full/225126011.jpgLondon Properties Chowchilla Real Estate | 8230 Lake Shore Dr
Robin Hillhouse209.777.2282robinsbestnest@outlook.comEmail Agent
Property Description
Brand new single story custom home! Its located in the prestigious Greenhills Golf Course Community spectacular views of both the lake and golf course! Views from inside the great room, kitchen and primary bedroom. This bedroom new home boast 4 bed, 3 full baths, 3 walk -in closets, laundry room with a cabinet and sink and wet bar. To look out to a Magnificent view. So many other amenities. A MUST SEE!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Custom
Year Built
2025
Year Built Source
Builder
Remodeled/Updated
No
Stories
1
Pets Allowed
Yes, Service Animals OK, Cats OK, Dogs OK
Home Warranty
Yes
Directions to Property
From Hwy get at Robertson Blvd exit, head East towards SaveMart. Go past first stop sign. One block up right side is the first Greenhills guard gate. Make right. Once in make a right on Golf Dr. stay on street for approx 1 1/2 miles till you see Lake Share Dr. And the two Casscades Waterfalls. Make left and again. 8230 Lakeside Dr. Chowchilla.
Cross Street
Golf Dr, West
County
Madera
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Shower Stall(s), Double Sinks, Jack & Jill, Tub w/Shower Over, Quartz
Flooring
Carpet, Vinyl
Appliances
Gas Plumbed, Hood Over Range, Dishwasher, Disposal, Tankless Water Heater, Free Standing Electric Oven
Room Type
Primary Bathroom, Primary Bedroom, Den, Dining Room, Family Room, Great Room, Kitchen, Laundry
Kitchen Features
Breakfast Area, Quartz Counter, Slab Counter, Island, Kitchen/Family Combo
Dining Room Features
Dining Bar, Dining/Family Combo
Living Room Features
Other
Family Room Features
Great Room
Primary Bedroom Features
Ground Floor, Walk-In Closet
Primary Bathroom Features
Shower Stall(s), Double Sinks, Outside Access
Exterior Features
Covered Courtyard
Patio And Porch Features
Back Porch, Covered Patio
Pool
Yes
Pool Features
Common Facility
Spa
Yes
Spa Features
Spa/Hot Tub Built-In
ADU/2nd Unit
No
Utilities
Cable Available, Public, Electric, Solar, Internet Available
Electric
220 Volts in Kitchen,220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Other
Energy Efficient
Appliances, Insulation, Cooling, Thermostat, Heating, Windows
Parking Features
Attached, EV Charging, Garage Door Opener, Garage Facing Front, Guest Parking Available, Interior Access
Garage Spaces
3.00
Lot Features
Auto Sprinkler Front, Gated Community, Landscape Front
APN
014 131 055
Land Use
Residential
Topography
Level
View Description
Golf Course, Lake
Driveway/Sidewalks
Paved Driveway
Fencing
Back Yard, Entry Gate, Fenced, Full, Other
Horse Property
No
Road Surface Type
Paved
Road Responsibility
Private Maintained Road
Zoning Description
SFR
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
239
Association Fee Frequency
Monthly
Association Fee Includes
MaintenanceGrounds, Security, Pool
Association Features
Playground, Pool, Clubhouse, Exercise Course, Spa/Hot Tub, Park
Restrictions
Board Approval
Senior Community
No
School District (County)
Madera
Elementary School District
Other
Middle or Junior School District
Other
Senior High School District
Other
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 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) >= 1915 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2415 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` = 1687519 OR `props-main`.`id` = 1657495 OR `props-main`.`id` = 1657502 OR `props-main`.`id` = 1694678 OR `props-main`.`id` = 1681324 OR `props-main`.`id` = 1654610 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1668318 OR `props-main`.`id` = 1668319 OR `props-main`.`id` = 1668314 OR `props-main`.`id` = 1689684 OR `props-main`.`id` = 1693446 OR `props-main`.`id` = 1691923 OR `props-main`.`id` = 1691867 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1684923 OR `props-main`.`id` = 1690829 OR `props-main`.`id` = 1675030 OR `props-main`.`id` = 1675091 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1678773 OR `props-main`.`id` = 1682128 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1693158 OR `props-main`.`id` = 1695393 OR `props-main`.`id` = 1695386 OR `props-main`.`id` = 1661810 OR `props-main`.`id` = 1694199 OR `props-main`.`id` = 1694235 OR `props-main`.`id` = 1687217 OR `props-main`.`id` = 1687858 OR `props-main`.`id` = 1691708 OR `props-main`.`id` = 1646822 OR `props-main`.`id` = 1646820 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1692953 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1683488 OR `props-main`.`id` = 1691922 OR `props-main`.`id` = 1691873 OR `props-main`.`id` = 1691879 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1691077 OR `props-main`.`id` = 1690957 OR `props-main`.`id` = 1690973 OR `props-main`.`id` = 1686074 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1691494 OR `props-main`.`id` = 1691481 OR `props-main`.`id` = 1691490 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1692985 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` = 1689750 OR `props-main`.`id` = 1689740 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1682090 OR `props-main`.`id` = 1654660 OR `props-main`.`id` = 1692518 OR `props-main`.`id` = 1693255 OR `props-main`.`id` = 1688357 OR `props-main`.`id` = 1693412 OR `props-main`.`id` = 1692697 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` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1694185 OR `props-main`.`id` = 1694648 OR `props-main`.`id` = 1689060 OR `props-main`.`id` = 1695744 OR `props-main`.`id` = 1695725 OR `props-main`.`id` = 1694881 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1637622)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225126011' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-22' 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 Donna Koblis, PMZ Real Estate IDX provided by Reliance Marketing
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.