Welcome to 738 Katelyn Avenue in Madera! Built in 2024, this two-story home offers 3 bedrooms, 2.5 bathrooms, and approximately 1,820 square feet of living space. The open main level features a spacious kitchen with white cabinetry, contrasting dark finishes, a large island, and plenty of room to gather. Upstairs, you'll find the bedrooms and conveniently located laundry. A two-car garage, low-maintenance front landscaping, and community amenitiesincluding a pool, spa, clubhouse, exercise room, and playgroundround out the home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2024
Year Built Source
Owner
Remodeled/Updated
No
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
Use GPS
Cross Street
Robert Ave
County
Madera
Special Listing Conditions
None
Main Level
Living Room, Partial Bath(s), Garage, Kitchen
Construction Materials
Stucco
Foundation
Concrete
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Upper Floor, Hookups Only
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Shower Stall(s)
Flooring
Tile
Appliances
Free Standing Gas Range, Dishwasher, Disposal, Microwave, Free Standing Gas Oven
Kitchen Features
Granite Counter, Island
Dining Room Features
Space in Kitchen
Living Room Features
Other
Upper Level
Bedroom(s), Primary Bedroom, Full Bath(s)
Basement
None
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Internet Available
Electric
220 Volts in Laundry,Other
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Other
APN
081 449 006
Horse Property
No
Zoning Description
R
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
187
Association Fee Frequency
Monthly
Association Fee Includes
Pool
Association Features
Pool, Clubhouse, Exercise Room, Spa/Hot Tub
Senior Community
No
School District (County)
Madera
Elementary School District
Chawanakee Unified
Middle or Junior School District
Chawanakee Unified
Senior High School District
Chawanakee Unified
Census Tract
299.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 399000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 441000 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) >= 1570 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2070 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` = 1732247 OR `props-main`.`id` = 1780159 OR `props-main`.`id` = 1744711 OR `props-main`.`id` = 1718634 OR `props-main`.`id` = 1718647 OR `props-main`.`id` = 1780896 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1738120 OR `props-main`.`id` = 1785869 OR `props-main`.`id` = 1775043 OR `props-main`.`id` = 1770014 OR `props-main`.`id` = 1754293 OR `props-main`.`id` = 1754307 OR `props-main`.`id` = 1758018 OR `props-main`.`id` = 1754791 OR `props-main`.`id` = 1747675 OR `props-main`.`id` = 1765451 OR `props-main`.`id` = 1760687 OR `props-main`.`id` = 1791337 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1771396 OR `props-main`.`id` = 1770646 OR `props-main`.`id` = 1756086 OR `props-main`.`id` = 1788761 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1737523 OR `props-main`.`id` = 1768854 OR `props-main`.`id` = 1774483 OR `props-main`.`id` = 1773174 OR `props-main`.`id` = 1773173 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1767648 OR `props-main`.`id` = 1776191 OR `props-main`.`id` = 1788834 OR `props-main`.`id` = 1765465 OR `props-main`.`id` = 1787675 OR `props-main`.`id` = 1769141 OR `props-main`.`id` = 1746844 OR `props-main`.`id` = 1752920 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1779987 OR `props-main`.`id` = 1778512 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1755604 OR `props-main`.`id` = 1737137 OR `props-main`.`id` = 1737138 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226120119' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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 Miguelina Acantilado, Miguelina Acantilado, Broker 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.
