Estate Agents in Spelthorne, Surrey

Find Estate Agents in Spelthorne, Surrey
119 results
Compare Best Local Agents
Exp UK
Exp UK

East Midlands

Sales
9 active listings in Spelthorne, Surrey, England
7,203 total
114 St. Martin's Lane London WC2N 4BE
View Featured Profile
Tauk
Tauk

Covering Nationwide

Lettings Sales
5 active listings in Spelthorne, Surrey, England
2,094 total
Covering Nationwide
View Featured Profile
Mulburries
Mulburries

Hemel Hempstead

Lettings Sales
2 active listings in Spelthorne, Surrey, England
139 total
31 Lawn Lane, Hemel Hempstead, HP3 9HH
View Featured Profile
Bourne Estate Agents
Bourne Estate Agents

Cobham

Sales
1 active listing in Spelthorne, Surrey, England
46 total
Oakdene Parade, Cobham, KT11 2LR
View Featured Profile
Shaw & Co
Shaw & Co

Heston

Sales
1 active listing in Spelthorne, Surrey, England
111 total
10 Central Parade, Hounslow, TW5 0LH
View Featured Profile
Martin & Co
Martin & Co

Egham

Sales
4 active listings in Spelthorne, Surrey, England
14 total
86 High Street, Egham, TW20 9HF
View Profile
Rochills LTD
Rochills LTD

Walton-On-Thames

Sales
3 active listings in Spelthorne, Surrey, England
45 total
69 High Street, Walton-On-Thames, KT12 1DJ
View Profile
Martin & Co
Martin & Co

Walton on Thames

Sales
1 active listing in Spelthorne, Surrey, England
8 total
49 High Street, Walton-On-Thames, KT12 1DH
View Profile
S J Smith Estate Agents
S J Smith Estate Agents

Ashford

Lettings Sales
137 active listings in Spelthorne, Surrey, England
154 total
6 Station Approach, Ashford, TW15 2QN
View Profile
Curchods Estate Agents
Curchods Estate Agents

Shepperton

Sales
105 active listings in Spelthorne, Surrey, England
108 total
58 High Street, Shepperton, TW17 9AU
View Profile
Gregory Brown
Gregory Brown

Staines

Sales
97 active listings in Spelthorne, Surrey, England
117 total
127a High Street, Staines, TW18 4PD
View Profile
Aspen Estate Agents Limited
Aspen Estate Agents Limited

Ashford

Sales
95 active listings in Spelthorne, Surrey, England
113 total
77 Church Road Ashford TW15 2PE
View Profile
Seymours Estate Agents
Seymours Estate Agents

Staines Upon Thames

Lettings Sales
88 active listings in Spelthorne, Surrey, England
109 total
9-11 High Street, Staines, TW18 4QY
View Profile
The Frost Partnership
The Frost Partnership

Ashford

Sales
83 active listings in Spelthorne, Surrey, England
4 New Parade Church Road Ashford TW15 2UF
View Profile
Stirling Ackroyd
Stirling Ackroyd

Sunbury - Lettings

Lettings Sales
70 active listings in Spelthorne, Surrey, England
81 total
15a Station Road, Sunbury-On-Thames, TW16 6SB
View Profile
Dexters
Dexters

Sunbury

Sales
65 active listings in Spelthorne, Surrey, England
22 Thames Street, Sunbury-On-Thames, TW16 6AF
View Profile
Oasis Estate Agents
Oasis Estate Agents

Staines-Upon-Thames

Sales
55 active listings in Spelthorne, Surrey, England
70 total
Mallard Court, 4 Clarence Street, Staines-upon-Thames, Surrey TW18 4SP
View Profile
S J Smith Estate Agents
S J Smith Estate Agents

Staines

Lettings Sales
47 active listings in Spelthorne, Surrey, England
67 total
10a Clarence Street, Staines, TW18 4SP
View Profile
Swans Estate Agents
Swans Estate Agents

Ashford

Sales
46 active listings in Spelthorne, Surrey, England
49 total
26-28 Church Road, Ashford, Middlesex, TW15 2UY
View Profile
Chancellors
Chancellors

Sunbury

Lettings Sales
44 active listings in Spelthorne, Surrey, England
54 total
1 Staines Road West, Sunbury-On-Thames, TW16 7AB
View Profile
Stirling Ackroyd
Stirling Ackroyd

Staines - Lettings

Lettings Sales
44 active listings in Spelthorne, Surrey, England
61 total
142-144 High Street, Staines, TW18 4AH
View Profile
Bazely & Co
Bazely & Co

Shepperton

Sales
41 active listings in Spelthorne, Surrey, England
43 total
105 High Street, Shepperton, TW17 9BL
View Profile
Newboulds & Co
Newboulds & Co

Shepperton

Sales
33 active listings in Spelthorne, Surrey, England
40 total
4 Station Approach Shepperton TW17 8AR
View Profile
The Frost Partnership
The Frost Partnership

Staines

Lettings Sales
33 active listings in Spelthorne, Surrey, England
38 total
146/148 High Street, Staines, TW18 4AH
View Profile
Gregory Brown
Gregory Brown

Ashford

Sales
31 active listings in Spelthorne, Surrey, England
34 total
54 Church Road, Ashford, TW15 2TS
View Profile
Haart
Haart

Shepperton - Lettings

Lettings Sales
29 active listings in Spelthorne, Surrey, England
31 total
11 High Street, Shepperton, TW17 9AJ
View Profile
Devenports
Devenports

Hampton

Sales
26 active listings in Spelthorne, Surrey, England
125 total
11 Wensleydale Road, Hampton, TW12 2LP
View Profile
The Good Estate Agent
The Good Estate Agent

National

Sales
24 active listings in Spelthorne, Surrey, England
525 total
Lemanis House, Stone Street, Lympne, Hythe, CT21 4JN
View Profile
Nevin and Wells Residential
Nevin and Wells Residential

Egham

Lettings Sales
21 active listings in Spelthorne, Surrey, England
136 total
169-170 High Street, Egham, TW20 9EJ
View Profile
Romans
Romans

Portfolio Investments

Lettings Sales
13 active listings in Spelthorne, Surrey, England
68 total
Building 1, Meadows Business Park, Blackwater, Camberley GU17 9AB
View Profile
Page 1 of 4
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 = 'Spelthorne, Surrey'; const agentType = 'sales'; 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":66292,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Exp UK","email":"carl.mcintosh-ormerod@exp.uk.com","sales_phone_number":"03304 609968","address":"114 St. Martin\u0027s Lane\r\nLondon\r\nWC2N 4BE","postcode":"WC2N 4BE","website_url":"https:\/\/exp.uk.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66292\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:38.000000Z","updated_at":"2026-01-20T19:55:20.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66292,"agent_company_id":510,"branch_location":"East Midlands","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E610000056478E740646C0BF0398327040C14940","agent_brand_id":924,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"114 St. Martin\u0027s Lane, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Exp UK","branch_name":"East Midlands","lettings":false,"sales":true,"commercial":false,"h_email":"carl.mcintosh-ormerod@exp.uk.com","has_email":true,"h_phone":"03304 609968","has_phone":true,"resolved_brand_color":"#ffffff","boundary_listing_count":"9","property_count":"7203","latitude":51.509779,"longitude":-0.127137},{"core_branch_id":67542,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Tauk","email":null,"sales_phone_number":"020 4530 6761","address":"Covering Nationwide","postcode":null,"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\/67542\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:18.000000Z","updated_at":"2026-01-16T23:13:55.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":67542,"agent_company_id":4769,"branch_location":"Covering Nationwide","lettings_phone_number":"07403 937217","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000750305DEC9A7BFBFA77A32FFE8C14940","agent_brand_id":5522,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":null,"has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Tauk","branch_name":"Covering Nationwide","lettings":true,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 4530 6761","has_phone":true,"resolved_brand_color":"#e0e0de","boundary_listing_count":"5","property_count":"2094","latitude":51.514923,"longitude":-0.123654},{"core_branch_id":56209,"verification_status":"verified","verified_at":"2026-01-16T11:34:18.000000Z","verified_by":null,"verification_notes":null,"name":"Mulburries","email":"ross.pelling@mulberries.co.uk","sales_phone_number":"01442 732362","address":"31 Lawn Lane,\r\nHemel Hempstead,\r\nHP3 9HH","postcode":"HP3 9HH","website_url":"https:\/\/www.mulburries.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\/56209\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:08.000000Z","updated_at":"2026-01-20T20:01:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":56209,"agent_company_id":1348,"branch_location":"Hemel Hempstead","lettings_phone_number":"01442 732362","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E610000089EE59D76839DEBF44FB58C16FDF4940","agent_brand_id":1895,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"31 Lawn Lane, Hemel Hempstead","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mulburries","branch_name":"Hemel Hempstead","lettings":true,"sales":true,"commercial":false,"h_email":"ross.pelling@mulberries.co.uk","has_email":true,"h_phone":"01442 732362","has_phone":true,"resolved_brand_color":"#4c1560","boundary_listing_count":"2","property_count":"139","latitude":51.745598,"longitude":-0.472254},{"core_branch_id":56863,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bourne Estate Agents","email":"cobham@bourneestateagents.com","sales_phone_number":"01932 864242","address":"Oakdene Parade,\r\nCobham,\r\nKT11 2LR","postcode":"KT11 2LR","website_url":"http:\/\/www.bourneestateagents.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/56863\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:30.000000Z","updated_at":"2026-01-20T19:53:33.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56863,"agent_company_id":239,"branch_location":"Cobham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000001AFA27B85851DABF799109F835AA4940","agent_brand_id":519,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Oakdene Parade, Cobham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bourne Estate Agents","branch_name":"Cobham","lettings":false,"sales":true,"commercial":false,"h_email":"cobham@bourneestateagents.com","has_email":true,"h_phone":"01932 864242","has_phone":true,"resolved_brand_color":"#6f1e52","boundary_listing_count":"1","property_count":"46","latitude":51.329772,"longitude":-0.411215},{"core_branch_id":65438,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Shaw \u0026 Co","email":"heston@shawandcoestates.com","sales_phone_number":"020 8570 7258","address":"10 Central Parade,\r\nHounslow,\r\nTW5 0LH","postcode":"TW5 0LH","website_url":"http:\/\/www.shawandcoestates.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65438\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:09.000000Z","updated_at":"2026-01-20T19:59:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65438,"agent_company_id":3089,"branch_location":"Heston","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000E200FA7DFFE6D7BF8FC6A17E17BE4940","agent_brand_id":3755,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10 Central Parade, Hounslow","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Shaw \u0026 Co","branch_name":"Heston","lettings":false,"sales":true,"commercial":false,"h_email":"heston@shawandcoestates.com","has_email":true,"h_phone":"020 8570 7258","has_phone":true,"resolved_brand_color":"#001cff","boundary_listing_count":"1","property_count":"111","latitude":51.485092,"longitude":-0.373474},{"core_branch_id":65425,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"egham@martinco.com","sales_phone_number":"01784 495660","address":"86 High Street,\r\nEgham,\r\nTW20 9HF","postcode":"TW20 9HF","website_url":null,"description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/65425\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:55:31.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":65425,"agent_company_id":44,"branch_location":"Egham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000FD6CE4BA2965E1BFD4BB783F6EB74940","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"86 High Street, Egham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Egham","lettings":false,"sales":true,"commercial":false,"h_email":"egham@martinco.com","has_email":true,"h_phone":"01784 495660","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"4","property_count":"14","latitude":51.433052,"longitude":-0.543599},{"core_branch_id":56876,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Rochills LTD","email":"sales@rochills.co.uk","sales_phone_number":"01932 222120","address":"69 High Street,\r\nWalton-On-Thames,\r\nKT12 1DJ","postcode":"KT12 1DJ","website_url":"http:\/\/rochills.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"Reapit","logo":"https:\/\/cdn.home.co.uk\/agents\/56876\/logo.png","office_images":null,"claimed_at":"2026-01-29T10:57:29.000000Z","created_at":"2025-12-09T17:17:30.000000Z","updated_at":"2026-01-29T20:43:14.000000Z","deleted_at":null,"claimed_user_id":"1d7105be-93d6-46e3-871d-b7f07f1208d7","profile_status":"live","assigned_user_id":null,"id":56876,"agent_company_id":6288,"branch_location":"Walton-On-Thames","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001E1A16A3AEB5DABFE4F90CA837B14940","agent_brand_id":7109,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"69 High Street, Walton-On-Thames","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Rochills LTD","branch_name":"Walton-On-Thames","lettings":false,"sales":true,"commercial":false,"h_email":"sales@rochills.co.uk","has_email":true,"h_phone":"01932 222120","has_phone":true,"resolved_brand_color":"#454a50","boundary_listing_count":"3","property_count":"45","latitude":51.384511,"longitude":-0.417339},{"core_branch_id":56875,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"waltononthames@martinco.com","sales_phone_number":"01932 237888","address":"49 High Street,\r\nWalton-On-Thames,\r\nKT12 1DH","postcode":"KT12 1DH","website_url":"https:\/\/www.martinco.com\/estate-agents-and-letting-agents\/branch\/walton-on-thames\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/56875\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:17:30.000000Z","updated_at":"2026-01-20T19:55:00.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":56875,"agent_company_id":44,"branch_location":"Walton on Thames","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E3FC4D2844C0DABF00C8091346B14940","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"49 High Street, Walton-On-Thames","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Walton on Thames","lettings":false,"sales":true,"commercial":false,"h_email":"waltononthames@martinco.com","has_email":true,"h_phone":"01932 237888","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"1","property_count":"8","latitude":51.384951,"longitude":-0.417985},{"core_branch_id":65379,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"S J Smith Estate Agents","email":"lettings@sjsmithestateagents.co.uk","sales_phone_number":"01784 243333","address":"6 Station Approach,\r\nAshford,\r\nTW15 2QN","postcode":"TW15 2QN","website_url":"https:\/\/www.sjsmithestateagents.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\/65379\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65379,"agent_company_id":809,"branch_location":"Ashford","lettings_phone_number":"01784 257996","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000098F8A3A833F7DDBF051555BFD2B74940","agent_brand_id":1300,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"6 Station Approach, Ashford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"S J Smith Estate Agents","branch_name":"Ashford","lettings":true,"sales":true,"commercial":false,"h_email":"lettings@sjsmithestateagents.co.uk","has_email":true,"h_phone":"01784 243333","has_phone":true,"resolved_brand_color":"#a4233f","boundary_listing_count":"137","property_count":"154","latitude":51.436119,"longitude":-0.468213},{"core_branch_id":65392,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Curchods Estate Agents","email":"shepperton@curchods.com","sales_phone_number":"01932 230033","address":"58 High Street,\r\nShepperton,\r\nTW17 9AU","postcode":"TW17 9AU","website_url":"https:\/\/curchods.com\/estate-agents\/shepperton\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65392\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65392,"agent_company_id":244,"branch_location":"Shepperton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BE89213999B8DCBF6760E4654DB24940","agent_brand_id":525,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"58 High Street, Shepperton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Curchods Estate Agents","branch_name":"Shepperton","lettings":false,"sales":true,"commercial":false,"h_email":"shepperton@curchods.com","has_email":true,"h_phone":"01932 230033","has_phone":true,"resolved_brand_color":"#9b1929","boundary_listing_count":"105","property_count":"108","latitude":51.392987,"longitude":-0.448767},{"core_branch_id":65402,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Gregory Brown","email":"staines@gregory-brown.co.uk","sales_phone_number":"01784 451458","address":"127a High Street,\r\nStaines,\r\nTW18 4PD","postcode":"TW18 4PD","website_url":"http:\/\/www.gregory-brown.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\/65402\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:59:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65402,"agent_company_id":3230,"branch_location":"Staines","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007573F1B73D41E0BF2D98F8A3A8B74940","agent_brand_id":3900,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"127a High Street, Staines","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Gregory Brown","branch_name":"Staines","lettings":false,"sales":true,"commercial":false,"h_email":"staines@gregory-brown.co.uk","has_email":true,"h_phone":"01784 451458","has_phone":true,"resolved_brand_color":"#f5453c","boundary_listing_count":"97","property_count":"117","latitude":51.434834,"longitude":-0.507964},{"core_branch_id":65378,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Aspen Estate Agents Limited","email":"aspen.middlesex@btconnect.com","sales_phone_number":"01784 252202","address":"77 Church Road\r\nAshford\r\nTW15 2PE ","postcode":"TW15 2PE","website_url":"https:\/\/www.aspensalesandlettings.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65378\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:56:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65378,"agent_company_id":805,"branch_location":"Ashford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000091F0BDBF417BDDBF942EFD4B52B74940","agent_brand_id":1296,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"77 Church Road, Ashford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Aspen Estate Agents Limited","branch_name":"Ashford","lettings":false,"sales":true,"commercial":false,"h_email":"aspen.middlesex@btconnect.com","has_email":true,"h_phone":"01784 252202","has_phone":true,"resolved_brand_color":"#a5936b","boundary_listing_count":"95","property_count":"113","latitude":51.432199,"longitude":-0.460648},{"core_branch_id":65405,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Seymours Estate Agents","email":"sales@seymours-staines.co.uk","sales_phone_number":"01784 682828","address":"9-11 High Street,\r\nStaines,\r\nTW18 4QY","postcode":"TW18 4QY","website_url":"https:\/\/seymours-estates.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\/65405\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:59:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65405,"agent_company_id":256,"branch_location":"Staines Upon Thames","lettings_phone_number":"01784 682828","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B9A981E6736EE0BFDD99098673B74940","agent_brand_id":544,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9-11 High Street, Staines","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Seymours Estate Agents","branch_name":"Staines Upon Thames","lettings":true,"sales":true,"commercial":false,"h_email":"sales@seymours-staines.co.uk","has_email":true,"h_phone":"01784 682828","has_phone":true,"resolved_brand_color":"#04415f","boundary_listing_count":"88","property_count":"109","latitude":51.433213,"longitude":-0.513483},{"core_branch_id":65381,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"The Frost Partnership","email":"ashford@frostweb.co.uk","sales_phone_number":"01784 244272","address":"4 New Parade\r\nChurch Road\r\nAshford\r\nTW15 2UF ","postcode":"TW15 2UF","website_url":"https:\/\/www.frostweb.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\/65381\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:55:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65381,"agent_company_id":811,"branch_location":"Ashford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000001FBE8D495CFDDBF2101A3CB9BB74940","agent_brand_id":1302,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4 New Parade, Church Road, Ashford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"The Frost Partnership","branch_name":"Ashford","lettings":false,"sales":true,"commercial":false,"h_email":"ashford@frostweb.co.uk","has_email":true,"h_phone":"01784 244272","has_phone":true,"resolved_brand_color":"#04255c","boundary_listing_count":"83","property_count":"83","latitude":51.434442,"longitude":-0.465795},{"core_branch_id":65387,"verification_status":"verified","verified_at":"2026-02-02T10:33:14.000000Z","verified_by":null,"verification_notes":null,"name":"Stirling Ackroyd","email":"sunburysalesleads@townends.co.uk","sales_phone_number":"01932 361163","address":"15a Station Road,\r\nSunbury-On-Thames,\r\nTW16 6SB ","postcode":"TW16 6SB","website_url":"https:\/\/www.stirlingackroyd.com\/our-branches\/sunbury-on-thames\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65387\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-02-02T10:46:36.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65387,"agent_company_id":168,"branch_location":"Sunbury - Lettings","lettings_phone_number":"01932 361183","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C93B873254C5DABF0397C79A91B54940","agent_brand_id":437,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"15a Station Road, Sunbury-On-Thames","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Stirling Ackroyd","branch_name":"Sunbury - Lettings","lettings":true,"sales":true,"commercial":false,"h_email":"sunburysalesleads@townends.co.uk","has_email":true,"h_phone":"01932 361163","has_phone":true,"resolved_brand_color":"#21254a","boundary_listing_count":"70","property_count":"81","latitude":51.418506,"longitude":-0.418294},{"core_branch_id":65386,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Dexters","email":"sunburylettings@dexters.co.uk","sales_phone_number":"01932 781100","address":"22 Thames Street,\r\nSunbury-On-Thames,\r\nTW16 6AF","postcode":"TW16 6AF","website_url":"http:\/\/www.dexters.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\/65386\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65386,"agent_company_id":103,"branch_location":"Sunbury","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000016DD7A4D0F0ADABF4C18CDCAF6B34940","agent_brand_id":309,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"22 Thames Street, Sunbury-On-Thames","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Dexters","branch_name":"Sunbury","lettings":false,"sales":true,"commercial":false,"h_email":"sunburylettings@dexters.co.uk","has_email":true,"h_phone":"01932 781100","has_phone":true,"resolved_brand_color":"#0e253d","boundary_listing_count":"65","property_count":"65","latitude":51.405969,"longitude":-0.406864},{"core_branch_id":65407,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Oasis Estate Agents","email":"info@oasisestateagents.com","sales_phone_number":"01784 441818","address":"Mallard Court, \r\n4 Clarence Street,\r\nStaines-upon-Thames,\r\nSurrey\r\nTW18 4SP ","postcode":"TW18 4SP","website_url":"https:\/\/oasisestateagents.com\/land-and-new-homes\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65407\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:55:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65407,"agent_company_id":3232,"branch_location":"Staines-Upon-Thames","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000052D4997B4878E0BF7F164B917CB74940","agent_brand_id":3903,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Mallard Court, 4 Clarence Street, Staines-upon-Thames, Surrey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Oasis Estate Agents","branch_name":"Staines-Upon-Thames","lettings":false,"sales":true,"commercial":false,"h_email":"info@oasisestateagents.com","has_email":true,"h_phone":"01784 441818","has_phone":true,"resolved_brand_color":"#05035f","boundary_listing_count":"55","property_count":"70","latitude":51.433489,"longitude":-0.514683},{"core_branch_id":65409,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"S J Smith Estate Agents","email":"lettings@sjsmithestateagents.co.uk","sales_phone_number":"01784 779100","address":"10a Clarence Street,\r\nStaines,\r\nTW18 4SP","postcode":"TW18 4SP","website_url":"http:\/\/www.sjsmithestateagents.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\/65409\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:59:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65409,"agent_company_id":809,"branch_location":"Staines","lettings_phone_number":"01784 257996","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000052D4997B4878E0BF7F164B917CB74940","agent_brand_id":1300,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10a Clarence Street, Staines","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"S J Smith Estate Agents","branch_name":"Staines","lettings":true,"sales":true,"commercial":false,"h_email":"lettings@sjsmithestateagents.co.uk","has_email":true,"h_phone":"01784 779100","has_phone":true,"resolved_brand_color":"#a4233f","boundary_listing_count":"47","property_count":"67","latitude":51.433489,"longitude":-0.514683},{"core_branch_id":65384,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Swans Estate Agents","email":"sales@swansestateagents.co.uk","sales_phone_number":"01784 244510","address":"26-28 Church Road,\r\nAshford,\r\nMiddlesex,\r\nTW15 2UY","postcode":"TW15 2UY","website_url":"http:\/\/www.swansestateagents.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\/65384\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65384,"agent_company_id":810,"branch_location":"Ashford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009D2D20B41EBEDDBF938B31B08EB74940","agent_brand_id":1301,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"26-28 Church Road, Ashford, Middlesex","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Swans Estate Agents","branch_name":"Ashford","lettings":false,"sales":true,"commercial":false,"h_email":"sales@swansestateagents.co.uk","has_email":true,"h_phone":"01784 244510","has_phone":true,"resolved_brand_color":"#fff5dc","boundary_listing_count":"46","property_count":"49","latitude":51.434042,"longitude":-0.464729},{"core_branch_id":65388,"verification_status":"verified","verified_at":"2026-02-02T10:33:14.000000Z","verified_by":null,"verification_notes":null,"name":"Chancellors","email":"sunbury.sales@chancellors.co.uk","sales_phone_number":"01932 366122","address":"1 Staines Road West,\r\nSunbury-On-Thames,\r\nTW16 7AB","postcode":"TW16 7AB","website_url":"http:\/\/www.chancellors.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\/65388\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-02-02T10:46:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65388,"agent_company_id":168,"branch_location":"Sunbury","lettings_phone_number":"01932 366125","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001684F23E8EE6DABF5F268A90BAB54940","agent_brand_id":417,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 Staines Road West, Sunbury-On-Thames","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Chancellors","branch_name":"Sunbury","lettings":true,"sales":true,"commercial":false,"h_email":"sunbury.sales@chancellors.co.uk","has_email":true,"h_phone":"01932 366122","has_phone":true,"resolved_brand_color":"#af0f23","boundary_listing_count":"44","property_count":"54","latitude":51.419756,"longitude":-0.420322},{"core_branch_id":65396,"verification_status":"verified","verified_at":"2026-02-02T10:33:14.000000Z","verified_by":null,"verification_notes":null,"name":"Stirling Ackroyd","email":"staineslettings@stirlingackroyd.com","sales_phone_number":"01784 455299","address":"142-144 High Street,\r\nStaines,\r\nTW18 4AH","postcode":"TW18 4AH","website_url":"https:\/\/www.stirlingackroyd.com\/our-branches\/staines-upon-thames\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65396\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-02-02T10:46:36.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65396,"agent_company_id":168,"branch_location":"Staines - Lettings","lettings_phone_number":"01784 773353","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000AD18AE0E8038E0BF4EEFE2FDB8B74940","agent_brand_id":437,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"142-144 High Street, Staines","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Stirling Ackroyd","branch_name":"Staines - Lettings","lettings":true,"sales":true,"commercial":false,"h_email":"staineslettings@stirlingackroyd.com","has_email":true,"h_phone":"01784 455299","has_phone":true,"resolved_brand_color":"#21254a","boundary_listing_count":"44","property_count":"61","latitude":51.435333,"longitude":-0.506897},{"core_branch_id":65393,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bazely \u0026 Co","email":"sales@bazelyandco.co.uk","sales_phone_number":"01932 221252","address":"105 High Street,\r\nShepperton,\r\nTW17 9BL \r\n ","postcode":"TW17 9BL","website_url":"http:\/\/www.bazelyandco.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\/65393\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:55:53.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65393,"agent_company_id":2358,"branch_location":"Shepperton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003B18B14F00C5DCBF726C3D4338B24940","agent_brand_id":2983,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"105 High Street, Shepperton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bazely \u0026 Co","branch_name":"Shepperton","lettings":false,"sales":true,"commercial":false,"h_email":"sales@bazelyandco.co.uk","has_email":true,"h_phone":"01932 221252","has_phone":true,"resolved_brand_color":"#42445e","boundary_listing_count":"41","property_count":"43","latitude":51.392342,"longitude":-0.449524},{"core_branch_id":65390,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Newboulds \u0026 Co","email":"lettings@newboulds.com","sales_phone_number":"01932 232927","address":"4 \r\nStation Approach\r\nShepperton\r\nTW17 8AR ","postcode":"TW17 8AR","website_url":"http:\/\/www.newboulds.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/65390\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:55:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65390,"agent_company_id":2359,"branch_location":"Shepperton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003BE466B8019FDCBFB857E6ADBAB24940","agent_brand_id":2984,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4, Station Approach, Shepperton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Newboulds \u0026 Co","branch_name":"Shepperton","lettings":false,"sales":true,"commercial":false,"h_email":"lettings@newboulds.com","has_email":true,"h_phone":"01932 232927","has_phone":true,"resolved_brand_color":"#001f51","boundary_listing_count":"33","property_count":"40","latitude":51.396322,"longitude":-0.447205},{"core_branch_id":65397,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"The Frost Partnership","email":"staines@frostweb.co.uk","sales_phone_number":"01784 464606","address":"146\/148 High Street,\r\nStaines,\r\nTW18 4AH","postcode":"TW18 4AH","website_url":"http:\/\/www.frostweb.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\/65397\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65397,"agent_company_id":811,"branch_location":"Staines","lettings_phone_number":"01784 464606","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000AD18AE0E8038E0BF4EEFE2FDB8B74940","agent_brand_id":1302,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"146\/148 High Street, Staines","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"The Frost Partnership","branch_name":"Staines","lettings":true,"sales":true,"commercial":false,"h_email":"staines@frostweb.co.uk","has_email":true,"h_phone":"01784 464606","has_phone":true,"resolved_brand_color":"#04255c","boundary_listing_count":"33","property_count":"38","latitude":51.435333,"longitude":-0.506897},{"core_branch_id":65380,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Gregory Brown","email":"clayton@gregory-brown.co.uk","sales_phone_number":"01784 255633","address":"54 Church Road,\r\nAshford,\r\nTW15 2TS ","postcode":"TW15 2TS","website_url":"http:\/\/www.gregory-brown.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\/65380\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:55:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65380,"agent_company_id":806,"branch_location":"Ashford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000810706103E94DDBFA437DC476EB74940","agent_brand_id":1297,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"54 Church Road, Ashford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Gregory Brown","branch_name":"Ashford","lettings":false,"sales":true,"commercial":false,"h_email":"clayton@gregory-brown.co.uk","has_email":true,"h_phone":"01784 255633","has_phone":true,"resolved_brand_color":"#ff0001","boundary_listing_count":"31","property_count":"34","latitude":51.433053,"longitude":-0.462173},{"core_branch_id":65391,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"shepperton.lettings@haart.co.uk","sales_phone_number":"01932 242824","address":"11 High Street,\r\nShepperton,\r\nTW17 9AJ","postcode":"TW17 9AJ","website_url":"https:\/\/www.haart.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\/65391\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:59:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65391,"agent_company_id":163,"branch_location":"Shepperton - Lettings","lettings_phone_number":"01932 553458","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000034F790F0BDBFDCBFD8D2A3A99EB24940","agent_brand_id":405,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11 High Street, Shepperton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Shepperton - Lettings","lettings":true,"sales":true,"commercial":false,"h_email":"shepperton.lettings@haart.co.uk","has_email":true,"h_phone":"01932 242824","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"29","property_count":"31","latitude":51.395467,"longitude":-0.449203},{"core_branch_id":65372,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Devenports","email":"james@devenports.co.uk","sales_phone_number":"01932 554001","address":"11 Wensleydale Road,\r\nHampton,\r\nTW12 2LP","postcode":"TW12 2LP","website_url":"https:\/\/devenports.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\/65372\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:07.000000Z","updated_at":"2026-01-20T19:55:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65372,"agent_company_id":3086,"branch_location":"Hampton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A5F44C2F3196D7BF5A12A0A696B54940","agent_brand_id":3752,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11 Wensleydale Road, Hampton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Devenports","branch_name":"Hampton","lettings":false,"sales":true,"commercial":false,"h_email":"james@devenports.co.uk","has_email":true,"h_phone":"01932 554001","has_phone":true,"resolved_brand_color":"#d5d2b7","boundary_listing_count":"26","property_count":"125","latitude":51.41866,"longitude":-0.368542},{"core_branch_id":53035,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"The Good Estate Agent","email":"Robbryer@thegood.co.uk","sales_phone_number":"01303 647350","address":"Lemanis House,\r\nStone Street,\r\nLympne,\r\nHythe,\r\nCT21 4JN","postcode":"CT21 4JN","website_url":"https:\/\/www.thegoodestateagent.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\/53035\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:23.000000Z","updated_at":"2026-01-20T19:52:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53035,"agent_company_id":5755,"branch_location":"National","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000B26FE28EA8CF03FD7A4DB12B98A4940","agent_brand_id":6560,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Lemanis House, Stone Street, Lympne, Hythe","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"The Good Estate Agent","branch_name":"National","lettings":false,"sales":true,"commercial":false,"h_email":"Robbryer@thegood.co.uk","has_email":true,"h_phone":"01303 647350","has_phone":true,"resolved_brand_color":"#7fad30","boundary_listing_count":"24","property_count":"525","latitude":51.083773,"longitude":1.034403},{"core_branch_id":65422,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Nevin and Wells Residential","email":"info@nevinandwells.co.uk","sales_phone_number":"01784 437437","address":"169-170 High Street,\r\nEgham,\r\nTW20 9EJ \r\n\r\n","postcode":"TW20 9EJ","website_url":"http:\/\/www.nevinandwells.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\/65422\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:08.000000Z","updated_at":"2026-01-20T19:59:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65422,"agent_company_id":6155,"branch_location":"Egham","lettings_phone_number":"01784 437437","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A8FFACF9F197E1BF5CC64D0D34B74940","agent_brand_id":6973,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"169-170 High Street, Egham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Nevin and Wells Residential","branch_name":"Egham","lettings":true,"sales":true,"commercial":false,"h_email":"info@nevinandwells.co.uk","has_email":true,"h_phone":"01784 437437","has_phone":true,"resolved_brand_color":"#141f50","boundary_listing_count":"21","property_count":"136","latitude":51.431276,"longitude":-0.549798},{"core_branch_id":55719,"verification_status":"verified","verified_at":"2026-02-02T10:33:14.000000Z","verified_by":null,"verification_notes":null,"name":"Romans","email":"OnlineLeads@romans.co.uk","sales_phone_number":"01344 835718","address":"Building 1, Meadows Business Park, Blackwater, Camberley GU17 9AB","postcode":"GU17 9AB","website_url":"https:\/\/www.lrg.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\/55719\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:52.000000Z","updated_at":"2026-02-02T10:46:40.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55719,"agent_company_id":168,"branch_location":"Portfolio Investments","lettings_phone_number":"0191 300 1609","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EF737CB438E3E8BF8544DAC69FAA4940","agent_brand_id":434,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Building 1, Meadows Business Park, Blackwater, Camberley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Romans","branch_name":"Portfolio Investments","lettings":true,"sales":true,"commercial":false,"h_email":"OnlineLeads@romans.co.uk","has_email":true,"h_phone":"01344 835718","has_phone":true,"resolved_brand_color":"#001946","boundary_listing_count":"13","property_count":"68","latitude":51.333001,"longitude":-0.777737}]; 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`; } } }