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.
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
5.0
Everything went very well, Nelson Garibay did a very good job in explaining and keeping us informed of the process, very professional. The house was sold very fast, and everything went well, no issues came up, the whole process went by fast. Very pleased with his service. Carlos and Maria Moreno
Featured Listings
SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2023-05-26' 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` >= '2023-05-31' 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();
$550,000
3
2.5
2,436
0.29
5248 N Briarwood Ave
Fresno, CA 93711
$550,000
4
2
2,447
0.27
2379 S Rabe Ave
Fresno, CA 93727
$449,000
2
1.75
2,358
0.31
6737 N Pleasant Ave
Fresno, CA 93711
$288,800
2
1
1,125
0.17
1204 W Fedora Ave
Fresno, CA 93705
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'