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/crmls/MC25228233/8360-Lakeshore-Dr/Chowchilla/https://www.londonproperties.com/images/props/crmls/full/MC25228233.jpgLondon Properties Chowchilla Real Estate | 8360 Lakeshore Dr
Listing Agent: Billye Hughes, Land Company Real Estate
REDUCED AND LOOKING FOR A NEW FAMILY! This one-of-a-kind showpiece was built to stand above the rest. From the moment you arrive, you're greeted by grand details. Once inside you find an entertainment room with fireplace and wet bar made with hammered brass, onyx stonework and rich wood trim. Dramatic custom finishes throughout including extensive onyx stonework on staircase walls. Stairway is wrought iron railing with custom cast aluminum inserts. The expansive open concept living space with beautifully crafted ceilings and built-in cabinets. Fully equipped Chefs kitchen with Thermador Appliances , chandelier and walk in pantry with direct access to outdoors. There is a wine room with built-in racks and wine fridge. Upstairs leads you to a spacious loft or study retreat with built-in desk and shelving. Primary Suite with private balcony overlooking golf course, dual walk-in closets, oversized two person jacuzzi tub and 2 separate vanities. Laundry room is conveniently located upstairs and offers a Whirlpool Personal Valet System. Central Vacuum. Elegant travertine tile throughout(except 1 bedroom). 3 car garage enhanced with carriage style doors. Outdoor kitchen with plexiglass sound/wind wall, stainless steel grill, mini fridge, sink, dishwasher and tons of storage and eating area. Backyard offers one of the best views at the golf course, overlooking the sierras and 3rd Hole.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2008
Year Built Source
Public Records
Special Listing Conditions
Trust
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$136
Days On London
213
Cumulative Days On London
213
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
use gps
Room Type
Walk-In Closet, Walk-In Pantry, Bonus Room, Office, Two Primaries, Living Room, Main Floor Bedroom, Primary Suite, Wine Cellar
Crown Molding, Bar, Balcony, High Ceilings, Ceiling Fan(s), Pantry, Vacuum Central
Flooring
See Remarks
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Library, Family Room
Pool Features
Community
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Front Yard, Back Yard
Lot Size Area
9583.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
See Remarks, Golf Course
Fencing
Wrought Iron
Common Interest
Planned Development
Parcel Number
014131068
Additional Parcels Y/N
No
Community Features
Golf, Rural, Street Lights, Sidewalks
Association Amenities
Golf Course, Pool
Senior Community Y/N
No
Association Y/N
Yes
Association Name
Greenhills masters
Association Management Name
Regency
Association Fee
219.00
Association Fee Frequency
Monthly
High School District
Chowchilla Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 616075 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 680925 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4511 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 5011 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` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1722999 OR `props-main`.`id` = 1724804 OR `props-main`.`id` = 1716962 OR `props-main`.`id` = 1702898 OR `props-main`.`id` = 1702827 OR `props-main`.`id` = 1702880 OR `props-main`.`id` = 1704177 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1718428 OR `props-main`.`id` = 1711273 OR `props-main`.`id` = 1722078 OR `props-main`.`id` = 1721098 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1714700 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1723233 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1714339 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1720619 OR `props-main`.`id` = 1725553 OR `props-main`.`id` = 1725132 OR `props-main`.`id` = 1725135 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1714248 OR `props-main`.`id` = 1723267 OR `props-main`.`id` = 1722740 OR `props-main`.`id` = 1721284 OR `props-main`.`id` = 1721067 OR `props-main`.`id` = 1721227 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1723986 OR `props-main`.`id` = 1723993 OR `props-main`.`id` = 1723976 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1723288 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1714574 OR `props-main`.`id` = 1724324 OR `props-main`.`id` = 1724329 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1714260 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1725465 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1721091 OR `props-main`.`id` = 1724425 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1723311 OR `props-main`.`id` = 1718358 OR `props-main`.`id` = 1718314 OR `props-main`.`id` = 1718318 OR `props-main`.`id` = 1718231 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1716921)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25228233' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-06' 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
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.
