1 Home, 2,228 sq. ft., 4 bdrm, 3 bth, 2 car garage, New AC/Heat unit Shop Bldng - 50 X 100 size Smaller Bldng - 20 X 30 size 1 - Domestic Well - 5 hp. PG&E electric = 2 meters (Home & Shop - separate) Other Amenities: Perimeter Fencing, Mature Landscape, Corner Lot, Locked Entry gates Possible uses: Trucking Company, Custom Farming Business Storage, Rental, Plus Storage and large equipment parking Close access to Hwy 152
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
2005
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
No
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Highway 152 to Road 16 North to Ave. 23 1/2. Driveway faces Road 16. Front door faces Ave. 23 1/2
Cross Street
Road 16
County
Madera
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Ranch
Construction Materials
Stucco
Foundation
Concrete, Slab
Roof
Shingle, Composition
Heating
Propane, Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Inside Room
Other Structures
Workshop, Outbuilding
Full Bathrooms
3
Bath Features
Closet, Double Sinks, Jack & Jill, Tub w/Shower Over
Flooring
Carpet, Tile
Appliances
Built-In Gas Range, Dishwasher, Disposal
Room Type
Workshop
Kitchen Features
Granite Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Great Room
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Available, Internet Available, Propane Tank Owned
Electric
220 Volts
Irrigation
None
Water Source
Well, Private
Sewer
Septic System
Parking Features
Attached, Garage Door Opener, Garage Facing Side, Guest Parking Available
Garage Spaces
2.00
Lot Features
Auto Sprinkler Front, Landscape Front
APN
026 290 034
View Description
Other
Driveway/Sidewalks
Gated, Paved Driveway
Fencing
Back Yard, Cross Fenced, Fenced, Masonry
Horse Property
No
Zoning Description
AR-5
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Madera
Elementary School District
Other
Middle or Junior School District
Other
Senior High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1187500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1312500 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) >= 1978 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2478 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` = 1709905 OR `props-main`.`id` = 1687519 OR `props-main`.`id` = 1703845 OR `props-main`.`id` = 1698993 OR `props-main`.`id` = 1690698 OR `props-main`.`id` = 1690691 OR `props-main`.`id` = 1654610 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1680786 OR `props-main`.`id` = 1711273 OR `props-main`.`id` = 1675030 OR `props-main`.`id` = 1682128 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1710574 OR `props-main`.`id` = 1700186 OR `props-main`.`id` = 1710205 OR `props-main`.`id` = 1710203 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1710478 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1709211)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226007632' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Larry Serpa, Century 21 Select Real Estate 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.
