Courtesy of Kristin Price, London Properties, Chowchilla - [email protected]
Welcome to lakeview living with this beautiful two-story home featuring a bright, open floor plan designed for both everyday comfort and effortless entertaining. The spacious main living areas flow seamlessly together, showcasing serene lake views and an inviting atmosphere throughout. Enjoy relaxing mornings, peaceful evenings, and year-round enjoyment from your own lakeside setting. With generous living space, thoughtful design, and a location that captures the beauty of waterfront living, this home offers the perfect blend of comfort, style, and tranquility.Stories count is different than tax records, buyer to verify if important.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Two
Price Per Square Foot
$166
Price Per Acre
$1,803,846
Days On London
99
Cumulative Days On London
99
County
Madera
REO / Bank Owned
No
Cross Street Address
Twin Falls Way
Directions
Robertson Boulevard to Golf Drive West to Twin Falls Way to Torrey Pines Circle.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Upper
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
014 211 022 000
Association / Park Amenities
Security Guard, Gated Community
HOA Dues
252.80
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
Chowchilla Schools
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 445550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 492450 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) >= 2568 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3068 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` = 1774004 OR `props-main`.`id` = 1774013 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1734255 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1773385 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1742752 OR `props-main`.`id` = 1733239 OR `props-main`.`id` = 1773487 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1761773 OR `props-main`.`id` = 1761598 OR `props-main`.`id` = 1735557 OR `props-main`.`id` = 1744848 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1773285 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1774849 OR `props-main`.`id` = 1774845 OR `props-main`.`id` = 1774862 OR `props-main`.`id` = 1762847 OR `props-main`.`id` = 1761007 OR `props-main`.`id` = 1760989 OR `props-main`.`id` = 1760994 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1768959 OR `props-main`.`id` = 1768964 OR `props-main`.`id` = 1768980 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1749419 OR `props-main`.`id` = 1754701 OR `props-main`.`id` = 1754711 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1732730 OR `props-main`.`id` = 1732657 OR `props-main`.`id` = 1732699 OR `props-main`.`id` = 1771275 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1774648 OR `props-main`.`id` = 1774691 OR `props-main`.`id` = 1774750 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1771346 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1741745 OR `props-main`.`id` = 1741698 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1727729)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648998' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-13' 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
$485,000
5
3
3,010
0.21
9470 Hillsborough
Chowchilla, CA 93610
$469,000
3
3
2,818
0.26
15015 Torrey Pines Cir
Chowchilla, CA 93610
Last modified 3 days 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.
