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.
Working with Adriana & Orlando was truly an amazing experience from start to finish. They were incredibly knowledgeable, patient, and always available to answer my questions throughout the home-buying process. They made everything feel smooth and stress-free, guiding me every step of the way and always keeping my best interests in mind. Their dedication, professionalism, and genuine care made all the difference. I am so grateful for their help in finding our home and would highly recommend them to anyone looking to buy or sell! Karla Padilla
5.0
Orlando and Adriana are amazing. Orlando assured me every step of the way he was working for me and my best interest. They made the process easy for me. I appreciate both of their diligence during the home buying process and helping me buy my first home. Ivan Sevilla
Featured Listings
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2026-04-01' 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-04-06' 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();
75
$475,000
4
2.5
2,606
0.15
2111 N Forestiere Ave
Fresno, CA 93722
$470,000
5
3.5
2,428
0.14
3637 N Mccaffrey Ave
Fresno, CA 93722
$425,000
3
2
1,616
0.14
6361 N Bond St
Fresno, CA 93710
$365,000
3
2
1,619
0.15
1521 N College Ave
Fresno, CA 93728
General Inquiries
Please provide the following information and Orlando Hernandez will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
21122
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '21122'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '21122'