Beautiful corner-lot home located in SelmaThis home features 4 bedrooms and 3 bathrooms with a open floor plan perfect for comfortable living and entertaining. The kitchen offers granite countertops, a breakfast bar, and a cozy breakfast nook that opens to the living room area. Downstairs includes a guest bedroom and full bathroom, idea for visitors or multi-generational living. Upstairs features 3 bedrooms and 2 bathrooms. The spacious primary suite includes a walk-in closet, double vanity sinks, a soaking tub, and a separate shower. Step outside to a very spacious backyard complete with a huge swimming pool perfect for those hot summer days, plus equipped solar for added energy efficiency.Call today schedule your private appointment.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 455050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 502950 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) >= 1711 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2211 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` = 234519 OR `props-main`.`id` = 1724805 OR `props-main`.`id` = 1721863 OR `props-main`.`id` = 1701356 OR `props-main`.`id` = 52453 OR `props-main`.`id` = 1717609 OR `props-main`.`id` = 1719501 OR `props-main`.`id` = 1720768 OR `props-main`.`id` = 1712358 OR `props-main`.`id` = 1723250 OR `props-main`.`id` = 1722570 OR `props-main`.`id` = 1722569 OR `props-main`.`id` = 1720682 OR `props-main`.`id` = 1683279 OR `props-main`.`id` = 1683285 OR `props-main`.`id` = 1702437 OR `props-main`.`id` = 1713867 OR `props-main`.`id` = 1698132 OR `props-main`.`id` = 1718530 OR `props-main`.`id` = 1725272 OR `props-main`.`id` = 1722399 OR `props-main`.`id` = 1705140 OR `props-main`.`id` = 1723686 OR `props-main`.`id` = 1723703 OR `props-main`.`id` = 1720393 OR `props-main`.`id` = 1720402 OR `props-main`.`id` = 1721855 OR `props-main`.`id` = 1726342 OR `props-main`.`id` = 1717936 OR `props-main`.`id` = 1724493 OR `props-main`.`id` = 1720434 OR `props-main`.`id` = 1718285 OR `props-main`.`id` = 1718281 OR `props-main`.`id` = 1718284 OR `props-main`.`id` = 1718295 OR `props-main`.`id` = 1720641 OR `props-main`.`id` = 1718303 OR `props-main`.`id` = 1704081 OR `props-main`.`id` = 177063 OR `props-main`.`id` = 1720422 OR `props-main`.`id` = 1719098 OR `props-main`.`id` = 1713611 OR `props-main`.`id` = 1665865 OR `props-main`.`id` = 1713859)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648602' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-11' 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
$495,000
5
3
1,800
0.14
2221 Floral Ave
Selma, CA 93662
Courtesy of Brenda Valdez, 3D Realty - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 19 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.
