Estate & Letting Agents in Twyford and Stenson, South Derbyshire

Find Estate Agents in Twyford and Stenson, South Derbyshire
2 results
Compare Best Local Agents
Bagshaws
Bagshaws

Ashbourne

Sales
1 active listing in Twyford and Stenson, South Derbyshire, Derbyshire, East Midlands, England
53 total
Vine House Church Street, Ashbourne, DE6 1AE
View Profile
Hannells Estate Agents
Hannells Estate Agents

Chellaston

Lettings Sales
1 active listing in Twyford and Stenson, South Derbyshire, Derbyshire, East Midlands, England
201 total
17 High Street, Chellaston, DE73 6TB
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 = 'Twyford and Stenson, South Derbyshire'; 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":53629,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bagshaws","email":"ashbourne@sequencehome.co.uk","sales_phone_number":"01335 342201","address":"Vine House Church Street,\r\nAshbourne,\r\nDE6 1AE","postcode":"DE6 1AE","website_url":"https:\/\/www.bagshaws.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/53629\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:42.000000Z","updated_at":"2026-01-20T20:00:10.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53629,"agent_company_id":5046,"branch_location":"Ashbourne","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001650A8A78FC0FBBFF8E0B54B1B824A40","agent_brand_id":5814,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Vine House Church Street, Ashbourne","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bagshaws","branch_name":"Ashbourne","lettings":false,"sales":true,"commercial":false,"h_email":"ashbourne@sequencehome.co.uk","has_email":true,"h_phone":"01335 342201","has_phone":true,"resolved_brand_color":"#2d5505","boundary_listing_count":"1","property_count":"53","latitude":53.016458,"longitude":-1.734512},{"core_branch_id":53652,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hannells Estate Agents","email":"chellaston@hannells.co.uk","sales_phone_number":"01332 705505","address":"17 High Street,\r\nChellaston,\r\nDE73 6TB","postcode":"DE73 6TB","website_url":"https:\/\/www.hannells.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\/53652\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:43.000000Z","updated_at":"2026-01-20T19:59:30.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53652,"agent_company_id":136,"branch_location":"Chellaston","lettings_phone_number":"01332 294396","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E4326E6AA0F9F6BFBEF561BD516F4A40","agent_brand_id":359,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"17 High Street, Chellaston","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hannells Estate Agents","branch_name":"Chellaston","lettings":true,"sales":true,"commercial":false,"h_email":"chellaston@hannells.co.uk","has_email":true,"h_phone":"01332 705505","has_phone":true,"resolved_brand_color":"#e62323","boundary_listing_count":"1","property_count":"201","latitude":52.869682,"longitude":-1.435944}]; 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`; } } }