Buying or selling your home is an involved process. It is one of the most important decisions you will ever make, personally and financially. In any Real Estate venture, you need someone you can trust and rely on to meet your needs.
As your personal Real Estate Agent, I will help guide you through the process successfully. My promise is to offer quality service, integrity and professionalism in every step of the transaction. We have ‘One Stop Shopping’, Mortgage, Insurance, and Marketing. If you or someone you know are in need of Real Estate services of any kind, please feel free to contact me.
Hola mi nombre es José A Luna Mi experiencia con el ajente jesus López Me dio un buen trato se comunicaba con migo contante mente para tenerme al pendiente de lo que pasaba la berda quede muy sastisfecho con su trabajo 100% lo recomendaría una persona q sabe tratar alos clientes y q le resuelve cualquier duda que tengamos Gracias A Jesús López Por su trabajo que iso para mi y mi familia Jose A Luna Torres
Featured Listings
A:SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2024-05-15' 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` >= '2024-05-20' 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();
$799,800
4
3
2,835
0.21
2088 El Paso Ave
Clovis, CA 93611
$675,000
3
2
2,389
0.18
1670 N Filbert Ave
Clovis, CA 93619
$525,000
3
2.5
1,744
0.17
917 N Chapel HIll Ave
Clovis, CA 93611
$424,999
3
2.75
1,372
0.06
3915 Harlan Ranch Blvd
Clovis, CA 93619
General Inquiries
Please provide the following information and Jesus Lopez will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
29782
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '29782'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '29782'