"Meta Title" is the name of your page in search results. Try to incorporate your most important keywords, but keep it short.
"Meta Description" is the block of text that appears below your site on search results. The search engine will cut it off after so many characters, so it's best to keep it short, focus on the most important information, and include key search terms you want people to use to find you.
"Meta Keywords" is a list of key search terms you expect people to use to find your site. They are a hidden part of your site's source code, so they don't have to look attractive. Separate keywords with commas.
Born and raised in the Central Valley, Lorelei grew up in a California Craftsman-style Bungalow on Historic Huntington Blvd. She attended Roosevelt Performing Arts High School and studied at UC Santa Cruz, Fresno City College, Fresno State and UC Davis. After college, Lorelei lived in the Historic Midtown District in Sacramento, CA, where she worked at the State Capitol as the Editor of a Legislative Affairs Newspaper. Before returning home to the Central Valley, Lorelei lived in the highly-acclaimed historic city of Charleston, SC where she was an entrepreneur and managed several businesses including: Terrace Gardens Fine Landscape Design, Prestige Properties of Charleston, and Charleston Luxury Retreats, a luxury vacation rental home business. In addition, Lorelei has extensive experience investing in real estate, renovating historic homes, remodeling homes for highest resale value, and managing new home construction.
FEATURED LISTINGS
72129
SELECT * FROM `lpdotcom`.`props-main` WHERE ((`props-main`.`MLNumber` LIKE '%93702%' OR `props-main`.`StreetNumber` LIKE '%93702%' OR `props-main`.`StreetName` LIKE '%93702%' OR `props-main`.`City` LIKE '%93702%' OR `props-main`.`ZipCode` LIKE '%93702%') OR (`props-main`.`MLNumber` LIKE '%93704%' OR `props-main`.`StreetNumber` LIKE '%93704%' OR `props-main`.`StreetName` LIKE '%93704%' OR `props-main`.`City` LIKE '%93704%' OR `props-main`.`ZipCode` LIKE '%93704%') OR (`props-main`.`MLNumber` LIKE '%93711%' OR `props-main`.`StreetNumber` LIKE '%93711%' OR `props-main`.`StreetName` LIKE '%93711%' OR `props-main`.`City` LIKE '%93711%' OR `props-main`.`ZipCode` LIKE '%93711%') OR (`props-main`.`MLNumber` LIKE '%93619%' OR `props-main`.`StreetNumber` LIKE '%93619%' OR `props-main`.`StreetName` LIKE '%93619%' OR `props-main`.`City` LIKE '%93619%' OR `props-main`.`ZipCode` LIKE '%93619%') OR (`props-main`.`MLNumber` LIKE '%93612%' OR `props-main`.`StreetNumber` LIKE '%93612%' OR `props-main`.`StreetName` LIKE '%93612%' OR `props-main`.`City` LIKE '%93612%' OR `props-main`.`ZipCode` LIKE '%93612%') OR (`props-main`.`MLNumber` LIKE '%93611%' OR `props-main`.`StreetNumber` LIKE '%93611%' OR `props-main`.`StreetName` LIKE '%93611%' OR `props-main`.`City` LIKE '%93611%' OR `props-main`.`ZipCode` LIKE '%93611%')) AND (`props-main`.`City` LIKE '%Fresno%' OR `props-main`.`City` LIKE '%Clovis%') AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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();
D: SELECT * FROM `lpdotcom`.`props-main` WHERE ((`props-main`.`MLNumber` LIKE '%93702%' OR `props-main`.`StreetNumber` LIKE '%93702%' OR `props-main`.`StreetName` LIKE '%93702%' OR `props-main`.`City` LIKE '%93702%' OR `props-main`.`ZipCode` LIKE '%93702%') OR (`props-main`.`MLNumber` LIKE '%93704%' OR `props-main`.`StreetNumber` LIKE '%93704%' OR `props-main`.`StreetName` LIKE '%93704%' OR `props-main`.`City` LIKE '%93704%' OR `props-main`.`ZipCode` LIKE '%93704%') OR (`props-main`.`MLNumber` LIKE '%93711%' OR `props-main`.`StreetNumber` LIKE '%93711%' OR `props-main`.`StreetName` LIKE '%93711%' OR `props-main`.`City` LIKE '%93711%' OR `props-main`.`ZipCode` LIKE '%93711%') OR (`props-main`.`MLNumber` LIKE '%93619%' OR `props-main`.`StreetNumber` LIKE '%93619%' OR `props-main`.`StreetName` LIKE '%93619%' OR `props-main`.`City` LIKE '%93619%' OR `props-main`.`ZipCode` LIKE '%93619%') OR (`props-main`.`MLNumber` LIKE '%93612%' OR `props-main`.`StreetNumber` LIKE '%93612%' OR `props-main`.`StreetName` LIKE '%93612%' OR `props-main`.`City` LIKE '%93612%' OR `props-main`.`ZipCode` LIKE '%93612%') OR (`props-main`.`MLNumber` LIKE '%93611%' OR `props-main`.`StreetNumber` LIKE '%93611%' OR `props-main`.`StreetName` LIKE '%93611%' OR `props-main`.`City` LIKE '%93611%' OR `props-main`.`ZipCode` LIKE '%93611%')) AND (`props-main`.`City` LIKE '%Fresno%' OR `props-main`.`City` LIKE '%Clovis%') AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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();
