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.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2006
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
Robertson Boulevard to Golf Drive West to Twin Falls Way to Torrey Pines Circle.
Cross Street
Twin Falls Way
County
Madera
Special Listing Conditions
Offer As Is
Main Level
Family Room, Garage, Kitchen
Construction Materials
Concrete, Stucco
Foundation
Concrete
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
Inside Area
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Other
Flooring
Other
Kitchen Features
Other Counter
Dining Room Features
Other
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Curb(s), Other
APN
014 211 022
Horse Property
No
Zoning Description
SFR
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
252
Association Fee Frequency
Monthly
Association Fee Includes
Security
Association Features
Playground, Other
Senior Community
No
School District (County)
Madera
Elementary School District
Chowchilla Elementary
Middle or Junior School District
Chowchilla Elementary
Senior High School District
Chowchilla Union High
Census Tract
2.04
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 464550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 513450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' 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` = 1729032 OR `props-main`.`id` = 1729043 OR `props-main`.`id` = 1731757 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1731508 OR `props-main`.`id` = 1724804 OR `props-main`.`id` = 1716962 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1731371 OR `props-main`.`id` = 1731955 OR `props-main`.`id` = 1731904 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1722078 OR `props-main`.`id` = 1731590 OR `props-main`.`id` = 1721098 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1714700 OR `props-main`.`id` = 1731456 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1727711 OR `props-main`.`id` = 1727716 OR `props-main`.`id` = 1726932 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1725553 OR `props-main`.`id` = 1728428 OR `props-main`.`id` = 1728415 OR `props-main`.`id` = 1731330 OR `props-main`.`id` = 1725132 OR `props-main`.`id` = 1726323 OR `props-main`.`id` = 1725135 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1722740 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1714260 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1731461 OR `props-main`.`id` = 1731513 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1731335 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1731574 OR `props-main`.`id` = 1726302 OR `props-main`.`id` = 1732152 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1731515 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1731713 OR `props-main`.`id` = 1730085 OR `props-main`.`id` = 1731777 OR `props-main`.`id` = 1732657 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1723311 OR `props-main`.`id` = 1718358 OR `props-main`.`id` = 1718314 OR `props-main`.`id` = 1718318 OR `props-main`.`id` = 1731548 OR `props-main`.`id` = 1718231 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1730883 OR `props-main`.`id` = 1730993 OR `props-main`.`id` = 1731185 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1731701 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1716921 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1731702 OR `props-main`.`id` = 1727729)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226061340' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-04' 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 Kristin Price, London Properties LTD 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.
