Diana has over 20 years of Experience and the most important thing about Real Estate is that, IT IS ALL ABOUT YOU !!
Call her Today to provide you with an Estimate of Value for your Home or give you a List of homes that match the Wish List !
*************************************************
Diana tiene mas de 20 años de Experiencia y lo mas importante del Comprar o Vender una casa (Eres Tu !!) Llamale Hoy para que te de un Estimado del Valor de tu Casa o te de una lista para Encontrarte Tu Casa
A: SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2026-08-04' AND (`props-main`.`City` LIKE '%Fresno%') 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`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-09' 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();
90
$850,000
3
2
2,102
0.55
1381 E Revere Rd
Fresno, CA 93720
$565,000
3
2
1,800
0.16
1341 E Via Corsica Pl
Fresno, CA 93730
$415,000
4
2
1,614
0.15
997 E Jolson Ave
Fresno, CA 93706
$315,000
3
1.75
1,092
0.14
2433 E Rialto Ave
Fresno, CA 93726
General Inquiries
Please provide the following information and Diana Monroy will assist you.
