Buying or selling your home? Allow me to make your Real Estate transaction a pleasant and rewarding experience. Please contact me today. I look forward to working with you.
Realmente excellent los recommendamos un 💯 a todo personal gracias En especial a Sr Nelson que siempre estuvo en todo momento gracias Alma guerrero
5.0
Every step was very well taken and it was clearly presented to me; estimated value of my property, my pros and cons, quickly found buyer etc... I am very pleased to have come across Nelson. I will highly recommend Nelson and London Properties to everyone I know! Jesus B. Reynoso
5.0
Nelson and Frances were on top of the transaction and everything was smooth and easy. ECP, LP
5.0
Nelson was great to work with. He was always available to answer all my questions and followed up with everything. He is the best. Jesus Ibarra
5.0
They were very helpful. And they made it very easy. Monica
Featured Listings
A:SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2024-05-10' AND (`props-main`.`City` LIKE '%Kingsburg%') 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();
$1,000,000
3
1
1,840
9.25
13491 S Mendocino Ave
Kingsburg, CA 93631
$435,000
3
1.75
1,543
0.90
12708 E Clarkson Ave
Kingsburg, CA 93631
$349,000
3
2
1,220
0.14
1775 Morgan Dr
Kingsburg, CA 93631
$343,000
3
1.75
1,008
0.17
539 meadow Ln
Kingsburg, CA 93631
General Inquiries
Please provide the following information and Nelson Garibay will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
325
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '325'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '325'