Fresno Real Estate Investment Sales

FEATURED LISTINGS

SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 150000 AND (`props-main`.`City` LIKE '%fresno%' OR `props-main`.`City` LIKE '%clovis%') AND (((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Duplex' OR `props-main`.`PropertySubtype2` = 'Duplex' OR `props-main`.`PropertySubtype3` = 'Duplex' OR `NumberUnits` = 2)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Triplex' OR `props-main`.`PropertySubtype2` = 'Triplex' OR `props-main`.`PropertySubtype3` = 'Triplex' OR `NumberUnits` = 3)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Four Plex' OR `props-main`.`PropertySubtype2` = 'Four Plex' OR `props-main`.`PropertySubtype3` = 'Four Plex' OR `props-main`.`PropertySubtype1` = 'Fourplex' OR `props-main`.`PropertySubtype2` = 'Fourplex' OR `props-main`.`PropertySubtype3` = 'Fourplex' OR `NumberUnits` = 4)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = '11 Units & More' OR `props-main`.`PropertySubtype2` = '11 Units & More' OR `props-main`.`PropertySubtype3` = '11 Units & More' OR `props-main`.`PropertySubtype1` = '5 or More Units' OR `props-main`.`PropertySubtype2` = '5 or More Units' OR `props-main`.`PropertySubtype3` = '5 or More Units' OR `props-main`.`PropertySubtype1` = '5 to 10 Units' OR `props-main`.`PropertySubtype2` = '5 to 10 Units' OR `props-main`.`PropertySubtype3` = '5 to 10 Units' OR `props-main`.`PropertySubtype1` = 'Apartments' OR `props-main`.`PropertySubtype2` = 'Apartments' OR `props-main`.`PropertySubtype3` = 'Apartments' OR `NumberUnits` >= 5))) AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-14' 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();

B: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 150000 AND (`props-main`.`City` LIKE '%fresno%' OR `props-main`.`City` LIKE '%clovis%') AND (((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Duplex' OR `props-main`.`PropertySubtype2` = 'Duplex' OR `props-main`.`PropertySubtype3` = 'Duplex' OR `NumberUnits` = 2)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Triplex' OR `props-main`.`PropertySubtype2` = 'Triplex' OR `props-main`.`PropertySubtype3` = 'Triplex' OR `NumberUnits` = 3)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Four Plex' OR `props-main`.`PropertySubtype2` = 'Four Plex' OR `props-main`.`PropertySubtype3` = 'Four Plex' OR `props-main`.`PropertySubtype1` = 'Fourplex' OR `props-main`.`PropertySubtype2` = 'Fourplex' OR `props-main`.`PropertySubtype3` = 'Fourplex' OR `NumberUnits` = 4)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = '11 Units & More' OR `props-main`.`PropertySubtype2` = '11 Units & More' OR `props-main`.`PropertySubtype3` = '11 Units & More' OR `props-main`.`PropertySubtype1` = '5 or More Units' OR `props-main`.`PropertySubtype2` = '5 or More Units' OR `props-main`.`PropertySubtype3` = '5 or More Units' OR `props-main`.`PropertySubtype1` = '5 to 10 Units' OR `props-main`.`PropertySubtype2` = '5 to 10 Units' OR `props-main`.`PropertySubtype3` = '5 to 10 Units' OR `props-main`.`PropertySubtype1` = 'Apartments' OR `props-main`.`PropertySubtype2` = 'Apartments' OR `props-main`.`PropertySubtype3` = 'Apartments' OR `NumberUnits` >= 5))) AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-14' 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();

$699,950 8 BD | 8 BA
3779 N Abby St
Fresno, CA 93726

$350,000 2 BD | 2 BA
712 W Hammond Ave
Fresno, CA 93728

$344,900 3 BD | 2 BA
2901 E Olive Ave
Fresno, CA 93701

$297,000 4 BD | 2 BA
272 274 W Pinedale Ave
Fresno, CA 93650

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Quick Search