Courtesy of Jason Fretag, Century 21 Select Real Estate - [email protected]
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 Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2017
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$310
Price Per Acre
$634,999
Days On London
0
Cumulative Days On London
78
County
Madera
Leased Equipment
Propane
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Security Gate, Built In Cabinets, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Road 28
Directions
Road 29 to Avenue 16
Style
Contemporary, Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
Dishwasher, Microwave, Pantry
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Shower
Disabled Features
One Level Floor
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Water Level
195.00
Well Depth
500.00
Energy Efficiency
Dual Pane Windows, Tankless Water Heater
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
APN
035 110 065 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Junior High School
School Name 2
Martin Luther King
School Type 3
Grade School
School Name 3
Millview
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`) != 'fresno656891' 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();
1
Similar Properties
$634,999
4
3
2,051
1.00
28788 Avenue 16
Madera, CA 93636
Last modified 2 hours ago Fresno MLS last checked for updates 41 minutes 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.
