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
$293
Price Per Acre
$599,999
Days On London
0
Cumulative Days On London
0
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
Spanish, Contemporary
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) >= 569999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629998.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` = 1724172 OR `props-main`.`id` = 1742348 OR `props-main`.`id` = 1752292 OR `props-main`.`id` = 1750470 OR `props-main`.`id` = 1695973 OR `props-main`.`id` = 1732048 OR `props-main`.`id` = 1732040 OR `props-main`.`id` = 1716451 OR `props-main`.`id` = 1732270 OR `props-main`.`id` = 1727267 OR `props-main`.`id` = 1718850 OR `props-main`.`id` = 1713047 OR `props-main`.`id` = 1705385 OR `props-main`.`id` = 1731519 OR `props-main`.`id` = 1747330 OR `props-main`.`id` = 1726127 OR `props-main`.`id` = 1678202 OR `props-main`.`id` = 1752324 OR `props-main`.`id` = 1747769 OR `props-main`.`id` = 1716356 OR `props-main`.`id` = 1726230 OR `props-main`.`id` = 1726903 OR `props-main`.`id` = 1724979 OR `props-main`.`id` = 1730087 OR `props-main`.`id` = 1752505 OR `props-main`.`id` = 1737647 OR `props-main`.`id` = 1695501 OR `props-main`.`id` = 1695363 OR `props-main`.`id` = 1714480 OR `props-main`.`id` = 1727714 OR `props-main`.`id` = 1741368 OR `props-main`.`id` = 1677972 OR `props-main`.`id` = 1679099 OR `props-main`.`id` = 1728096 OR `props-main`.`id` = 1754952 OR `props-main`.`id` = 1679100 OR `props-main`.`id` = 1678504 OR `props-main`.`id` = 1719557 OR `props-main`.`id` = 1744397 OR `props-main`.`id` = 1707164 OR `props-main`.`id` = 1726091 OR `props-main`.`id` = 1721097 OR `props-main`.`id` = 1709618)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651883' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-30' 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
Last modified 1 hour ago Fresno MLS last checked for updates 5 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.
