Estate & Letting Agents in Hough-on-the-Hill, South Kesteven

Find Estate Agents in Hough-on-the-Hill, South Kesteven
5 results
Compare Best Local Agents
Martin & Co
Martin & Co

Grantham

Sales
1 active listing in Hough-on-the-Hill, South Kesteven, Lincolnshire, England
43 total
2 Market Place Grantham NG31 6LQ
View Profile
Fine & Country
Fine & Country

Central Lincolnshire and Grantham

Sales
1 active listing in Hough-on-the-Hill, South Kesteven, Lincolnshire, England
40 total
55 High Street Navenby LN5 0DZ
View Profile
Pygott & Crone
Pygott & Crone

Grantham

Sales
1 active listing in Hough-on-the-Hill, South Kesteven, Lincolnshire, England
96 total
23 Watergate, Grantham, NG31 6NS
View Profile
Savills
Savills

Lincoln

Sales
1 active listing in Hough-on-the-Hill, South Kesteven, Lincolnshire, England
77 total
Olympic House, Doddington Road, Lincoln, LN6 3SE
View Profile
William H. Brown
William H. Brown

Grantham

Lettings Sales
1 active listing in Hough-on-the-Hill, South Kesteven, Lincolnshire, England
170 total
63 High Street, Grantham, NG31 6NN
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 = 'Hough-on-the-Hill, South Kesteven'; 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":59707,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"grantham@martinco.com","sales_phone_number":"01476 561911","address":"2 \r\nMarket Place\r\nGrantham\r\nNG31 6LQ ","postcode":"NG31 6LQ","website_url":"https:\/\/www.martinco.com\/estate-agents-and-letting-agents\/branch\/grantham\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59707\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:19:03.000000Z","updated_at":"2026-01-20T19:55:27.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59707,"agent_company_id":44,"branch_location":"Grantham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E8DEC325C79DE4BF68588CBAD6744A40","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2, Market Place, Grantham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Grantham","lettings":false,"sales":true,"commercial":false,"h_email":"grantham@martinco.com","has_email":true,"h_phone":"01476 561911","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"1","property_count":"43","latitude":52.912803,"longitude":-0.64426},{"core_branch_id":57785,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Fine \u0026 Country","email":"lincoln@fineandcountry.com","sales_phone_number":"01522 287008","address":"55 \r\nHigh Street\r\nNavenby\r\nLN5 0DZ","postcode":"LN5 0DZ","website_url":"http:\/\/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\/57785\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:00.000000Z","updated_at":"2026-01-20T19:57:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57785,"agent_company_id":991,"branch_location":"Central Lincolnshire and Grantham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E3FDB8FDF2C9E0BFEA5DBC1FB78D4A40","agent_brand_id":1510,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"55, High Street, Navenby","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Fine \u0026 Country","branch_name":"Central Lincolnshire and Grantham","lettings":false,"sales":true,"commercial":false,"h_email":"lincoln@fineandcountry.com","has_email":true,"h_phone":"01522 287008","has_phone":true,"resolved_brand_color":"#9d8140","boundary_listing_count":"1","property_count":"40","latitude":53.107151,"longitude":-0.524652},{"core_branch_id":59713,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Pygott \u0026 Crone","email":"lallison@pygott-crone.com","sales_phone_number":"01476 591414","address":"23 Watergate,\r\nGrantham,\r\nNG31 6NS","postcode":"NG31 6NS","website_url":"http:\/\/www.pygott-crone.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59713\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T20:00:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59713,"agent_company_id":1760,"branch_location":"Grantham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A164726A6798E4BF51BB5F05F8744A40","agent_brand_id":2348,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"23 Watergate, Grantham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Pygott \u0026 Crone","branch_name":"Grantham","lettings":false,"sales":true,"commercial":false,"h_email":"lallison@pygott-crone.com","has_email":true,"h_phone":"01476 591414","has_phone":true,"resolved_brand_color":"#ff0e35","boundary_listing_count":"1","property_count":"96","latitude":52.913819,"longitude":-0.643604},{"core_branch_id":57795,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Savills","email":"lincoln@savills.com","sales_phone_number":"01522 508908","address":"Olympic House,\r\nDoddington Road,\r\nLincoln,\r\nLN6 3SE","postcode":"LN6 3SE","website_url":"https:\/\/www.savills.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\/57795\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:00.000000Z","updated_at":"2026-01-20T19:57:44.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57795,"agent_company_id":33,"branch_location":"Lincoln","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006953758F6CAEE3BF8672A25D859A4A40","agent_brand_id":47,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Olympic House, Doddington Road, Lincoln","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Savills","branch_name":"Lincoln","lettings":false,"sales":true,"commercial":false,"h_email":"lincoln@savills.com","has_email":true,"h_phone":"01522 508908","has_phone":true,"resolved_brand_color":"#ffe643","boundary_listing_count":"1","property_count":"77","latitude":53.207195,"longitude":-0.615042},{"core_branch_id":59709,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"William H. Brown","email":"Grantham@williamhbrown.co.uk","sales_phone_number":"01476 566363","address":"63 High Street,\r\nGrantham,\r\nNG31 6NN","postcode":"NG31 6NN","website_url":"http:\/\/www.williamhbrown.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\/59709\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:03.000000Z","updated_at":"2026-01-20T20:00:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59709,"agent_company_id":54,"branch_location":"Grantham","lettings_phone_number":"01476 578572","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000067F0F78BD992E4BF59897956D2744A40","agent_brand_id":216,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"63 High Street, Grantham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"William H. Brown","branch_name":"Grantham","lettings":true,"sales":true,"commercial":false,"h_email":"Grantham@williamhbrown.co.uk","has_email":true,"h_phone":"01476 566363","has_phone":true,"resolved_brand_color":"#8dc3d9","boundary_listing_count":"1","property_count":"170","latitude":52.912669,"longitude":-0.642926}]; 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`; } } }