**Investors or Owner Occupied Dream** 2 Adjoining Parcels (19300 Avenue 23 & 22863 Alder St.) Located near the New Northfork Rancheria Casino being built North of Madera (off Hwy 99); and near future California High Speed Rail Line. The 2 Adjoining Properties total about 2.25 acres. Each property has a DOUBLE-WIDE MOBILE HOME. Could be used for additional income. They share a Large 30'X20' Metal Shop/Barn, and a Single Car Garage. There are also several Fenced Off areas that are perfect for a livestock setup. Buyer to be responsible for any inspections, repairs, survey, corner locations, or boundary line reports. Water Service is provided by Madera County. PG&E provides Gas and Electricity. Each mobile is a 2 bedroom/2 bath unit. The larger one is 1368sf +/- and the other is 1120sf +/-. Both are registered thru the State of California. There is a small storage type mobile on the property with no value. And an older building. Do not enter. View from outside only.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built
1970
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$123
Price Per Acre
$135,556
Days On Market
0
Cumulative Days On Market
0
County
Madera
Special Features
Security Gate, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Fairmead Blvd
Directions
Fairmead Blvd, go East on Avenue 23 for about 1/4 mile to property, on South side of road.
Unit Description
Ground Floor
Heating & Cooling
Evaporative Cool
Laundry
Inside
Roofing
Other
Foundation
Wood Subfloor
Detached Structures
Shop
Kitchen
Electric Appliances
Primary Bedroom Level
Lower
Flooring
Carpet, Vinyl
Exterior
Metal
Pool
No
Pool
No
Yard
Fenced
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Solar
No
Parking Features
Potential RV Parking, Work/Shop Area
Garage Type
Detached
Garage Spaces
1
APN
027 101 026 000
School District
Chowchilla
School Type 1
High School
School Name 1
Chowchilla
School Type 2
Junior High School
School Name 2
Wilson
School Type 3
Grade School
School Name 3
Chowchilla Schools
Seller Will Consider
Conventional, Cash, Limited Financing
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 289750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 320250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2238 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2738 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` = 1692780 OR `props-main`.`id` = 1666056 OR `props-main`.`id` = 1636207 OR `props-main`.`id` = 1676842 OR `props-main`.`id` = 1693235 OR `props-main`.`id` = 1676879 OR `props-main`.`id` = 1677234 OR `props-main`.`id` = 1676892 OR `props-main`.`id` = 1622909 OR `props-main`.`id` = 1665818 OR `props-main`.`id` = 1692698 OR `props-main`.`id` = 1680678 OR `props-main`.`id` = 1698990 OR `props-main`.`id` = 1687519 OR `props-main`.`id` = 1695766 OR `props-main`.`id` = 1692712 OR `props-main`.`id` = 1622790 OR `props-main`.`id` = 1696749 OR `props-main`.`id` = 1695477 OR `props-main`.`id` = 1636375 OR `props-main`.`id` = 1692783 OR `props-main`.`id` = 1666061)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641280' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-23' 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 Gregory Johnson, Landmark Properties - [email protected] Last modified 19 hours ago Fresno MLS last checked for updates 3 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.
