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.
Cheyenne treated us like family the entire time we were looking for a house. She kept all things in consideration for what we were looking for and did a fabulous job. We were urgently searching for a house, and she pulled every string she could to say the least. Cheyenne is not only an amazing professional in her career, but she is also an amazing person that God blessed us with in our search for a home. We couldn't be anymore thankful for everything she did for us. I'm sure she had many sleepless nights trying her hardest to find us a home. This was our first home we bought, and she did such an amazing job that this might just be our forever home. Cheyenne, thank you a million times over and may God bless you and your family for eternity. Hannah Vaughn
Featured Listings
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE `props-main`.`ListingDate` >= '2025-10-13' 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` >= '2025-10-18' 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();
87
$629,950
3
2.5
2,380
0.35
6067 N Teilman Ave
Fresno, CA 93711
$625,000
4
3.5
3,040
0.15
6646 W Beechwood Ave W
Fresno, CA 93722
$389,950
3
3
1,348
0.14
5625 W Swift Ave
Fresno, CA 93722
$380,000
3
1
1,388
0.37
5588 E National Ave
Fresno, CA 93727
General Inquiries
Please provide the following information and Cheyenne Amberg will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
20487
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '20487'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '20487'