When buying or selling a home, you deserve knowing that your needs are met. You have a busy life and I allow you to live it. So, let me take away the worry and problems, and provide the comfort in knowing that your best interest lies first.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2026-03-24' AND (`props-main`.`City` LIKE '%Clovis%') 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-04-03' 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();
45
$725,000
4
2
2,910
0.17
1124 Oak Ave
Clovis, CA 93611
$619,000
4
3
2,303
0.18
1055 Agua Dulce Ave
Clovis, CA 93619
$550,000
4
2
1,952
0.17
22 N Bliss
Clovis, CA 93611
$405,000
3
2.5
1,560
0.07
3037 Roche Ln
Clovis, CA 93619
General Inquiries
Please provide the following information and Stephanie Kelly will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
137
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '137'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '137'