Estate & Letting Agents in Elstree and Borehamwood, Hertsmere

Find Estate Agents in Elstree and Borehamwood, Hertsmere
99 results
Coopers Estate Agents
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
24 total
164 St. Albans Road, Watford, WD24 4AS
View Profile
Cosway Estates

Mill Hill

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
122 total
135/137 The Broadway, Mill Hill, London, NW7 4TD
View Profile
Daniel Ford

Kings Cross

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
52 total
68 Caledonian Road, London, N1 9DP
Davidson Frost-Wellings
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
219 total
47 The Broadway, Stanmore, HA7 4DJ,
View Profile
Deakin-White

St Albans

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
40 total
Office 224, 17 Holywell Hill, St Albans, AL1 1DT
View Profile
First Step

Stotfold

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
71 total
Waterloo Farm Stotfold Road Arlesey SG15 6XP
View Profile
Foxtons

Stanmore

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
98 total
40 Church Road, Stanmore, HA7 4AH
View Profile
Glocalagents.Co.Uk

Covering Nationwide

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
193 total
99Home Ltd, Sutton Business Park, Restmor Way, Wallington, Surrey, SM6 7AH
Godfrey and Barr

Hampstead Garden Suburb

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
54 total
20 The Market Place, London, NW11 6JJ
View Profile
Gravity Estates

Gravity Estates

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
30 total
18 Golders Green Road, London, NW11 8LL
View Profile
Haart

Wembley

Lettings Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
97 total
31 Bridge Road, Wembley, HA9 9AB
View Profile
Haart

Abbots Langley

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
42 total
30 High Street, Abbots Langley, WD5 0AR
View Profile
Hawksgrove Estates

Enfield

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
15 total
Silver Rose, Unit 21 East Lodge Lane, Enfield, EN2 8AS
Haymills

Harrow

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
37 total
292 Preston Road Kenton Harrow HA3 0QA
Homekey Sales & Lettings

Milton Keynes

Lettings
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
5 Drakes Mews, Crownhill, Milton Keynes, MK8 0ER
Ian Gibbs

Enfield Lettings

Lettings Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
44 total
49-51 Windmill Hill, Enfield, EN2 7AE
View Profile
Jng Homes

London

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
47 total
1st Floor, Gallery Court, 28 Arcadia Avenue, London, N3 2FG
Joseph Scott

Edgware

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
198 total
172/174 Deans Lane, Edgware, HA8 9NT
View Profile
Link Up Estate Agents
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
28 total
5 Hillingdon Parade, Uxbridge Road, Hillingdon, Uxbridge, UB10 0PE
Lotus Carlton

Luton

Lettings Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
70 total
9 Lyneham Road, Luton, LU2 9JS
Real Estates

Totteridge

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
54 total
32 Totteridge Lane London N20 9QJ
View Profile
Robert Lehrer Properties
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
30 total
393 Archway Road London N6 4ER
View Profile
Rouge Property

Harrow

Lettings
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
25 total
34-36 Lowlands Road, Harrow, HA1 3AT
View Profile
Savills

Buckinghamshire & Hertfordshire

Lettings Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
72 total
55 Hill Avenue, Amersham, HP6 5BX
View Profile
Savills

Rickmansworth

Lettings Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
80 total
11 Church Street Rickmansworth WD3 1BX
View Profile
Savills Auctions

London

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
387 total
33 Margaret Street London W1G 0JD
Smartsale4U

London

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
66 total
Suite 331 Kemp House, 152-160, City Road, London, EC1V 2NX
So Resi

So Resi

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
260 total
Amber House, Market Street Bracknell, RG12 1LQ
Spencer & Sener

Barnet

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
87 total
14 High Street High Barnet Barnet Hertfordshire EN5 5RU
View Profile
Squires Estates

Mill Hill

Sales
1 active listing in Elstree and Borehamwood, Hertsmere, Hertfordshire, England
46 total
7 Thornfield Parade, Holders Hill Road, London, NW7 1LN
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 = 'Elstree and Borehamwood, Hertsmere'; 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":66327,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Coopers Estate Agents","email":"info@coopersestateagents.co.uk","sales_phone_number":"01923 228822","address":"164 St. Albans Road,\r\nWatford,\r\nWD24 4AS","postcode":"WD24 4AS","website_url":"http:\/\/www.coopersestateagents.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\/66327\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:39.000000Z","updated_at":"2026-01-20T19:55:21.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66327,"agent_company_id":4076,"branch_location":"Watford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006C7C26FBE769D9BFD80FB1C1C2D54940","agent_brand_id":4798,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"164 St. Albans Road, Watford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Coopers Estate Agents","branch_name":"Watford","lettings":false,"sales":true,"commercial":false,"h_email":"info@coopersestateagents.co.uk","has_email":true,"h_phone":"01923 228822","has_phone":true,"resolved_brand_color":"#afcc0b","boundary_listing_count":"1","property_count":"24","latitude":51.670006,"longitude":-0.397089},{"core_branch_id":60528,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Cosway Estates","email":"info@cosway.co.uk","sales_phone_number":"020 8959 0011","address":"135\/137 The Broadway,\r\nMill Hill,\r\nLondon,\r\nNW7 4TD","postcode":"NW7 4TD","website_url":"http:\/\/www.cosway.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\/60528\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:29.000000Z","updated_at":"2026-01-20T19:54:13.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60528,"agent_company_id":5676,"branch_location":"Mill Hill","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006971C6302768CFBF05357C0BEBCE4940","agent_brand_id":6475,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"135\/137 The Broadway, Mill Hill, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Cosway Estates","branch_name":"Mill Hill","lettings":false,"sales":true,"commercial":false,"h_email":"info@cosway.co.uk","has_email":true,"h_phone":"020 8959 0011","has_phone":true,"resolved_brand_color":"#e42f9c","boundary_listing_count":"1","property_count":"122","latitude":51.616548,"longitude":-0.245366},{"core_branch_id":59003,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Daniel Ford","email":"remiways@gmail.com","sales_phone_number":null,"address":"68 Caledonian Road,\r\nLondon,\r\nN1 9DP","postcode":"N1 9DP","website_url":"https:\/\/www.df-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\/59003\/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":59003,"agent_company_id":7258,"branch_location":"Kings Cross","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000529D0E643DB5BEBFE8FA3E1C24C44940","agent_brand_id":8099,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"68 Caledonian Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Daniel Ford","branch_name":"Kings Cross","lettings":false,"sales":true,"commercial":false,"h_email":"remiways@gmail.com","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#2c5373","boundary_listing_count":"1","property_count":"52","latitude":51.532352,"longitude":-0.119953},{"core_branch_id":67022,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Davidson Frost-Wellings","email":"mark@df-w.co.uk","sales_phone_number":"020 8954 8806","address":"47 The Broadway,\r\nStanmore,\r\nHA7 4DJ,","postcode":"HA7 4DJ","website_url":"https:\/\/www.df-w.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\/67022\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:01.000000Z","updated_at":"2026-01-20T19:55:26.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":67022,"agent_company_id":7493,"branch_location":"Stanmore","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E7E3DA5031CED3BF89D2DEE00BCF4940","agent_brand_id":8340,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"47 The Broadway, Stanmore","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Davidson Frost-Wellings","branch_name":"Stanmore","lettings":false,"sales":true,"commercial":false,"h_email":"mark@df-w.co.uk","has_email":true,"h_phone":"020 8954 8806","has_phone":true,"resolved_brand_color":"#784164","boundary_listing_count":"1","property_count":"219","latitude":51.61755,"longitude":-0.30946},{"core_branch_id":50033,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Deakin-White","email":"hleads@dwrealestate.co.uk","sales_phone_number":"01727 620131","address":"Office 224,\r\n17 Holywell Hill,\r\nSt Albans,\r\nAL1 1DT","postcode":"AL1 1DT","website_url":"http:\/\/www.dwrealestate.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\/50033\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:45.000000Z","updated_at":"2026-01-20T19:52:23.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50033,"agent_company_id":1481,"branch_location":"St Albans","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000390D51853FC3D5BFA0C37C7901E04940","agent_brand_id":2041,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 224, 17 Holywell Hill, St Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Deakin-White","branch_name":"St Albans","lettings":false,"sales":true,"commercial":false,"h_email":"hleads@dwrealestate.co.uk","has_email":true,"h_phone":"01727 620131","has_phone":true,"resolved_brand_color":"#5f0a8c","boundary_listing_count":"1","property_count":"40","latitude":51.750045,"longitude":-0.340042},{"core_branch_id":62953,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"First Step","email":"Julie@firststep.eu.com","sales_phone_number":"01462 659730","address":"Waterloo Farm \r\nStotfold Road\r\nArlesey\r\nSG15 6XP ","postcode":"SG15 6XP","website_url":"https:\/\/www.firststep.ltd\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62953\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:48.000000Z","updated_at":"2026-01-20T19:54:37.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62953,"agent_company_id":8825,"branch_location":"Stotfold","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BADC60A8C30AD0BF7E5182FE42034A40","agent_brand_id":9705,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Waterloo Farm, Stotfold Road, Arlesey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"First Step","branch_name":"Stotfold","lettings":false,"sales":true,"commercial":false,"h_email":"Julie@firststep.eu.com","has_email":true,"h_phone":"01462 659730","has_phone":true,"resolved_brand_color":"#ed3c3d","boundary_listing_count":"1","property_count":"71","latitude":52.025482,"longitude":-0.250657},{"core_branch_id":55985,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Foxtons","email":"Stanmore@foxtons.co.uk","sales_phone_number":"020 8963 5068","address":"40 Church Road,\r\nStanmore,\r\nHA7 4AH","postcode":"HA7 4AH","website_url":"http:\/\/www.foxtons.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\/55985\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:01.000000Z","updated_at":"2026-01-20T19:53:22.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55985,"agent_company_id":66,"branch_location":"Stanmore","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000399A232BBF0CD4BF6D1B4641F0CE4940","agent_brand_id":235,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"40 Church Road, Stanmore","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Foxtons","branch_name":"Stanmore","lettings":false,"sales":true,"commercial":false,"h_email":"Stanmore@foxtons.co.uk","has_email":true,"h_phone":"020 8963 5068","has_phone":true,"resolved_brand_color":"#016f64","boundary_listing_count":"1","property_count":"98","latitude":51.616707,"longitude":-0.313278},{"core_branch_id":63374,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Glocalagents.Co.Uk","email":null,"sales_phone_number":"020 3500 0999","address":"99Home Ltd,\r\nSutton Business Park,\r\nRestmor Way, \r\nWallington, \r\nSurrey, \r\nSM6 7AH ","postcode":"SM6 7AH","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\/63374\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:01.000000Z","updated_at":"2026-01-20T19:54:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63374,"agent_company_id":7540,"branch_location":"Covering Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C5E40D30F31DC4BF632992AF04B04940","agent_brand_id":8389,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"99Home Ltd, Sutton Business Park, Restmor Way, Wallington, Surrey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Glocalagents.Co.Uk","branch_name":"Covering Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 3500 0999","has_phone":true,"resolved_brand_color":"#ffd023","boundary_listing_count":"1","property_count":"193","latitude":51.375143,"longitude":-0.157164},{"core_branch_id":60364,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Godfrey and Barr","email":"jeremy@godfreyandbarr.com","sales_phone_number":"020 8458 9119","address":"20 The Market Place,\r\nLondon,\r\nNW11 6JJ","postcode":"NW11 6JJ","website_url":"http:\/\/www.godfreyandbarr.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/60364\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:24.000000Z","updated_at":"2026-01-20T19:54:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60364,"agent_company_id":68,"branch_location":"Hampstead Garden Suburb","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005CE509849D62C7BFDBBE47FDF5CA4940","agent_brand_id":241,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"20 The Market Place, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Godfrey and Barr","branch_name":"Hampstead Garden Suburb","lettings":false,"sales":true,"commercial":false,"h_email":"jeremy@godfreyandbarr.com","has_email":true,"h_phone":"020 8458 9119","has_phone":true,"resolved_brand_color":"#203c60","boundary_listing_count":"1","property_count":"54","latitude":51.585632,"longitude":-0.182697},{"core_branch_id":60374,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Gravity Estates","email":"email@gravity-estates.com","sales_phone_number":"020 8357 0810","address":"18 Golders Green Road,\r\nLondon,\r\nNW11 8LL","postcode":"NW11 8LL","website_url":"https:\/\/www.gravity-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\/60374\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:24.000000Z","updated_at":"2026-01-20T19:54:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60374,"agent_company_id":70,"branch_location":"Gravity Estates","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000910F7A36AB3EC9BFCCEEC9C342C94940","agent_brand_id":243,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"18 Golders Green Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Gravity Estates","branch_name":"Gravity Estates","lettings":false,"sales":true,"commercial":false,"h_email":"email@gravity-estates.com","has_email":true,"h_phone":"020 8357 0810","has_phone":true,"resolved_brand_color":"#4a4660","boundary_listing_count":"1","property_count":"30","latitude":51.57235,"longitude":-0.197225},{"core_branch_id":56012,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"wembley.park@haart.co.uk","sales_phone_number":"020 8904 1123","address":"31 Bridge Road,\r\nWembley,\r\nHA9 9AB","postcode":"HA9 9AB","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\/56012\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:02.000000Z","updated_at":"2026-01-20T20:00:56.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56012,"agent_company_id":163,"branch_location":"Wembley","lettings_phone_number":"020 4512 8378","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005DA5BBEB6CC8D1BFE5982CEE3FC84940","agent_brand_id":405,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"31 Bridge Road, Wembley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Wembley","lettings":true,"sales":true,"commercial":false,"h_email":"wembley.park@haart.co.uk","has_email":true,"h_phone":"020 8904 1123","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"1","property_count":"97","latitude":51.564451,"longitude":-0.277858},{"core_branch_id":66360,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"abbots.langley@spicermccoll.co.uk","sales_phone_number":"01923 510108","address":"30 High Street,\r\nAbbots Langley,\r\nWD5 0AR","postcode":"WD5 0AR","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\/66360\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:40.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":66360,"agent_company_id":163,"branch_location":"Abbots Langley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000717495EEAEB3DABF7044F7AC6BDA4940","agent_brand_id":405,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"30 High Street, Abbots Langley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Abbots Langley","lettings":false,"sales":true,"commercial":false,"h_email":"abbots.langley@spicermccoll.co.uk","has_email":true,"h_phone":"01923 510108","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"1","property_count":"42","latitude":51.706411,"longitude":-0.417217},{"core_branch_id":54790,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hawksgrove Estates","email":null,"sales_phone_number":"07590 370731","address":"Silver Rose, Unit 21 East Lodge Lane,\r\nEnfield,\r\nEN2 8AS","postcode":"EN2 8AS","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\/54790\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:20.000000Z","updated_at":"2026-01-20T19:53:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54790,"agent_company_id":6240,"branch_location":"Enfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B81E85EB51B8BEBF2DB29DEFA7D64940","agent_brand_id":7059,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Silver Rose, Unit 21 East Lodge Lane, Enfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hawksgrove Estates","branch_name":"Enfield","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"07590 370731","has_phone":true,"resolved_brand_color":"#fff35e","boundary_listing_count":"1","property_count":"15","latitude":51.677,"longitude":-0.12},{"core_branch_id":55926,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haymills","email":null,"sales_phone_number":"020 8904 8822","address":"292 \r\nPreston Road\r\nKenton\r\nHarrow\r\nHA3 0QA \r\n ","postcode":"HA3 0QA","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\/55926\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:59.000000Z","updated_at":"2026-01-20T19:53:21.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55926,"agent_company_id":9754,"branch_location":"Harrow","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E509849D62D5D2BF26A8E15B58C94940","agent_brand_id":10653,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"292, Preston Road, Kenton, Harrow","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haymills","branch_name":"Harrow","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 8904 8822","has_phone":true,"resolved_brand_color":"#411955","boundary_listing_count":"1","property_count":"37","latitude":51.573009,"longitude":-0.294274},{"core_branch_id":58854,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Homekey Sales \u0026 Lettings","email":null,"sales_phone_number":null,"address":"5 Drakes Mews,\r\nCrownhill,\r\nMilton Keynes,\r\nMK8 0ER","postcode":"MK8 0ER","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\/58854\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:34.000000Z","updated_at":"2026-01-20T19:56:58.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58854,"agent_company_id":7148,"branch_location":"Milton Keynes","lettings_phone_number":"01908 915685","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000861C5BCF108EE9BFB14D2A1A6B034A40","agent_brand_id":7989,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 Drakes Mews, Crownhill, Milton Keynes","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Homekey Sales \u0026 Lettings","branch_name":"Milton Keynes","lettings":true,"sales":false,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01908 915685","has_phone":true,"resolved_brand_color":"#3e8042","boundary_listing_count":"1","property_count":"1","latitude":52.026706,"longitude":-0.798592},{"core_branch_id":54789,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ian Gibbs","email":"sales@iangibbs.com","sales_phone_number":"020 8370 4800","address":"49-51 Windmill Hill,\r\nEnfield,\r\nEN2 7AE","postcode":"EN2 7AE","website_url":"http:\/\/www.iangibbs.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54789\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:20.000000Z","updated_at":"2026-01-20T20:00:28.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54789,"agent_company_id":6241,"branch_location":"Enfield Lettings","lettings_phone_number":"020 8370 4820","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000021205F420587B7BF7D224F92AED34940","agent_brand_id":7060,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"49-51 Windmill Hill, Enfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ian Gibbs","branch_name":"Enfield Lettings","lettings":true,"sales":true,"commercial":false,"h_email":"sales@iangibbs.com","has_email":true,"h_phone":"020 8370 4800","has_phone":true,"resolved_brand_color":"#05325a","boundary_listing_count":"1","property_count":"44","latitude":51.653765,"longitude":-0.091904},{"core_branch_id":59169,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jng Homes","email":null,"sales_phone_number":"07748 338563","address":"1st Floor, Gallery Court,\r\n28 Arcadia Avenue,\r\nLondon,\r\nN3 2FG","postcode":"N3 2FG","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\/59169\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:45.000000Z","updated_at":"2026-01-20T19:56:43.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59169,"agent_company_id":6383,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E998F38C7DC9C8BF7B832F4CA6CC4940","agent_brand_id":7205,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1st Floor, Gallery Court, 28 Arcadia Avenue, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jng Homes","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"07748 338563","has_phone":true,"resolved_brand_color":"#091031","boundary_listing_count":"1","property_count":"47","latitude":51.598825,"longitude":-0.193649},{"core_branch_id":55999,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Joseph Scott","email":"sales@josephscott.net","sales_phone_number":"020 8906 2244","address":"172\/174 Deans Lane,\r\nEdgware,\r\nHA8 9NT","postcode":"HA8 9NT","website_url":"https:\/\/www.josephscott.net\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/55999\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:01.000000Z","updated_at":"2026-01-20T19:53:23.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55999,"agent_company_id":6435,"branch_location":"Edgware","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000793E03EACDA8D0BF7102D369DDCE4940","agent_brand_id":7257,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"172\/174 Deans Lane, Edgware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Joseph Scott","branch_name":"Edgware","lettings":false,"sales":true,"commercial":false,"h_email":"sales@josephscott.net","has_email":true,"h_phone":"020 8906 2244","has_phone":true,"resolved_brand_color":"#0033c5","boundary_listing_count":"1","property_count":"198","latitude":51.616132,"longitude":-0.260303},{"core_branch_id":65500,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Link Up Estate Agents","email":null,"sales_phone_number":"01895 814145","address":"5 Hillingdon Parade,\r\nUxbridge Road,\r\nHillingdon,\r\nUxbridge,\r\nUB10 0PE","postcode":"UB10 0PE","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\/65500\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:11.000000Z","updated_at":"2026-01-20T19:55:06.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65500,"agent_company_id":9438,"branch_location":"Uxbridge","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007D7901F6D1A9DCBFF7CABC55D7C34940","agent_brand_id":10334,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 Hillingdon Parade, Uxbridge Road, Hillingdon, Uxbridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Link Up Estate Agents","branch_name":"Uxbridge","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01895 814145","has_phone":true,"resolved_brand_color":"#242e59","boundary_listing_count":"1","property_count":"28","latitude":51.530009,"longitude":-0.447865},{"core_branch_id":58102,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lotus Carlton","email":null,"sales_phone_number":"01582 283990","address":"9 Lyneham Road,\r\nLuton,\r\nLU2 9JS","postcode":"LU2 9JS","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\/58102\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:11.000000Z","updated_at":"2026-01-20T19:57:30.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58102,"agent_company_id":7805,"branch_location":"Luton","lettings_phone_number":"01582 283990","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005CE84A04AA7FD8BF952710768AF14940","agent_brand_id":8661,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 Lyneham Road, Luton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lotus Carlton","branch_name":"Luton","lettings":true,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01582 283990","has_phone":true,"resolved_brand_color":"#004641","boundary_listing_count":"1","property_count":"70","latitude":51.887038,"longitude":-0.382792},{"core_branch_id":59147,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Real Estates","email":"totteridge@realestates-wsp.co.uk","sales_phone_number":"020 8445 3132","address":"32\r\nTotteridge Lane\r\nLondon\r\nN20 9QJ","postcode":"N20 9QJ","website_url":"http:\/\/www.realestates-wsp.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\/59147\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:45.000000Z","updated_at":"2026-01-20T19:55:37.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59147,"agent_company_id":5328,"branch_location":"Totteridge","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A16AF46A80D2C6BFCC0D863AACD04940","agent_brand_id":6109,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"32, Totteridge Lane, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Real Estates","branch_name":"Totteridge","lettings":false,"sales":true,"commercial":false,"h_email":"totteridge@realestates-wsp.co.uk","has_email":true,"h_phone":"020 8445 3132","has_phone":true,"resolved_brand_color":"#0f2823","boundary_listing_count":"1","property_count":"54","latitude":51.630256,"longitude":-0.178299},{"core_branch_id":59205,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Robert Lehrer Properties","email":"robert@robertlehrerproperties.co.uk","sales_phone_number":"020 8340 3005","address":"393\r\nArchway Road\r\nLondon\r\nN6 4ER","postcode":"N6 4ER","website_url":"http:\/\/www.robertlehrerproperties.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\/59205\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:47.000000Z","updated_at":"2026-01-20T19:53:58.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59205,"agent_company_id":9155,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D9B45208E412C3BFC7BAB88D06CA4940","agent_brand_id":10047,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"393, Archway Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Robert Lehrer Properties","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"robert@robertlehrerproperties.co.uk","has_email":true,"h_phone":"020 8340 3005","has_phone":true,"resolved_brand_color":"#502c31","boundary_listing_count":"1","property_count":"30","latitude":51.578325,"longitude":-0.149014},{"core_branch_id":55905,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Rouge Property","email":"leads@rouge-property.co.uk","sales_phone_number":null,"address":"34-36 Lowlands Road,\r\nHarrow,\r\nHA1 3AT","postcode":"HA1 3AT","website_url":"https:\/\/www.rouge-property.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\/55905\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:58.000000Z","updated_at":"2026-01-20T19:56:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55905,"agent_company_id":2387,"branch_location":"Harrow","lettings_phone_number":"020 8515 9860","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EA9788B7CEBFD5BF1BD47E6B27CA4940","agent_brand_id":3012,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"34-36 Lowlands Road, Harrow","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Rouge Property","branch_name":"Harrow","lettings":true,"sales":false,"commercial":false,"h_email":"leads@rouge-property.co.uk","has_email":true,"h_phone":"020 8515 9860","has_phone":true,"resolved_brand_color":"#d0033b","boundary_listing_count":"1","property_count":"25","latitude":51.579328,"longitude":-0.339832},{"core_branch_id":56235,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Savills","email":"amersham@savills.com","sales_phone_number":"01494 787792","address":"55 Hill Avenue,\r\nAmersham,\r\nHP6 5BX","postcode":"HP6 5BX","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\/56235\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:09.000000Z","updated_at":"2026-01-20T19:58:26.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56235,"agent_company_id":33,"branch_location":"Buckinghamshire \u0026 Hertfordshire","lettings_phone_number":"01494 787794","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F5BA4560AC6FE3BFA64412BD8CD64940","agent_brand_id":47,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"55 Hill Avenue, Amersham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Savills","branch_name":"Buckinghamshire \u0026 Hertfordshire","lettings":true,"sales":true,"commercial":false,"h_email":"amersham@savills.com","has_email":true,"h_phone":"01494 787792","has_phone":true,"resolved_brand_color":"#ffe643","boundary_listing_count":"1","property_count":"72","latitude":51.67617,"longitude":-0.607382},{"core_branch_id":66342,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Savills","email":"smendesdacosta@savills.com","sales_phone_number":"01923 725500","address":"11 \r\nChurch Street\r\nRickmansworth\r\nWD3 1BX \r\n \r\n","postcode":"WD3 1BX","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\/66342\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:40.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":66342,"agent_company_id":33,"branch_location":"Rickmansworth","lettings_phone_number":"01923 725566","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000CF8767093202DEBF75C93846B2D14940","agent_brand_id":47,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11, Church Street, Rickmansworth","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Savills","branch_name":"Rickmansworth","lettings":true,"sales":true,"commercial":false,"h_email":"smendesdacosta@savills.com","has_email":true,"h_phone":"01923 725500","has_phone":true,"resolved_brand_color":"#ffe643","boundary_listing_count":"1","property_count":"80","latitude":51.638253,"longitude":-0.468884},{"core_branch_id":65672,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Savills Auctions","email":null,"sales_phone_number":"020 7824 9091","address":"33 \r\nMargaret Street\r\nLondon\r\nW1G 0JD ","postcode":"W1G 0JD","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\/65672\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:17.000000Z","updated_at":"2026-01-20T19:59:54.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65672,"agent_company_id":33,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000876BB587BD50C2BFD3A23EC91DC24940","agent_brand_id":48,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"33, Margaret Street, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Savills Auctions","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 7824 9091","has_phone":true,"resolved_brand_color":"#ffe643","boundary_listing_count":"1","property_count":"387","latitude":51.516534,"longitude":-0.143089},{"core_branch_id":54449,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Smartsale4U","email":null,"sales_phone_number":"020 4572 9091","address":"Suite 331 Kemp House,\r\n152-160,\r\nCity Road,\r\nLondon,\r\nEC1V 2NX","postcode":"EC1V 2NX","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\/54449\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:09.000000Z","updated_at":"2026-01-20T20:00:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54449,"agent_company_id":7394,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000088D7F50B76C3B6BF191D90847DC34940","agent_brand_id":8238,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Suite 331 Kemp House, 152-160, City Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Smartsale4U","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 4572 9091","has_phone":true,"resolved_brand_color":"#79bbff","boundary_listing_count":"1","property_count":"66","latitude":51.527268,"longitude":-0.08892},{"core_branch_id":61755,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"So Resi","email":null,"sales_phone_number":"020 8607 0550","address":"Amber House, \r\nMarket Street Bracknell,\r\nRG12 1LQ","postcode":"RG12 1LQ","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\/61755\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:09.000000Z","updated_at":"2026-01-20T20:01:47.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61755,"agent_company_id":1100,"branch_location":"So Resi","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000009168733BF1AE8BF174850FC18B54940","agent_brand_id":1631,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Amber House, Market Street Bracknell","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"So Resi","branch_name":"So Resi","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 8607 0550","has_phone":true,"resolved_brand_color":"#0ba2e3","boundary_listing_count":"1","property_count":"260","latitude":51.414825,"longitude":-0.753265},{"core_branch_id":54809,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Spencer \u0026 Sener","email":"info@spencerandsener.com","sales_phone_number":"020 8441 7499","address":"14 High Street\r\nHigh Barnet\r\nBarnet\r\nHertfordshire\r\nEN5 5RU","postcode":"EN5 5RU","website_url":"https:\/\/www.spencerandsener.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54809\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.000000Z","updated_at":"2026-01-20T19:53:40.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54809,"agent_company_id":8935,"branch_location":"Barnet","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000004968CBB91457C9BF8928266F80D34940","agent_brand_id":9819,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"14 High Street, High Barnet, Barnet, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Spencer \u0026 Sener","branch_name":"Barnet","lettings":false,"sales":true,"commercial":false,"h_email":"info@spencerandsener.com","has_email":true,"h_phone":"020 8441 7499","has_phone":true,"resolved_brand_color":"#9e0b6d","boundary_listing_count":"1","property_count":"87","latitude":51.652357,"longitude":-0.19797},{"core_branch_id":60519,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Squires Estates","email":"edward@squiresestates.co.uk","sales_phone_number":"020 8349 3030","address":"7 Thornfield Parade,\r\nHolders Hill Road,\r\nLondon,\r\nNW7 1LN","postcode":"NW7 1LN","website_url":"http:\/\/www.squiresestates.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\/60519\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:29.000000Z","updated_at":"2026-01-20T19:54:13.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60519,"agent_company_id":5681,"branch_location":"Mill Hill","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D76B7A50508ACABF82ACA7565FCD4940","agent_brand_id":6480,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"7 Thornfield Parade, Holders Hill Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Squires Estates","branch_name":"Mill Hill","lettings":false,"sales":true,"commercial":false,"h_email":"edward@squiresestates.co.uk","has_email":true,"h_phone":"020 8349 3030","has_phone":true,"resolved_brand_color":"#f0309d","boundary_listing_count":"1","property_count":"46","latitude":51.604472,"longitude":-0.207346}]; 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`; } } }