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

Find Estate Agents in Tilton on the Hill and Halstead, Harborough
5 results
Compare Best Local Agents
Alexanders
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
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
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
James Sellicks Estate Agents

Oakham

Sales
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
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`; } } }