Location, location, location, almost 5 ACRES in the hart of Madera, close to Freeway 99 and close to High School, & shopping centers. This almost 5 acres consist of 2 parcels; 036-140-010 & 036-140-010-000. The posibilities are endless. First time buyers or investors looking for extra income. The double wide mobile home has a large deck, 3 bedroom & 2 bath. Both home & mobile home have around 8 years old roof, plenty of room for animals & storage. Community well & septic, individual electricity & propane tank. The list goes on & on.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built
1981
Region
Rural
Unique Conditions
1031 Exchange
# of Stories
Single Story
Price Per Square Foot
$1,019
Price Per Acre
$137,827
Days On Market
5
Cumulative Days On Market
5
County
Madera
REO / Bank Owned
No
Cross Street Address
26 AVE
Directions
Avenue 26 to 17 1/2 property will be on the left.
Heating & Cooling
Floor or Wall Unit
Laundry
Utility Room
Roofing
Composition
Foundation
Both
Primary Bedroom Level
Lower
Exterior
Stucco, Log
Pool
No
Pool
No
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Shared Well, Private Well
Solar
No
Parking Features
Potential RV Parking
APN
036 140 010 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Grade School
School Name 2
Berenda
School Type 3
Junior High School
School Name 3
Jack G. Desmond
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 650750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 719250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 422 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 922 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` = 1691401 OR `props-main`.`id` = 1676214 OR `props-main`.`id` = 1697561 OR `props-main`.`id` = 1676339 OR `props-main`.`id` = 1697749 OR `props-main`.`id` = 1686180 OR `props-main`.`id` = 1697921 OR `props-main`.`id` = 1683320 OR `props-main`.`id` = 1693848 OR `props-main`.`id` = 1693046 OR `props-main`.`id` = 1693580 OR `props-main`.`id` = 1684521 OR `props-main`.`id` = 1679009 OR `props-main`.`id` = 1679008 OR `props-main`.`id` = 1679011 OR `props-main`.`id` = 1679010 OR `props-main`.`id` = 1696585 OR `props-main`.`id` = 1696038 OR `props-main`.`id` = 1689552 OR `props-main`.`id` = 1696299 OR `props-main`.`id` = 1698001 OR `props-main`.`id` = 1695771 OR `props-main`.`id` = 1696064 OR `props-main`.`id` = 1688382 OR `props-main`.`id` = 1679800 OR `props-main`.`id` = 1686985 OR `props-main`.`id` = 1694890 OR `props-main`.`id` = 1695164 OR `props-main`.`id` = 1692088 OR `props-main`.`id` = 1688418 OR `props-main`.`id` = 1691069 OR `props-main`.`id` = 1691000 OR `props-main`.`id` = 1690972 OR `props-main`.`id` = 1693698 OR `props-main`.`id` = 1687182 OR `props-main`.`id` = 1693538 OR `props-main`.`id` = 1687168 OR `props-main`.`id` = 1687178 OR `props-main`.`id` = 1680464 OR `props-main`.`id` = 1666451)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640288' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Adriana Arteaga, Fireside Realty - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 10 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.
