Estate & Letting Agents in Aston cum Aughton, Rotherham

Find Estate Agents in Aston cum Aughton, Rotherham
36 results
Compare Best Local Agents
Kelham Square
Kelham Square

Sheffield

Sales
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
18 total
Kelham Square, 6 Kelham Island, Sheffield, S3 8SD
View Profile
Keller Williams Plus
Keller Williams Plus

Covering Nationwide

Sales
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
611 total
Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford, CM1 3AG
View Profile
Kendra Jacob
Kendra Jacob

Bassetlaw

Sales
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
169 total
Six Oaks Grove, Retford, DN22 0RJ
View Profile
Openrent
Openrent

London

Lettings
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
8,405 total
20 Wenlock Road, London, N1 7GU
View Profile
Pugh and Company
Pugh and Company

Manchester

Sales
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
4 total
Conway House, 1 Blackburn Road, Sheffield, S61 2DW
View Profile
Redbrik
Redbrik

Crystal Peaks

Sales
1 active listing in Aston cum Aughton, Rotherham, South Yorkshire, England
105 total
Unit 10, Central Atrium, Crystal Peaks Shopping Centre, Sheffield, S20 7PN
View Profile
Page 2 of 2
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 = 'Aston cum Aughton, Rotherham'; 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":62329,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Kelham Square","email":"listings@kelhamsquare.co.uk","sales_phone_number":"0114 352 0973","address":"Kelham Square, \r\n6 Kelham Island,\r\nSheffield,\r\nS3 8SD","postcode":"S3 8SD","website_url":"https:\/\/www.kelhamsquare.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\/62329\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:27.000000Z","updated_at":"2026-01-20T19:54:29.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62329,"agent_company_id":3112,"branch_location":"Sheffield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000AF5B04C6FA86F7BFB4226AA2CFB14A40","agent_brand_id":3779,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Kelham Square, 6 Kelham Island, Sheffield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Kelham Square","branch_name":"Sheffield","lettings":false,"sales":true,"commercial":false,"h_email":"listings@kelhamsquare.co.uk","has_email":true,"h_phone":"0114 352 0973","has_phone":true,"resolved_brand_color":"#fab005","boundary_listing_count":"1","property_count":"18","latitude":53.389149,"longitude":-1.470454},{"core_branch_id":52529,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Keller Williams Plus","email":"wonmaungthein@gmail.com","sales_phone_number":"07753375229","address":"Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford, CM1 3AG","postcode":"G5 0GY","website_url":"https:\/\/www.kwukplus.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52529\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:06.000000Z","updated_at":"2026-01-21T17:12:44.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52529,"agent_company_id":3836,"branch_location":"Covering Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007250C24CDBBFDC3F2AFF5A5EB9DC4940","agent_brand_id":4537,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Keller Williams Plus","branch_name":"Covering Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"wonmaungthein@gmail.com","has_email":true,"h_phone":"07753375229","has_phone":true,"resolved_brand_color":"#cb011e","boundary_listing_count":"1","property_count":"611","latitude":51.724407,"longitude":0.44921},{"core_branch_id":53866,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Kendra Jacob","email":null,"sales_phone_number":"01909 492116","address":"Six Oaks Grove,\r\nRetford,\r\nDN22 0RJ","postcode":"DN22 0RJ","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\/53866\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:50.000000Z","updated_at":"2026-01-20T20:00:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53866,"agent_company_id":3249,"branch_location":"Bassetlaw","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008A5759DB148FECBFB91AD99596A74A40","agent_brand_id":3921,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Six Oaks Grove, Retford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Kendra Jacob","branch_name":"Bassetlaw","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01909 492116","has_phone":true,"resolved_brand_color":"#11b3c0","boundary_listing_count":"1","property_count":"169","latitude":53.309283,"longitude":-0.892466},{"core_branch_id":58995,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Openrent","email":"zoopla@openrent.co.uk","sales_phone_number":null,"address":"20 \r\nWenlock Road, \r\nLondon, \r\nN1 7GU","postcode":"N1 7GU","website_url":"https:\/\/www.openrent.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\/58995\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:40.000000Z","updated_at":"2026-01-20T19:55:47.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58995,"agent_company_id":7279,"branch_location":"London","lettings_phone_number":"020 3322 3265","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003D7D04FEF0F3B7BFCEA5B8AAECC34940","agent_brand_id":8120,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"20, Wenlock Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Openrent","branch_name":"London","lettings":true,"sales":false,"commercial":false,"h_email":"zoopla@openrent.co.uk","has_email":true,"h_phone":"020 3322 3265","has_phone":true,"resolved_brand_color":"#468cc8","boundary_listing_count":"1","property_count":"8405","latitude":51.53066,"longitude":-0.093566},{"core_branch_id":62404,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Pugh and Company","email":null,"sales_phone_number":"03455 051200","address":"Conway House, \r\n1 Blackburn Road, Sheffield, \r\nS61 2DW","postcode":"S61 2DW","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\/62404\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:30.000000Z","updated_at":"2026-01-20T19:56:19.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62404,"agent_company_id":1989,"branch_location":"Manchester","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E3A59BC420B0F6BF2DB29DEFA7B64A40","agent_brand_id":2596,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Conway House, 1 Blackburn Road, Sheffield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Pugh and Company","branch_name":"Manchester","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"03455 051200","has_phone":true,"resolved_brand_color":"#210f41","boundary_listing_count":"1","property_count":"4","latitude":53.427,"longitude":-1.418},{"core_branch_id":62312,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Redbrik","email":"mark.ross@redbrik.co.uk","sales_phone_number":"0114 361 1000","address":"Unit 10, Central Atrium, Crystal Peaks Shopping Centre, Sheffield, S20 7PN","postcode":"S20 7PN","website_url":"http:\/\/www.redbrik.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\/62312\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:27.000000Z","updated_at":"2026-01-20T19:57:27.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62312,"agent_company_id":4023,"branch_location":"Crystal Peaks","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F8FA5A971AA1F5BF9A249694BBAB4A40","agent_brand_id":4740,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Unit 10, Central Atrium, Crystal Peaks Shopping Centre, Sheffield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Redbrik","branch_name":"Crystal Peaks","lettings":false,"sales":true,"commercial":false,"h_email":"mark.ross@redbrik.co.uk","has_email":true,"h_phone":"0114 361 1000","has_phone":true,"resolved_brand_color":"#cf405b","boundary_listing_count":"1","property_count":"105","latitude":53.341662,"longitude":-1.351832}]; 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`; } } }