Welcome to 2086 Mitchell Ave in Selma! This well-maintained home offers a functional floor plan and several updates throughout. Recent improvements include a new roof installed 2024, a newly poured concrete patio and side yard, and automatic front and rear sprinkler systems for convenient landscape irrigation. The spacious backyard offers plenty of room for outdoor entertaining, gardening, or future customization. Ideally located with convenient access to Highways 99 and 43, this property provides easy commuting throughout the Central Valley. Enjoy being just minutes from Selma Plaza, Selma Square, downtown Selma, grocery stores, restaurants, and everyday conveniences. The home is also located near Eric White Elementary School and other local schools, making it an excellent location for a variety of lifestyles.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1994
Year Built Source
Public Records
Days On London
31
Cumulative Days On London
31
County
Fresno
Property Condition
Updated/Remodeled
New Construction
No
Stories
1
Current Use
Residential
Directions to Property
Turn on to Nebraska from the 43 and then turn on to Mitchell home is located on right side.
Roof
Shingle
Heating
Central
Cooling
Ceiling Fan(s), Central Air
Direction Faces
Northwest
Bathrooms Total (Integer)
2
Full Baths
1.5
Three Quarter Baths
2
Appliances
6 Burner Stove,Built-In Range,Dishwasher,Exhaust Fan
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 1108 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1608 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` = 1725066 OR `props-main`.`id` = 1692017 OR `props-main`.`id` = 1762522 OR `props-main`.`id` = 1690491 OR `props-main`.`id` = 234519 OR `props-main`.`id` = 1749837 OR `props-main`.`id` = 1756055 OR `props-main`.`id` = 1770371 OR `props-main`.`id` = 1746127 OR `props-main`.`id` = 52453 OR `props-main`.`id` = 1727953 OR `props-main`.`id` = 1766160 OR `props-main`.`id` = 1757042 OR `props-main`.`id` = 1755767 OR `props-main`.`id` = 1717609 OR `props-main`.`id` = 1719501 OR `props-main`.`id` = 1760172 OR `props-main`.`id` = 1759376 OR `props-main`.`id` = 1720768 OR `props-main`.`id` = 1749705 OR `props-main`.`id` = 1723250 OR `props-main`.`id` = 1755439 OR `props-main`.`id` = 1722569 OR `props-main`.`id` = 1763932 OR `props-main`.`id` = 1766790 OR `props-main`.`id` = 1702437 OR `props-main`.`id` = 1754395 OR `props-main`.`id` = 1761184 OR `props-main`.`id` = 1713867 OR `props-main`.`id` = 1770273 OR `props-main`.`id` = 1735504 OR `props-main`.`id` = 1741649 OR `props-main`.`id` = 1769210 OR `props-main`.`id` = 1726342 OR `props-main`.`id` = 1762414 OR `props-main`.`id` = 1762415 OR `props-main`.`id` = 1731793 OR `props-main`.`id` = 1762095 OR `props-main`.`id` = 1717936 OR `props-main`.`id` = 1756968 OR `props-main`.`id` = 1763739 OR `props-main`.`id` = 1760885 OR `props-main`.`id` = 1758778 OR `props-main`.`id` = 1761409 OR `props-main`.`id` = 1761407 OR `props-main`.`id` = 177063 OR `props-main`.`id` = 1761706)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243754' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-01' 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();
1
Similar Properties
$384,900
3
2
1,554
0.17
2841 C St
Selma, CA 93662
Courtesy of Isaiah Corpus, Park Place Real Estate
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.
