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.
We chose London Properties because of their stellar reputation in the industry. They did not disappoint. Our agent, Stacey Simons, was the perfect representative of their commitment to diligence, creativity, honesty, commitment and professionalism. Our home was not an easy property to market. Stacey consistently presented it for a whole year with energy and fresh approaches. We would have to give Stacey at least 7 stars and thank her and her associates for spectacular and professional service and, now. their friendship!! Kristan and Ed O.
5.0
Stacey Simons is the best. Anonymous
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();
84
$514,999
5
3.25
2,442
0.12
5566 W Farrin Ave
Fresno, CA 93722
$459,999
4
2
1,714
0.15
5221 E Byrd Ave
Fresno, CA 93725
$305,000
4
2
1,900
0.17
1923 W Pontiac
Fresno, CA 93705
$249,990
2
2
1,044
0.17
4571 E Fountain Way
Fresno, CA 93726
General Inquiries
Please provide the following information and Stacey Simons will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
15726
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '15726'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '15726'