Estate & Letting Agents in Tilton on the Hill and Halstead, Harborough

Find Estate Agents in Tilton on the Hill and Halstead, Harborough
5 results
Alexanders

East Midlands

Sales
2 active listings in Tilton on the Hill and Halstead, Harborough, Leicestershire, England
39 total
21 Market Place, Melton Mowbray, LE13 1XD
View Profile
Fine & Country

Leicester

Sales
2 active listings in Tilton on the Hill and Halstead, Harborough, Leicestershire, England
42 total
38 The Parade, Oadby, Leicester, LE2 5BF
View Profile
Andrew Granger

Market Harborough

Sales
1 active listing in Tilton on the Hill and Halstead, Harborough, Leicestershire, England
56 total
Phoenix House, 52 High Street, Market Harborough, LE16 7AF
View Profile
James Sellicks Estate Agents
1 active listing in Tilton on the Hill and Halstead, Harborough, Leicestershire, England
51 total
6-8 Market Place, Oakham, LE15 6DT
View Profile
James Sellicks Estate Agents

Market Harborough

Sales
1 active listing in Tilton on the Hill and Halstead, Harborough, Leicestershire, England
71 total
13 Church Street, Market Harborough, LE16 7AA
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 = 'Tilton on the Hill and Halstead, Harborough'; 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":57486,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Alexanders","email":"melton@alexanders-estates.com","sales_phone_number":"01664 896332","address":"21 Market Place,\r\nMelton Mowbray,\r\nLE13 1XD","postcode":"LE13 1XD","website_url":"https:\/\/alexanders-estates.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57486\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:50.000000Z","updated_at":"2026-01-20T20:01:01.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57486,"agent_company_id":7402,"branch_location":"East Midlands","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BEFA78E8BB5BECBF1BA19FA9D7614A40","agent_brand_id":8246,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21 Market Place, Melton Mowbray","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alexanders","branch_name":"East Midlands","lettings":false,"sales":true,"commercial":false,"h_email":"melton@alexanders-estates.com","has_email":true,"h_phone":"01664 896332","has_phone":true,"resolved_brand_color":"#3782be","boundary_listing_count":"2","property_count":"39","latitude":52.764394,"longitude":-0.886198},{"core_branch_id":57566,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Fine \u0026 Country","email":"3452@leaddrop.uk.rexsoftware.com","sales_phone_number":"0116 296 7777","address":"38 The Parade,\r\nOadby,\r\nLeicester,\r\nLE2 5BF","postcode":"LE2 5BF","website_url":"http:\/\/www.fineandcountry.com\/uk\/leicester","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57566\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:53.000000Z","updated_at":"2026-01-20T19:59:28.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57566,"agent_company_id":7033,"branch_location":"Leicester","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E0D572672658F1BF32755776C14C4A40","agent_brand_id":7872,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"38 The Parade, Oadby, Leicester","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Fine \u0026 Country","branch_name":"Leicester","lettings":false,"sales":true,"commercial":false,"h_email":"3452@leaddrop.uk.rexsoftware.com","has_email":true,"h_phone":"0116 296 7777","has_phone":true,"resolved_brand_color":"#9d8141","boundary_listing_count":"2","property_count":"42","latitude":52.599654,"longitude":-1.084021},{"core_branch_id":57505,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Andrew Granger","email":"sales@andrewgranger.co.uk","sales_phone_number":"01858 431315","address":"Phoenix House, \r\n52 High Street,\r\nMarket Harborough,\r\nLE16 7AF","postcode":"LE16 7AF","website_url":"http:\/\/www.andrewgranger.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\/57505\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:51.000000Z","updated_at":"2026-01-20T19:53:39.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57505,"agent_company_id":315,"branch_location":"Market Harborough","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000031B610E4A084EDBF67B45549643D4A40","agent_brand_id":634,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Phoenix House, 52 High Street, Market Harborough","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Andrew Granger","branch_name":"Market Harborough","lettings":false,"sales":true,"commercial":false,"h_email":"sales@andrewgranger.co.uk","has_email":true,"h_phone":"01858 431315","has_phone":true,"resolved_brand_color":"#163272","boundary_listing_count":"1","property_count":"56","latitude":52.479623,"longitude":-0.92244},{"core_branch_id":57494,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"James Sellicks Estate Agents","email":"Oakham@jamessellicks.com","sales_phone_number":"01572 724437","address":"6-8 Market Place,\r\nOakham,\r\nLE15 6DT","postcode":"LE15 6DT","website_url":"http:\/\/www.jamessellicks.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57494\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:50.000000Z","updated_at":"2026-01-20T20:01:01.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57494,"agent_company_id":320,"branch_location":"Oakham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E8A562635E47E7BF734A404CC2554A40","agent_brand_id":642,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"6-8 Market Place, Oakham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"James Sellicks Estate Agents","branch_name":"Oakham","lettings":false,"sales":true,"commercial":false,"h_email":"Oakham@jamessellicks.com","has_email":true,"h_phone":"01572 724437","has_phone":true,"resolved_brand_color":"#004055","boundary_listing_count":"1","property_count":"51","latitude":52.669992,"longitude":-0.727462},{"core_branch_id":57504,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"James Sellicks Estate Agents","email":"info@jamessellicks.com","sales_phone_number":"01858 410008","address":"13 Church Street,\r\nMarket Harborough,\r\nLE16 7AA","postcode":"LE16 7AA","website_url":"https:\/\/www.jamessellicks.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57504\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:51.000000Z","updated_at":"2026-01-20T19:59:27.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57504,"agent_company_id":320,"branch_location":"Market Harborough","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C971A774B07EEDBF4C1AA375543D4A40","agent_brand_id":642,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"13 Church Street, Market Harborough","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"James Sellicks Estate Agents","branch_name":"Market Harborough","lettings":false,"sales":true,"commercial":false,"h_email":"info@jamessellicks.com","has_email":true,"h_phone":"01858 410008","has_phone":true,"resolved_brand_color":"#004055","boundary_listing_count":"1","property_count":"71","latitude":52.47914,"longitude":-0.921715}]; 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`; } } }