Estate & Letting Agents in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester

Find Estate Agents in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester
5 results
Compare Best Local Agents
Beresford Adams
Beresford Adams

Chester

Lettings Sales
2 active listings in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester, England
192 total
1-3 Friarsgate Grosvenor Street Chester CH1 1XG
View Profile
Gascoigne Halman
Gascoigne Halman

Frodsham

Sales
1 active listing in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester, England
157 total
Pollard Buildings, 1b, Church St, Frodsham WA6 7DW
View Profile
Rostons
Rostons

Hatton Heath

Sales
1 active listing in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester, England
43 total
West View House Whitchurch Road, Hatton Heath, CH3 9AU
View Profile
Storeys of Cheshire
Storeys of Cheshire

Cheshire

Sales
1 active listing in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester, England
88 total
56C High Street Tarporley CW6 0AG
View Profile
Yopa
Yopa

Nationwide

Sales
1 active listing in Dunham-on-the-Hill and Hapsford, Cheshire West and Chester, England
7,222 total
Meridian House Wheatfield Way Hinckley LE10 1YG
View Profile
initializeAllPremierCards() }); // Load detailed stats function function loadDetailedStats() { const button = document.getElementById('load-more-stats'); const statsContainer = document.getElementById('detailed-stats'); if (statsContainer.classList.contains('hidden')) { // Show loading state button.innerHTML = ` Loading... `; // Make AJAX call for detailed stats const location = 'Dunham-on-the-Hill and Hapsford, Cheshire West and Chester'; const agentType = ''; fetch(`/api/agents/detailed-stats?location=${encodeURIComponent(location)}&type=${agentType}`) .then(response => response.json()) .then(data => { // Build detailed stats HTML let statsHtml = '
'; // Property types breakdown if (data.propertyTypes && Object.keys(data.propertyTypes).length > 0) { statsHtml += `
Property Types
`; for (const [type, count] of Object.entries(data.propertyTypes)) { const percentage = Math.round((count / data.totalProperties) * 100); statsHtml += `
${type}: ${count.toLocaleString()} (${percentage}%)
`; } statsHtml += '
'; } // Price ranges if (data.priceRanges) { statsHtml += `
Price Ranges
Avg Sale Price: £${data.priceRanges.avgSalePrice?.toLocaleString() || 'N/A'}
Avg Rent PCM: £${data.priceRanges.avgRentPrice?.toLocaleString() || 'N/A'}
`; } // Top performing agents if (data.topAgents && data.topAgents.length > 0) { statsHtml += `
Top Agents
`; data.topAgents.slice(0, 3).forEach(agent => { statsHtml += `
${agent.name}: ${agent.property_count} props
`; }); statsHtml += '
'; } statsHtml += '
'; // Show stats statsContainer.innerHTML = statsHtml; statsContainer.classList.remove('hidden'); // Update button button.innerHTML = ` Hide Insights `; }) .catch(error => { // If API fails, show some calculated stats from existing data const agents = [{"core_branch_id":52352,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Beresford Adams","email":"chester@beresfordadamscountrywide.co.uk","sales_phone_number":"01244 345345","address":"1-3 \r\nFriarsgate\r\nGrosvenor Street\r\nChester\r\nCH1 1XG","postcode":"CH1 1XG","website_url":"http:\/\/www.beresfordadams.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52352\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:00.000000Z","updated_at":"2026-01-20T19:59:34.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52352,"agent_company_id":51,"branch_location":"Chester","lettings_phone_number":"01244 345360","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000910C39B69E2107C0DB4C857824984A40","agent_brand_id":149,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1-3, Friarsgate, Grosvenor Street, Chester","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Beresford Adams","branch_name":"Chester","lettings":true,"sales":true,"commercial":false,"h_email":"chester@beresfordadamscountrywide.co.uk","has_email":true,"h_phone":"01244 345345","has_phone":true,"resolved_brand_color":"#0164af","boundary_listing_count":"2","property_count":"192","latitude":53.188613,"longitude":-2.891416},{"core_branch_id":66214,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Gascoigne Halman","email":"frodsham@gascoignehalman.co.uk","sales_phone_number":"01928 739777","address":"Pollard Buildings, 1b, Church St, Frodsham WA6 7DW","postcode":"WA6 7DW","website_url":"https:\/\/www.gascoignehalman.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66214\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:35.000000Z","updated_at":"2026-01-20T19:55:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66214,"agent_company_id":399,"branch_location":"Frodsham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000431EC18D94CD05C0EF71A609DBA54A40","agent_brand_id":758,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Pollard Buildings, 1b, Church St, Frodsham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Gascoigne Halman","branch_name":"Frodsham","lettings":false,"sales":true,"commercial":false,"h_email":"frodsham@gascoignehalman.co.uk","has_email":true,"h_phone":"01928 739777","has_phone":true,"resolved_brand_color":"#fe4030","boundary_listing_count":"1","property_count":"157","latitude":53.295747,"longitude":-2.725381},{"core_branch_id":52391,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Rostons","email":"info@rostons.co.uk","sales_phone_number":"01829 773000","address":"West View House Whitchurch Road,\r\nHatton Heath,\r\nCH3 9AU","postcode":"CH3 9AU","website_url":"https:\/\/rostons.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52391\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:01.000000Z","updated_at":"2026-01-20T19:59:36.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52391,"agent_company_id":212,"branch_location":"Hatton Heath","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000904946CEC27E06C00BB8E7F9D3924A40","agent_brand_id":489,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"West View House Whitchurch Road, Hatton Heath","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Rostons","branch_name":"Hatton Heath","lettings":false,"sales":true,"commercial":false,"h_email":"info@rostons.co.uk","has_email":true,"h_phone":"01829 773000","has_phone":true,"resolved_brand_color":"#050a2d","boundary_listing_count":"1","property_count":"43","latitude":53.147094,"longitude":-2.811895},{"core_branch_id":53352,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Storeys of Cheshire","email":"selling@storeyestates.co.uk","sales_phone_number":"01606 339922","address":"56C High Street\r\nTarporley\r\nCW6 0AG","postcode":"CW6 0AG","website_url":"http:\/\/www.storeysofcheshire.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/53352\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:33.000000Z","updated_at":"2026-01-20T20:00:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53352,"agent_company_id":6554,"branch_location":"Cheshire","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001D39D219185905C061527C7C42944A40","agent_brand_id":7381,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"56C High Street, Tarporley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Storeys of Cheshire","branch_name":"Cheshire","lettings":false,"sales":true,"commercial":false,"h_email":"selling@storeyestates.co.uk","has_email":true,"h_phone":"01606 339922","has_phone":true,"resolved_brand_color":"#4d5a4e","boundary_listing_count":"1","property_count":"88","latitude":53.158279,"longitude":-2.668503},{"core_branch_id":57439,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Yopa","email":"aimee.boston@yopa.co.uk","sales_phone_number":"01923 381187","address":"Meridian House\r\nWheatfield Way\r\nHinckley\r\nLE10 1YG","postcode":"LE10 1YG","website_url":"https:\/\/www.yopa.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57439\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:48.000000Z","updated_at":"2026-01-20T19:57:00.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57439,"agent_company_id":8351,"branch_location":"Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000029EB3713D305F6BFF52A323A20474A40","agent_brand_id":9221,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Meridian House, Wheatfield Way, Hinckley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Yopa","branch_name":"Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"aimee.boston@yopa.co.uk","has_email":true,"h_phone":"01923 381187","has_phone":true,"resolved_brand_color":"#56c5cd","boundary_listing_count":"1","property_count":"7222","latitude":52.555671,"longitude":-1.376422}]; let topAgents = []; agents.forEach(agent => { // Collect top agents if (agent.property_count > 0) { topAgents.push({ name: agent.name, property_count: agent.property_count }); } }); // Sort top agents topAgents.sort((a, b) => b.property_count - a.property_count); let statsHtml = '
'; // Show top agents if (topAgents.length > 0) { statsHtml += `
Top Performing Agents
`; topAgents.slice(0, 5).forEach(agent => { statsHtml += `
${agent.name}: ${agent.property_count} properties
`; }); statsHtml += '
'; } statsHtml += '
'; statsContainer.innerHTML = statsHtml; statsContainer.classList.remove('hidden'); button.innerHTML = ` Hide Insights `; }); } else { // Hide stats statsContainer.classList.add('hidden'); button.innerHTML = ` Load Detailed Insights `; } } // Open agent map function function openAgentMap(locationSlug) { // Use the floating view toggle button const mapBtn = document.getElementById('agent-view-map'); if (mapBtn) { mapBtn.click(); } else { // Fallback to old button const oldMapBtn = document.getElementById('view-map-btn'); if (oldMapBtn) { oldMapBtn.click(); } else { // Last resort - open map page window.location.href = `/agents/${locationSlug}/map`; } } }