Listing Agent: Scott Messing, Century 21 Select Real Estate Listing Co-Agent: Stacy Tennesen, Century 21 Select Real Estate
Rare opportunity to own this beautiful home tucked away on a private three-home court at the end of the street. This spacious residence features 5 bedrooms and 2.5 baths, highlighted by a stunning living and dining room combination with soaring ceilings, exposed beams, and abundant natural light that creates an immediate ''wow'' factor. Situated on a large, desirable lot, the backyard offers a built-in pool and spa, covered patio, added privacy, and ample space with potential for an ADU. The kitchen opens to the inviting family room with a cozy fireplace and includes a breakfast area, breakfast bar, and pantry for everyday convenience . The main suite features a separate tub and shower along with a glass slider leading to a private balcony-perfect for relaxing and enjoying the views.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2004
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$208
Days On London
0
Cumulative Days On London
0
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
Certified 433a Y/N
No
Directions
Robertson Blvd East to first gate, Club Drive West, L on Emerald St, R on Edgewater St, Left on Echo Court
Disclosures
CC And R's
Architectural Style
Mediterranean
Room Type
Walk-In Closet, Separate Family Room, Kitchen, Living Room, Main Floor Bedroom, Family Room, Primary Suite
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room, Electric Dryer Hookup, Washer Hookup
Roof
Tile
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s), Gated Community
Construction Materials
Frame, Stucco
Window Features
Double Pane Windows
Foundation Details
Slab
Main Level Bedrooms
1
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
1
Room Kitchen Features
Tile Counters, Kitchen Open to Family Room
Eating Area
Breakfast Counter / Bar, In Living Room, Area
Appliances Y/N
Yes
Appliances
Water Heater, Disposal, Microwave, Built-In Range, Electric Range, Electric Oven
Room Bathroom Features
Tile Counters, Shower in Tub, Exhaust fan(s), Bathtub, Double Sinks in Primary Bath
Interior Features
Pantry, Open Floorplan, Tile Counters
Flooring
Tile, Carpet, Wood, Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas, Family Room
Pool Features
In Ground, Private, Heated, Gunite
Pool Private Y/N
Yes
Spa Y/N
Yes
Spa Features
In Ground, Private, Heated, Gunite
Patio Y/N
Yes
Patio And Porch Features
Covered, Patio Open
Electric
Standard, Electricity - On Property, Photovoltaics on Grid
Utilities
Sewer Connected, Electricity Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
5.00
Parking Features
Garage Faces Front, Driveway
Attached Garage Y/N
Yes
Garage Spaces
2.00
Uncovered Spaces
3.00
Lot Features
Sprinklers In Front, Cul-De-Sac, Landscaped, Front Yard, Lot 10000-19999 Sqft, Sprinkler System, Back Yard, Lawn, Sprinklers In Rear
Lot Size Area
12197.0000
Lot Size Units
Square Feet
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Average Condition
Common Interest
Planned Development
Parcel Number
014080062
Additional Parcels Y/N
No
Community Features
Lake, Street Lights
Association Amenities
Sport Court, Playground, Pool, Spa/Hot Tub, Picnic Area
Senior Community Y/N
No
Association Y/N
Yes
Association Name
Greenhills Master Association
Association Management Name
Regency Property Management
Association Fee
234.00
Association Fee Frequency
Monthly
High School District
Chowchilla Union
High School
Chula Vista
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
62
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 513000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 567000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2346 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2846 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` = 1722997 OR `props-main`.`id` = 1722999 OR `props-main`.`id` = 1722995 OR `props-main`.`id` = 1722996 OR `props-main`.`id` = 1723000 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` = 1718336 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` = 1687858 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1714248 OR `props-main`.`id` = 1723267 OR `props-main`.`id` = 1710045 OR `props-main`.`id` = 1691873 OR `props-main`.`id` = 1710027 OR `props-main`.`id` = 1704531 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` = 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` = 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` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1712555 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1721091 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 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` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1705307 OR `props-main`.`id` = 1716921)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26089548' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-27' 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();
1
Similar Properties
$540,000
5
3
2,596
0.28
7705 Echo Ct
Chowchilla, CA 93610
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.
