Estate & Letting Agents in Northaw and Cuffley, Welwyn Hatfield

Find Estate Agents in Northaw and Cuffley, Welwyn Hatfield
35 results
Duncan Perry Estate Agents
Duncan Perry Estate Agents

Brookmans Park

Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
39 total
79 Bradmore Green, Brookmans Park, AL9 7QT
View Featured Profile
Banc Property

Cuffley

Sales
33 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
67 total
1 Station Road, Cuffley, Herts, EN6 4HU
View Profile
Jr Property Services
27 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
67 total
24 Station Road, Cuffley, EN6 4HT
View Profile
Statons Showcase

Barnet

Sales
8 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
52 total
204 High Street, Hadley Green, EN5 5SZ
View Profile
Statons

Brookmans Park

Sales
7 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
52 total
53 Bradmore Green, Brookmans Park, AL9 7QS
View Profile
Statons

Hadley Wood

Sales
6 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
131 total
10 Crescent West, Barnet, EN4 0EJ
View Profile
Absolute Property Agents

Cuffley - Sales

Lettings Sales
4 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
53 total
Sopers House Sopers Road Cuffley EN6 4RY
View Profile
Lanes Exclusive Homes
4 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
64 total
2 Market Street, Hertford, SG14 1BD
View Profile
Andrew Ward

Of Brookmans Park and Potters Bar

Sales
3 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
61 total
35 Bradmore Green, Brookmans Park, AL9 7QR
View Profile
Mi Homes

London

Sales
3 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
89 total
9 Onslow Parade Hampden Square Southgate London N14 5JN
Strutt & Parker

Covering Cornwall

Sales
3 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
71 total
Covering Cornwall
View Profile
Awchilds LTD

London

Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
17 total
96 Farringdon Road, London, EC1R 3EA
View Profile
Barrons Residential LTD
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
20 total
25 The Old Building, Bishops College, Cheshunt, Hertfordshire EN8 9XQ
View Profile
Hamptons

Hertford

Lettings Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
52 total
10-11 Market Place, Hertford, SG14 1DG
View Profile
Hobdays

Potters Bar

Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
53 total
63 Darkes Lane Potters Bar Hertfordshire, EN6 1BJ
View Profile
Home Counties

Potters Bar

Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
52 total
108 High Street Potters Bar EN6 5AT
View Profile
Moveli

-

Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
361 total
21 Ellis Street, London, SW1X 9AL
View Profile
Paul Wallace Estate Agents
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
133 total
The Brookfield Centre, Cheshunt, Hertfordshire, EN8 0NN
View Profile
Statons

Barnet - Sales

Lettings Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
111 total
1 Hadley Parade, High Street, Barnet, EN5 5SX
View Profile
Vanessa Mccallum Estates

Potters Bar

Sales
2 active listings in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
77 total
Maple House, High Street, Potters Bar, EN6 5BS
View Profile
Castles Estate Agents

Enfield

Lettings Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
82 total
243-245 Hertford Road, Enfield, EN3 5JJ
View Profile
Christopher Stokes

Land & New Homes

Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
131 total
10 Newnham Parade, College Road, Cheshunt, Waltham Cross, EN8 9NU
View Profile
First Step

Stotfold

Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
72 total
Waterloo Farm Stotfold Road Arlesey SG15 6XP
View Profile
Greenhill Sales and Lettings Limited
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
22 total
Sopers House Sopers Road, Cuffley, EN6 4RY
Haart

Southgate

Lettings Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
73 total
35-37 Chase Side, Southgate, London, N14 5BP
View Profile
Hawksgrove Estates

Enfield

Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
15 total
Silver Rose, Unit 21 East Lodge Lane, Enfield, EN2 8AS
Nicholas James

Southgate

Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
26 total
34 High Street, London, N14 6EE
View Profile
Robert Adam Estate Agents
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
6 total
30 Station Road, Cuffley, EN6 4HE
Savills

Harpenden

Lettings Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
89 total
2 Station Road, Harpenden, AL5 4SD
View Profile
Steven Oates

Hertford

Lettings Sales
1 active listing in Northaw and Cuffley, Welwyn Hatfield, Hertfordshire, England
306 total
70 Fore Street, Hertford, SG14 1BY
View Profile
Page 1 of 2
initializeAllPremierCards() }); // Load detailed stats function function loadDetailedStats() { const button = document.getElementById('load-more-stats'); const statsContainer = document.getElementById('detailed-stats'); if (statsContainer.classList.contains('hidden')) { // Show loading state button.innerHTML = ` Loading... `; // Make AJAX call for detailed stats const location = 'Northaw and Cuffley, Welwyn Hatfield'; 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":50114,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Duncan Perry Estate Agents","email":"enquiries@duncanperry.co.uk","sales_phone_number":"01707 655466","address":"79 \r\nBradmore Green,\r\nBrookmans Park,\r\nAL9 7QT","postcode":"AL9 7QT","website_url":"http:\/\/www.duncanperry.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\/50114\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T20:01:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50114,"agent_company_id":4290,"branch_location":"Brookmans Park","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000A9BEF38B12F4C9BF47C8409E5DDC4940","agent_brand_id":5021,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"79, Bradmore Green, Brookmans Park","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Duncan Perry Estate Agents","branch_name":"Brookmans Park","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@duncanperry.co.uk","has_email":true,"h_phone":"01707 655466","has_phone":true,"resolved_brand_color":"#b6aac5","boundary_listing_count":"1","property_count":"39","latitude":51.721607,"longitude":-0.202761},{"core_branch_id":54831,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Banc Property","email":"info@bancproperty.com","sales_phone_number":"01707 877781","address":"1 Station Road,\r\nCuffley,\r\nHerts,\r\nEN6 4HU","postcode":"EN6 4HU","website_url":"http:\/\/www.bancproperty.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54831\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.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":54831,"agent_company_id":7005,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003D7E6FD39FFDBCBF8B355CE49EDA4940","agent_brand_id":7844,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 Station Road, Cuffley, Herts","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Banc Property","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":"info@bancproperty.com","has_email":true,"h_phone":"01707 877781","has_phone":true,"resolved_brand_color":"#50bee1","boundary_listing_count":"33","property_count":"67","latitude":51.707974,"longitude":-0.113245},{"core_branch_id":54830,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jr Property Services","email":"cuffley@johnripley.co.uk","sales_phone_number":"01707 872111","address":"24 Station Road,\r\nCuffley,\r\nEN6 4HT","postcode":"EN6 4HT","website_url":"http:\/\/www.jrpropertyservices.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\/54830\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.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":54830,"agent_company_id":7010,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A8E0F08288D4BCBFA1D80A9A96DA4940","agent_brand_id":7849,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"24 Station Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jr Property Services","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":"cuffley@johnripley.co.uk","has_email":true,"h_phone":"01707 872111","has_phone":true,"resolved_brand_color":"#ffe433","boundary_listing_count":"27","property_count":"67","latitude":51.707721,"longitude":-0.112618},{"core_branch_id":54817,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Statons Showcase","email":"newhomes@statons.com","sales_phone_number":"020 8441 9555","address":"204 High Street,\r\nHadley Green,\r\nEN5 5SZ","postcode":"EN5 5SZ","website_url":"https:\/\/www.statons.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54817\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.000000Z","updated_at":"2026-01-20T19:56:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54817,"agent_company_id":4291,"branch_location":"Barnet","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EE7C3F355EBAC9BF6ABC749318D44940","agent_brand_id":5023,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"204 High Street, Hadley Green","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Statons Showcase","branch_name":"Barnet","lettings":false,"sales":true,"commercial":false,"h_email":"newhomes@statons.com","has_email":true,"h_phone":"020 8441 9555","has_phone":true,"resolved_brand_color":"#fde12c","boundary_listing_count":"8","property_count":"52","latitude":51.657,"longitude":-0.201},{"core_branch_id":50113,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Statons","email":"brookmans@statons.com","sales_phone_number":"01707 661144","address":"53 Bradmore Green,\r\nBrookmans Park,\r\nAL9 7QS","postcode":"AL9 7QS","website_url":"https:\/\/www.statons.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50113\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:58:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50113,"agent_company_id":4291,"branch_location":"Brookmans Park","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000073D87DC7F0D8C9BF9FABADD85FDC4940","agent_brand_id":5022,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"53 Bradmore Green, Brookmans Park","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Statons","branch_name":"Brookmans Park","lettings":false,"sales":true,"commercial":false,"h_email":"brookmans@statons.com","has_email":true,"h_phone":"01707 661144","has_phone":true,"resolved_brand_color":"#fde12c","boundary_listing_count":"7","property_count":"52","latitude":51.721675,"longitude":-0.201933},{"core_branch_id":54802,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Statons","email":"hadley@statons.com","sales_phone_number":"020 8440 9797","address":"10 Crescent West,\r\nBarnet,\r\nEN4 0EJ","postcode":"EN4 0EJ","website_url":"https:\/\/www.statons.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54802\/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":54802,"agent_company_id":4291,"branch_location":"Hadley Wood","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000019AF795567B5C6BF488AC8B08AD54940","agent_brand_id":5022,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10 Crescent West, Barnet","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Statons","branch_name":"Hadley Wood","lettings":false,"sales":true,"commercial":false,"h_email":"hadley@statons.com","has_email":true,"h_phone":"020 8440 9797","has_phone":true,"resolved_brand_color":"#fde12c","boundary_listing_count":"6","property_count":"131","latitude":51.668295,"longitude":-0.177411},{"core_branch_id":54832,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Absolute Property Agents","email":"info@absolutepropertyagents.com","sales_phone_number":"020 8882 8156","address":"Sopers House\r\nSopers Road\r\nCuffley\r\nEN6 4RY","postcode":"EN6 4RY","website_url":"https:\/\/www.absolutepropertyagents.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54832\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:56:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54832,"agent_company_id":7003,"branch_location":"Cuffley - Sales","lettings_phone_number":"020 8882 8156","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008195438B6CE7BBBFD122DBF97EDA4940","agent_brand_id":7842,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Sopers House, Sopers Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Absolute Property Agents","branch_name":"Cuffley - Sales","lettings":true,"sales":true,"commercial":false,"h_email":"info@absolutepropertyagents.com","has_email":true,"h_phone":"020 8882 8156","has_phone":true,"resolved_brand_color":"#3b2404","boundary_listing_count":"4","property_count":"53","latitude":51.707,"longitude":-0.109},{"core_branch_id":62940,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lanes Exclusive Homes","email":"herts@lanesexclusivehomes.co.uk","sales_phone_number":"01992 940955","address":"2 Market Street,\r\nHertford,\r\nSG14 1BD","postcode":"SG14 1BD","website_url":"https:\/\/lanesproperty.co.uk\/exclusive-homes\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62940\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.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":62940,"agent_company_id":1397,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000187B2FBE688FB3BF27DA5548F9E54940","agent_brand_id":1951,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Market Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lanes Exclusive Homes","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"herts@lanesexclusivehomes.co.uk","has_email":true,"h_phone":"01992 940955","has_phone":true,"resolved_brand_color":"#20125f","boundary_listing_count":"4","property_count":"64","latitude":51.79667,"longitude":-0.076407},{"core_branch_id":50112,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Andrew Ward","email":"brookmanspark@andrewward.co.uk","sales_phone_number":"01707 649779","address":"35 Bradmore Green,\r\nBrookmans Park,\r\nAL9 7QR","postcode":"AL9 7QR","website_url":"http:\/\/www.andrewward.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\/50112\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:52:25.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50112,"agent_company_id":4289,"branch_location":"Of Brookmans Park and Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F98557923CD7C9BFEF1EA0FB72DC4940","agent_brand_id":5020,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"35 Bradmore Green, Brookmans Park","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Andrew Ward","branch_name":"Of Brookmans Park and Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"brookmanspark@andrewward.co.uk","has_email":true,"h_phone":"01707 649779","has_phone":true,"resolved_brand_color":"#f469a1","boundary_listing_count":"3","property_count":"61","latitude":51.722259,"longitude":-0.201881},{"core_branch_id":59055,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mi Homes","email":"nicholas@mi-homes.co.uk","sales_phone_number":null,"address":"9 Onslow Parade\r\nHampden Square\r\nSouthgate London\r\nN14 5JN","postcode":"N14 5JN","website_url":"https:\/\/mi-homes.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\/59055\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:42.000000Z","updated_at":"2026-01-20T19:53:56.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59055,"agent_company_id":778,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B29C84D21742C2BF7429AE2AFBD04940","agent_brand_id":1265,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 Onslow Parade, Hampden Square, Southgate London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mi Homes","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"nicholas@mi-homes.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#93b442","boundary_listing_count":"3","property_count":"89","latitude":51.632665,"longitude":-0.142642},{"core_branch_id":67529,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Strutt \u0026 Parker","email":"ian.friend@struttandparker.co.uk","sales_phone_number":"07760 998597","address":"Covering Cornwall","postcode":null,"website_url":"https:\/\/www.struttandparker.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/67529\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:17.000000Z","updated_at":"2025-12-12T07:53:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":67529,"agent_company_id":257,"branch_location":"Covering Cornwall","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003BFC3559A31E13C0BC94BA641C2D4940","agent_brand_id":547,"offers_sales":true,"offers_lettings":false,"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":"Strutt \u0026 Parker","branch_name":"Covering Cornwall","lettings":false,"sales":true,"commercial":false,"h_email":"ian.friend@struttandparker.co.uk","has_email":true,"h_phone":"07760 998597","has_phone":true,"resolved_brand_color":"#cb1144","boundary_listing_count":"3","property_count":"71","latitude":50.352429,"longitude":-4.77992},{"core_branch_id":54436,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Awchilds LTD","email":"info@awchilds.co.uk","sales_phone_number":"020 3693 9444","address":"96 Farringdon Road,\r\nLondon,\r\nEC1R 3EA","postcode":"EC1R 3EA","website_url":"https:\/\/www.awchilds.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\/54436\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:09.000000Z","updated_at":"2026-01-20T19:53:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54436,"agent_company_id":6399,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000ECDE8AC40435BCBF9A94826E2FC34940","agent_brand_id":7221,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"96 Farringdon Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Awchilds LTD","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"info@awchilds.co.uk","has_email":true,"h_phone":"020 3693 9444","has_phone":true,"resolved_brand_color":"#fd039f","boundary_listing_count":"2","property_count":"17","latitude":51.524885,"longitude":-0.110184},{"core_branch_id":54847,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Barrons Residential LTD","email":"sales@barronsresidential.co.uk","sales_phone_number":"01992 845842","address":"25 The Old Building,\r\nBishops College,\r\nCheshunt,\r\nHertfordshire\r\nEN8 9XQ","postcode":"EN8 9XQ","website_url":"https:\/\/www.barronsresidential.co.uk\/value.html","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54847\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:57:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54847,"agent_company_id":9378,"branch_location":"Cheshunt","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000DB4E5B238271A8BF1E3691990BDA4940","agent_brand_id":10274,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"25 The Old Building, Bishops College, Cheshunt, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Barrons Residential LTD","branch_name":"Cheshunt","lettings":false,"sales":true,"commercial":false,"h_email":"sales@barronsresidential.co.uk","has_email":true,"h_phone":"01992 845842","has_phone":true,"resolved_brand_color":"#20325d","boundary_listing_count":"2","property_count":"20","latitude":51.703479,"longitude":-0.047741},{"core_branch_id":62943,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hamptons","email":"Nadya.basrawi@hamptons.co.uk","sales_phone_number":"01992 939249","address":"10-11 Market Place,\r\nHertford,\r\nSG14 1DG","postcode":"SG14 1DG","website_url":"https:\/\/www.hamptons.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\/62943\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:58:34.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62943,"agent_company_id":248,"branch_location":"Hertford","lettings_phone_number":"01992 949295","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EE5A423EE8D9BCBFB515FBCBEEE94940","agent_brand_id":533,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10-11 Market Place, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hamptons","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"Nadya.basrawi@hamptons.co.uk","has_email":true,"h_phone":"01992 939249","has_phone":true,"resolved_brand_color":"#14294c","boundary_listing_count":"2","property_count":"52","latitude":51.8276,"longitude":-0.1127},{"core_branch_id":54824,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hobdays","email":"pottersbar@hobdays.co.uk","sales_phone_number":"01707 663330","address":"63 Darkes Lane\r\n\r\nPotters Bar\r\nHertfordshire, EN6 1BJ","postcode":"EN6 1BJ","website_url":"http:\/\/www.hobdays.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\/54824\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.000000Z","updated_at":"2026-01-20T19:55:04.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54824,"agent_company_id":7008,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C367EBE0606FC8BF83F755B950D94940","agent_brand_id":7847,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"63 Darkes Lane, Potters Bar, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hobdays","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"pottersbar@hobdays.co.uk","has_email":true,"h_phone":"01707 663330","has_phone":true,"resolved_brand_color":"#012260","boundary_listing_count":"2","property_count":"53","latitude":51.697776,"longitude":-0.190899},{"core_branch_id":54836,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Home Counties","email":"info@home-counties.com","sales_phone_number":"01707 245555","address":"108 \r\nHigh Street\r\nPotters Bar\r\nEN6 5AT ","postcode":"EN6 5AT","website_url":"http:\/\/www.home-counties.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54836\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.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":54836,"agent_company_id":7009,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000097900F7A36ABC6BF99840B7904D94940","agent_brand_id":7848,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"108, High Street, Potters Bar","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Home Counties","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"info@home-counties.com","has_email":true,"h_phone":"01707 245555","has_phone":true,"resolved_brand_color":"#eb5e0b","boundary_listing_count":"2","property_count":"52","latitude":51.695449,"longitude":-0.1771},{"core_branch_id":64351,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Moveli","email":"hello@moveli.co.uk","sales_phone_number":"020 3150 0733","address":"21 Ellis Street,\r\nLondon,\r\nSW1X 9AL","postcode":"SW1X 9AL","website_url":"http:\/\/www.moveli.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\/64351\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:33.000000Z","updated_at":"2026-01-20T19:54:53.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":64351,"agent_company_id":1575,"branch_location":"-","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000002D978DCEF929C4BFA08B868C47BF4940","agent_brand_id":2150,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21 Ellis Street, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Moveli","branch_name":"-","lettings":false,"sales":true,"commercial":false,"h_email":"hello@moveli.co.uk","has_email":true,"h_phone":"020 3150 0733","has_phone":true,"resolved_brand_color":"#a2a0a0","boundary_listing_count":"2","property_count":"361","latitude":51.494371,"longitude":-0.157531},{"core_branch_id":54840,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Paul Wallace Estate Agents","email":"cheshunt@paulwallace.co.uk","sales_phone_number":"01992 781100","address":"The Brookfield Centre,\r\nCheshunt,\r\nHertfordshire,\r\nEN8 0NN","postcode":"EN8 0NN","website_url":"http:\/\/www.paulwallace.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\/54840\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.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":54840,"agent_company_id":1399,"branch_location":"Cheshunt","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000038143E5B0707A3BFEBFF1CE6CBDB4940","agent_brand_id":1953,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"The Brookfield Centre, Cheshunt, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Paul Wallace Estate Agents","branch_name":"Cheshunt","lettings":false,"sales":true,"commercial":false,"h_email":"cheshunt@paulwallace.co.uk","has_email":true,"h_phone":"01992 781100","has_phone":true,"resolved_brand_color":"#236937","boundary_listing_count":"2","property_count":"133","latitude":51.71716,"longitude":-0.037163},{"core_branch_id":54815,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Statons","email":"barnet@statons.com","sales_phone_number":"020 8449 3383","address":"1 Hadley Parade,\r\nHigh Street,\r\nBarnet,\r\nEN5 5SX","postcode":"EN5 5SX","website_url":"https:\/\/www.statons.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54815\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.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":54815,"agent_company_id":4291,"branch_location":"Barnet - Sales","lettings_phone_number":"020 8441 9796","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006902452C62D8C9BF15C616821CD44940","agent_brand_id":5022,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 Hadley Parade, High Street, Barnet","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Statons","branch_name":"Barnet - Sales","lettings":true,"sales":true,"commercial":false,"h_email":"barnet@statons.com","has_email":true,"h_phone":"020 8449 3383","has_phone":true,"resolved_brand_color":"#fde12c","boundary_listing_count":"2","property_count":"111","latitude":51.65712,"longitude":-0.201916},{"core_branch_id":54838,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Vanessa Mccallum Estates","email":"sales@vanessamccallumestates.co.uk","sales_phone_number":"01707 320432","address":"Maple House,\r\nHigh Street,\r\nPotters Bar,\r\nEN6 5BS","postcode":"EN6 5BS","website_url":"https:\/\/www.vanessamccallumestates.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\/54838\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:53:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":54838,"agent_company_id":7014,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005C001AA54BFFC6BFEEAF1EF7ADD84940","agent_brand_id":7853,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Maple House, High Street, Potters Bar","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Vanessa Mccallum Estates","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"sales@vanessamccallumestates.co.uk","has_email":true,"h_phone":"01707 320432","has_phone":true,"resolved_brand_color":"#8154ad","boundary_listing_count":"2","property_count":"77","latitude":51.692809,"longitude":-0.179666},{"core_branch_id":54795,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Castles Estate Agents","email":"enfield@castles.london","sales_phone_number":"020 8804 8000","address":"243-245 Hertford Road,\r\nEnfield,\r\nEN3 5JJ","postcode":"EN3 5JJ","website_url":"http:\/\/www.castles-estateagents.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\/54795\/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":54795,"agent_company_id":3641,"branch_location":"Enfield","lettings_phone_number":null,"is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B05582C5E1CCA7BF342F87DD77D44940","agent_brand_id":4332,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"243-245 Hertford Road, Enfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Castles Estate Agents","branch_name":"Enfield","lettings":true,"sales":true,"commercial":false,"h_email":"enfield@castles.london","has_email":true,"h_phone":"020 8804 8000","has_phone":true,"resolved_brand_color":"#a20133","boundary_listing_count":"1","property_count":"82","latitude":51.659908,"longitude":-0.046485},{"core_branch_id":54846,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Christopher Stokes","email":"info@christopherstokes.co.uk","sales_phone_number":"01992 641500","address":"10 Newnham Parade,\r\nCollege Road,\r\nCheshunt,\r\nWaltham Cross,\r\nEN8 9NU","postcode":"EN8 9NU","website_url":"https:\/\/www.christopherstokes.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\/54846\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:53:13.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54846,"agent_company_id":1393,"branch_location":"Land \u0026 New Homes","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B4739A05DA1DA2BFC493DDCCE8D94940","agent_brand_id":1945,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10 Newnham Parade, College Road, Cheshunt, Waltham Cross","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Christopher Stokes","branch_name":"Land \u0026 New Homes","lettings":false,"sales":true,"commercial":false,"h_email":"info@christopherstokes.co.uk","has_email":true,"h_phone":"01992 641500","has_phone":true,"resolved_brand_color":"#a0284c","boundary_listing_count":"1","property_count":"131","latitude":51.702417,"longitude":-0.035384},{"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":"72","latitude":52.025482,"longitude":-0.250657},{"core_branch_id":54833,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Greenhill Sales and Lettings Limited","email":null,"sales_phone_number":"01707 802001","address":"Sopers House Sopers Road,\r\nCuffley,\r\nEN6 4RY","postcode":"EN6 4RY","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\/54833\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:57:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54833,"agent_company_id":7007,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008195438B6CE7BBBFD122DBF97EDA4940","agent_brand_id":7846,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Sopers House Sopers Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Greenhill Sales and Lettings Limited","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01707 802001","has_phone":true,"resolved_brand_color":"#143635","boundary_listing_count":"1","property_count":"22","latitude":51.707,"longitude":-0.109},{"core_branch_id":59053,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"southgate.lettings@haart.co.uk","sales_phone_number":"020 8886 4444","address":"35-37 Chase Side,\r\nSouthgate,\r\nLondon,\r\nN14 5BP","postcode":"N14 5BP","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\/59053\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:42.000000Z","updated_at":"2026-01-20T19:56:15.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59053,"agent_company_id":163,"branch_location":"Southgate","lettings_phone_number":"020 4512 8372","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A4703D0AD7A3C0BF1B2FDD2406D14940","agent_brand_id":405,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"35-37 Chase Side, Southgate, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Southgate","lettings":true,"sales":true,"commercial":false,"h_email":"southgate.lettings@haart.co.uk","has_email":true,"h_phone":"020 8886 4444","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"1","property_count":"73","latitude":51.633,"longitude":-0.13},{"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":59063,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Nicholas James","email":"James@njestates.co.uk","sales_phone_number":"020 8886 9462","address":"34 High Street,\r\nLondon,\r\nN14 6EE","postcode":"N14 6EE","website_url":"http:\/\/www.njestates.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\/59063\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:42.000000Z","updated_at":"2026-01-20T19:56:02.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59063,"agent_company_id":780,"branch_location":"Southgate","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000423F53AF5B04C0BFD32D3BC43FD04940","agent_brand_id":1267,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"34 High Street, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Nicholas James","branch_name":"Southgate","lettings":false,"sales":true,"commercial":false,"h_email":"James@njestates.co.uk","has_email":true,"h_phone":"020 8886 9462","has_phone":true,"resolved_brand_color":"#1e1d1d","boundary_listing_count":"1","property_count":"26","latitude":51.626946,"longitude":-0.125133},{"core_branch_id":54829,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Robert Adam Estate Agents","email":null,"sales_phone_number":"01707 873126","address":"30 Station Road, \r\nCuffley, \r\nEN6 4HE\r\n","postcode":"EN6 4HE","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\/54829\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:21.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":54829,"agent_company_id":7013,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000323CF6B3588ABCBF8E05854199DA4940","agent_brand_id":7852,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"30 Station Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Robert Adam Estate Agents","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01707 873126","has_phone":true,"resolved_brand_color":"#0b4132","boundary_listing_count":"1","property_count":"6","latitude":51.707802,"longitude":-0.111486},{"core_branch_id":50094,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Savills","email":"d.carnell@savills.com","sales_phone_number":"01582 465000","address":"2 Station Road,\r\nHarpenden,\r\nAL5 4SD","postcode":"AL5 4SD","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\/50094\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:56:50.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50094,"agent_company_id":33,"branch_location":"Harpenden","lettings_phone_number":"01582 465020","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003ECBF3E0EEACD6BF27D9EA724AE84940","agent_brand_id":47,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Station Road, Harpenden","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Savills","branch_name":"Harpenden","lettings":true,"sales":true,"commercial":false,"h_email":"d.carnell@savills.com","has_email":true,"h_phone":"01582 465000","has_phone":true,"resolved_brand_color":"#ffe643","boundary_listing_count":"1","property_count":"89","latitude":51.814772,"longitude":-0.354305},{"core_branch_id":62941,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Steven Oates","email":"info@stevenoates.com","sales_phone_number":"01992 303300","address":"70 Fore Street,\r\nHertford,\r\nSG14 1BY","postcode":"SG14 1BY","website_url":"http:\/\/www.stevenoates.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62941\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:54:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62941,"agent_company_id":1534,"branch_location":"Hertford","lettings_phone_number":"01992 303300","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000DBFD2AC0779BB3BF785E2A36E6E54940","agent_brand_id":2107,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"70 Fore Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Steven Oates","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"info@stevenoates.com","has_email":true,"h_phone":"01992 303300","has_phone":true,"resolved_brand_color":"#d32850","boundary_listing_count":"1","property_count":"306","latitude":51.796088,"longitude":-0.076591}]; 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`; } } }