Please provide the following information and Niki Upton will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.nikiupton.com/agent/158/niki-upton/property/link/fresno/634059/22674-Elm-St/Chowchilla/https://www.nikiupton.com/images/props/fresno/full/634059.jpgLondon Properties Chowchilla Real Estate | 22674 Elm St
Beautifully Remodeled Mobile Home on Permanent Foundation! New rolling gate. Spacious Lot with Room to Grow. Just a Block from the Elementary School. Perfect for Families! Don't Miss This Move-In Ready Gem! Buyer to verify all information.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1971
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$179
Price Per Acre
$1,125,000
Days On Market
59
Cumulative Days On Market
59
County
Madera
REO / Bank Owned
No
Cross Street Address
Moore Ave
Directions
Head north on Robertson Blvd. Turn left onto Ave 24 1/2. Continue west for about 1.5 miles Turn right onto Elm st.
Heating & Cooling
Window or Wall A/C
Laundry
Inside
Roofing
Other
Foundation
Wood Subfloor
Kitchen
Other
Primary Bedroom Level
Lower
Exterior
Metal
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
APN
027 121 007 000
Zoning
R-1
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
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 171000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 189000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 758 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1258 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` = 1682422 OR `props-main`.`id` = 1666056 OR `props-main`.`id` = 1636207 OR `props-main`.`id` = 1622929 OR `props-main`.`id` = 1684708 OR `props-main`.`id` = 1676842 OR `props-main`.`id` = 1666399 OR `props-main`.`id` = 1682679 OR `props-main`.`id` = 1676879 OR `props-main`.`id` = 1677234 OR `props-main`.`id` = 1676892 OR `props-main`.`id` = 1657994 OR `props-main`.`id` = 1658337 OR `props-main`.`id` = 1658342 OR `props-main`.`id` = 1622909 OR `props-main`.`id` = 1665818 OR `props-main`.`id` = 1680016 OR `props-main`.`id` = 1682293 OR `props-main`.`id` = 1675417 OR `props-main`.`id` = 1679079 OR `props-main`.`id` = 1680678 OR `props-main`.`id` = 1666308 OR `props-main`.`id` = 1656695 OR `props-main`.`id` = 1682621 OR `props-main`.`id` = 1682313 OR `props-main`.`id` = 1622790 OR `props-main`.`id` = 1636375 OR `props-main`.`id` = 1682427 OR `props-main`.`id` = 1666061 OR `props-main`.`id` = 1683219)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634059' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-17' 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 Jennifer Hernandez De La Cruz, Vylla Home, Inc. - jenniferhernandez973@gmail.com Last modified 1 month ago Fresno MLS last checked for updates 50 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.
