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/crmls/MC25228233/8360-Lakeshore-Dr/Chowchilla/https://www.robinsbestnest.com/images/props/crmls/full/MC25228233.jpgLondon Properties Chowchilla Real Estate | 8360 Lakeshore Dr
Robin Hillhouse209.777.2282robinsbestnest@outlook.comEmail Agent
Property Description
Listing Agent: Billye Hughes, Land Company Real Estate
This home is uniquely over the top! Not just a home, but a statement - this one-of-a-kind showpiece was built to stand above the rest. From the moment you arrive, your 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 overlooks 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
$168
Days On Market
7
Cumulative Days On Market
7
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
Bonus Room, Living Room, Main Floor Bedroom, Primary Suite, Office, Two Primaries, Walk-In Closet, Walk-In Pantry, Wine Cellar
Balcony, Bar, Ceiling Fan(s), Crown Molding, High Ceilings, Pantry, Vacuum Central
Flooring
See Remarks
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room, Library
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
Back Yard, Front Yard
Lot Size Area
9583.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Golf Course, See Remarks
Fencing
Wrought Iron
Common Interest
Planned Development
Parcel Number
014131068
Additional Parcels Y/N
No
Community Features
Golf, Rural, Sidewalks, Street Lights
Association Amenities
Pool, Golf Course
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
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 758100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 837900 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` = 1687519 OR `props-main`.`id` = 1657495 OR `props-main`.`id` = 1657502 OR `props-main`.`id` = 1681324 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` = 1684923 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` = 1684417 OR `props-main`.`id` = 1673145 OR `props-main`.`id` = 1673148 OR `props-main`.`id` = 1682128 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1686569 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` = 1662063 OR `props-main`.`id` = 1686528 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1683488 OR `props-main`.`id` = 1688792 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1679984 OR `props-main`.`id` = 1679983 OR `props-main`.`id` = 1668683 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` = 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` = 893173 OR `props-main`.`id` = 1681414 OR `props-main`.`id` = 1681370 OR `props-main`.`id` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1663347 OR `props-main`.`id` = 1637622)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25228233' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-07' 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.