Listing Agent: Jason Fretag, Century 21 Select Real Estate
Welcome to 28788 Avenue 16 -Custom Home sits on perfectly flat and useable one acre lot This 4bed 3bath 3 car garage home with a AWESOME separate bed and bath private entry. This custom home has a tiled roof with its tasteful interior, features 9'ceilings. Recessed lighting throughout, 51/4 baseboards. Granite/quartz countertops throughout. Beautifully matching decor tiled backsplashes complementing the elegant countertops. Stainless steel appliances. Gas burner stove/oven, with a mic-hood. Generous sized closets, dual vanities and WIC in primary bedroom. Home is equipped with plexiglass super upgraded windows, for security and noise reduction. Tankless WH, interior two toned paint, and a customized poured driveway complement this delightful home. The property has a storage shed in back and storage tank for well. RV parking on the side, all the way down the length of the yard. The front has mature landscape with flowers, trees, covered patio, and wrought iron gate.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2017
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$310
Days On London
0
Cumulative Days On London
0
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
Yes
Cooling Y/N
Yes
Directions
take rd 28 to Ave 16
Room Type
All Bedrooms Down
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Individual Room
Main Level Bedrooms
1
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
1
Common Walls
2+ Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Water Source
Well, Private
Sewer
Engineered Septic
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
0-1 Unit/Acre
Lot Size Area
43560.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Pasture, Hills
Common Interest
None
Parcel Number
035110065
Additional Parcels Y/N
No
Community Features
Biking, Foothills, Street Lights, Sidewalks, Park
Senior Community Y/N
No
Association Y/N
No
High School District
Madera Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
3
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 603249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 666748.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1801 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2301 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` = 1765968 OR `props-main`.`id` = 1763051 OR `props-main`.`id` = 1724172 OR `props-main`.`id` = 1776901 OR `props-main`.`id` = 1761045 OR `props-main`.`id` = 1760716 OR `props-main`.`id` = 1761693 OR `props-main`.`id` = 1790479 OR `props-main`.`id` = 1713047 OR `props-main`.`id` = 1782789 OR `props-main`.`id` = 1786825 OR `props-main`.`id` = 1726127 OR `props-main`.`id` = 1726230 OR `props-main`.`id` = 1765471 OR `props-main`.`id` = 1784005 OR `props-main`.`id` = 1792558 OR `props-main`.`id` = 1695501 OR `props-main`.`id` = 1695363 OR `props-main`.`id` = 1771581 OR `props-main`.`id` = 1762171 OR `props-main`.`id` = 1677972 OR `props-main`.`id` = 1679099 OR `props-main`.`id` = 1728096 OR `props-main`.`id` = 1793121 OR `props-main`.`id` = 1793122 OR `props-main`.`id` = 1679100 OR `props-main`.`id` = 1678504 OR `props-main`.`id` = 1791887 OR `props-main`.`id` = 1791898 OR `props-main`.`id` = 1792017 OR `props-main`.`id` = 1791862 OR `props-main`.`id` = 1788129 OR `props-main`.`id` = 1791545 OR `props-main`.`id` = 1776069 OR `props-main`.`id` = 1726091 OR `props-main`.`id` = 1787876)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26225937' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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.
