XML Sitemaps (for Search Engines)
Main Pages
Service Pages
Blog
Case Studies
Real Estate Lead Generation
- Real Estate Lead Generation
query("SHOW TABLES LIKE 'city_real_estate_data'");
if ($tableCheck && $tableCheck->num_rows > 0) {
$cityData = dbFetchAll("SELECT city_slug, city_name FROM city_real_estate_data WHERE status = 'active' ORDER BY city_name ASC");
foreach ($cityData as $city) {
$realEstateCities[] = ['slug' => $city['city_slug'], 'title' => $city['city_name'] ?? $city['city_slug']];
$addedCitySlugs[$city['city_slug']] = true;
}
}
} catch (Exception $e) {
// Table doesn't exist - continue
}
try {
$pagesFromPages = dbFetchAll("SELECT slug, title FROM pages WHERE status = 'published' AND slug LIKE 'real-estate-lead-generation-%' ORDER BY slug ASC");
foreach ($pagesFromPages as $cityPage) {
$citySlug = str_replace('real-estate-lead-generation-', '', $cityPage['slug']);
if (isset($addedCitySlugs[$citySlug])) continue;
$realEstateCities[] = ['slug' => $cityPage['slug'], 'title' => $cityPage['title'] ?? $citySlug];
}
} catch (Exception $e) {
// Query failed - continue
}
foreach ($realEstateCities as $city): ?>
Policy Pages
Other Pages