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-31' 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-09-05' 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();
94
$649,000
3
3
2,607
0.28
7138 W Browning Ave
Fresno, CA 93723
$629,950
5
2
2,250
0.29
1770 W San Jose Ave
Fresno, CA 93711
$376,000
3
1.75
1,600
0.17
3517 E Lamona Ave
Fresno, CA 93703
$300,000
3
2
1,367
0.46
3705 3707 E Iowa Ave
Fresno, CA 93702
General Inquiries
Please provide the following information and Diana Monroy will assist you.
