Estate & Letting Agents in Hanbury, Wychavon

Find Estate Agents in Hanbury, Wychavon
6 results
Compare Best Local Agents
Mccartneys LLP
Mccartneys LLP

Ludlow

Sales
3 active listings in Hanbury, Wychavon, Worcestershire, England
71 total
16-17 High Street, Ludlow, SY8 1BS
View Profile
Fine & Country
Fine & Country

Droitwich

Sales
2 active listings in Hanbury, Wychavon, Worcestershire, England
29 total
12 Victoria Square, Droitwich, WR9 8DS
View Profile
Andrew Grant
Andrew Grant

Covering the West Midlands

Lettings Sales
1 active listing in Hanbury, Wychavon, Worcestershire, England
276 total
Covering the West Midlands
View Profile
Homes by Victoria
Homes by Victoria

Redditch

Sales
1 active listing in Hanbury, Wychavon, Worcestershire, England
38 total
Office 29A, East Moons Moat Business Centre, Oxleasow Road, Redditch, B98 0RE
View Profile
Knight Frank
Knight Frank

Stratford Upon Avon

Sales
1 active listing in Hanbury, Wychavon, Worcestershire, England
137 total
Bridgeway, Stratford upon Avon, Warwickshire, CV37 6YX
View Profile
Oulsnam
Oulsnam

Droitwich

Sales
1 active listing in Hanbury, Wychavon, Worcestershire, England
86 total
Orchard House, 2 Victoria Square, Droitwich, WR9 8DS
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 = 'Hanbury, Wychavon'; 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":64622,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mccartneys LLP","email":"ludlow@mccartneys.co.uk","sales_phone_number":"01584 872153","address":"16-17 High Street,\r\nLudlow,\r\nSY8 1BS","postcode":"SY8 1BS","website_url":"https:\/\/www.mccartneys.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\/64622\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:41.000000Z","updated_at":"2026-01-20T19:55:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":64622,"agent_company_id":704,"branch_location":"Ludlow","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000064247B849AC105C06C21C841092F4A40","agent_brand_id":1186,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"16-17 High Street, Ludlow","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mccartneys LLP","branch_name":"Ludlow","lettings":false,"sales":true,"commercial":false,"h_email":"ludlow@mccartneys.co.uk","has_email":true,"h_phone":"01584 872153","has_phone":true,"resolved_brand_color":"#8d0d54","boundary_listing_count":"3","property_count":"71","latitude":52.36747,"longitude":-2.719533},{"core_branch_id":66578,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Fine \u0026 Country","email":"droitwich@fineandcountry.com","sales_phone_number":"024 7650 0058","address":"12 Victoria Square,\r\nDroitwich,\r\nWR9 8DS","postcode":"WR9 8DS","website_url":"https:\/\/www.fineandcountry.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66578\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:47.000000Z","updated_at":"2026-01-20T20:00:58.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66578,"agent_company_id":1154,"branch_location":"Droitwich","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003CC1FEEBDC3401C0F1D8CF6229224A40","agent_brand_id":1689,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12 Victoria Square, Droitwich","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Fine \u0026 Country","branch_name":"Droitwich","lettings":false,"sales":true,"commercial":false,"h_email":"droitwich@fineandcountry.com","has_email":true,"h_phone":"024 7650 0058","has_phone":true,"resolved_brand_color":"#9d8141","boundary_listing_count":"2","property_count":"29","latitude":52.266888,"longitude":-2.150812},{"core_branch_id":66893,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Andrew Grant","email":null,"sales_phone_number":"01905 734734","address":"Covering the West Midlands","postcode":null,"website_url":null,"description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66893\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:57.000000Z","updated_at":"2025-12-09T23:20:55.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66893,"agent_company_id":1213,"branch_location":"Covering the West Midlands","lettings_phone_number":"01905 734733","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":null,"agent_brand_id":1755,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":null,"has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Andrew Grant","branch_name":"Covering the West Midlands","lettings":true,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01905 734734","has_phone":true,"resolved_brand_color":"#aa1e32","boundary_listing_count":"1","property_count":"276","latitude":null,"longitude":null},{"core_branch_id":50530,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Homes by Victoria","email":null,"sales_phone_number":"01527 900771","address":"Office 29A,\r\nEast Moons Moat Business Centre,\r\nOxleasow Road,\r\nRedditch,\r\nB98 0RE","postcode":"B98 0RE","website_url":null,"description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50530\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:01.000000Z","updated_at":"2026-01-20T20:01:20.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50530,"agent_company_id":9713,"branch_location":"Redditch","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000FF93BF7B474DFEBF3FFD67CD8F274A40","agent_brand_id":10612,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 29A, East Moons Moat Business Centre, Oxleasow Road, Redditch","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Homes by Victoria","branch_name":"Redditch","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01527 900771","has_phone":true,"resolved_brand_color":"#15887b","boundary_listing_count":"1","property_count":"38","latitude":52.309076,"longitude":-1.893867},{"core_branch_id":53243,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Knight Frank","email":"info@knightfrank.co.uk","sales_phone_number":"01789 297735","address":"Bridgeway, \r\nStratford upon Avon,\r\nWarwickshire, \r\nCV37 6YX","postcode":"CV37 6YX","website_url":"https:\/\/www.knightfrank.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\/53243\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:30.000000Z","updated_at":"2026-01-20T20:00:04.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53243,"agent_company_id":146,"branch_location":"Stratford Upon Avon","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000DC114E0B5E34FBBFB0389CF9D5184A40","agent_brand_id":372,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Bridgeway, Stratford upon Avon, Warwickshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Knight Frank","branch_name":"Stratford Upon Avon","lettings":false,"sales":true,"commercial":false,"h_email":"info@knightfrank.co.uk","has_email":true,"h_phone":"01789 297735","has_phone":true,"resolved_brand_color":"#d2113e","boundary_listing_count":"1","property_count":"137","latitude":52.19403,"longitude":-1.700285},{"core_branch_id":66579,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Oulsnam","email":"droitwich@oulsnam.net","sales_phone_number":"01905 779229","address":"Orchard House, \r\n2 Victoria Square,\r\nDroitwich,\r\nWR9 8DS","postcode":"WR9 8DS","website_url":"https:\/\/www.oulsnam.net","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66579\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:47.000000Z","updated_at":"2026-01-20T20:00:58.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66579,"agent_company_id":1092,"branch_location":"Droitwich","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003CC1FEEBDC3401C0F1D8CF6229224A40","agent_brand_id":1622,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Orchard House, 2 Victoria Square, Droitwich","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Oulsnam","branch_name":"Droitwich","lettings":false,"sales":true,"commercial":false,"h_email":"droitwich@oulsnam.net","has_email":true,"h_phone":"01905 779229","has_phone":true,"resolved_brand_color":"#fe0203","boundary_listing_count":"1","property_count":"86","latitude":52.266888,"longitude":-2.150812}]; 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`; } } }