Estate Agents in Welwyn Hatfield, Hertfordshire

Find Estate Agents in Welwyn Hatfield, Hertfordshire
133 results
Compare Best Local Agents
Haart
Haart

Welwyn Garden City

Sales
26 active listings in Welwyn Hatfield, Hertfordshire, England
27 total
23 Stonehills, Welwyn Garden City, AL8 6NA
View Profile
Ashtons
Ashtons

Land & New Homes

Sales
23 active listings in Welwyn Hatfield, Hertfordshire, England
111 total
32 Bridge Street Hitchin SG5 2DF
View Profile
Putterills
Putterills

Knebworth

Sales
20 active listings in Welwyn Hatfield, Hertfordshire, England
83 total
123 London Road, Knebworth, SG3 6EX
View Profile
Moving Places
Moving Places

Hatfield

Sales
19 active listings in Welwyn Hatfield, Hertfordshire, England
3 Parkhouse Court, Hatfield, AL10 9RQ
View Profile
Country Properties
Country Properties

Hatfield

Sales
18 active listings in Welwyn Hatfield, Hertfordshire, England
21 total
7 The Broadway, Old Hatfield, AL9 5BG
View Profile
Larkham & Pike
Larkham & Pike

Hatfield

Sales
18 active listings in Welwyn Hatfield, Hertfordshire, England
7 The Arcade, Hatfield, Hertfordshire, AL10 0JY
View Profile
Strats Estates & Lettings
Strats Estates & Lettings

Hatfield

Sales
16 active listings in Welwyn Hatfield, Hertfordshire, England
17 total
11 Harpsfield Broadway, Comet Way, Hatfield, AL10 9TF
View Profile
Purplebricks
Purplebricks

Covering Chester & Wirral

Lettings Sales
15 active listings in Welwyn Hatfield, Hertfordshire, England
7,992 total
Purplebricks, 146 Freston Road, London, W10 6TR
View Profile
So Resi
So Resi

So Resi

Sales
13 active listings in Welwyn Hatfield, Hertfordshire, England
261 total
Amber House, Market Street Bracknell, RG12 1LQ
View Profile
Sown
Sown

Nationwide

Sales
13 active listings in Welwyn Hatfield, Hertfordshire, England
349 total
Building 1, Meadows Business Park, Blackwater, Camberley GU17 9AB
View Profile
Connells
Connells

Marshalswick

Sales
11 active listings in Welwyn Hatfield, Hertfordshire, England
42 total
5 Wycombe Place Marshalswick St. Albans AL4 9RH
View Profile
Carnegie
Carnegie

Welwyn Garden City

Sales
10 active listings in Welwyn Hatfield, Hertfordshire, England
19 total
131 Handside Lane Welwyn Garden City AL8 6TA
View Profile
Savills
Savills

Harpenden

Lettings Sales
9 active listings in Welwyn Hatfield, Hertfordshire, England
71 total
2 Station Road, Harpenden, AL5 4SD
View Profile
Statons Showcase
Statons Showcase

Barnet

Sales
9 active listings in Welwyn Hatfield, Hertfordshire, England
52 total
204 High Street, Hadley Green, EN5 5SZ
View Profile
Simply Homes
Simply Homes

Hertford

Sales
8 active listings in Welwyn Hatfield, Hertfordshire, England
35 total
114-116 Fore Street Hertford SG14 1AJ
View Profile
Yopa
Yopa

Nationwide

Sales
8 active listings in Welwyn Hatfield, Hertfordshire, England
7,222 total
Meridian House Wheatfield Way Hinckley LE10 1YG
View Profile
Absolute Property Agents
Absolute Property Agents

Cuffley - Sales

Lettings Sales
7 active listings in Welwyn Hatfield, Hertfordshire, England
47 total
Sopers House Sopers Road Cuffley EN6 4RY
View Profile
Home Counties
Home Counties

Potters Bar

Sales
7 active listings in Welwyn Hatfield, Hertfordshire, England
47 total
108 High Street Potters Bar EN6 5AT
View Profile
Statons
Statons

Hadley Wood

Sales
7 active listings in Welwyn Hatfield, Hertfordshire, England
130 total
10 Crescent West, Barnet, EN4 0EJ
View Profile
Keaze Limited
Keaze Limited

London

Sales
6 active listings in Welwyn Hatfield, Hertfordshire, England
196 total
2nd Floor Balfour House 46-54 Great Titchfield Street London W1W 7QA
View Profile
Mccarthy & Stone Resales
Mccarthy & Stone Resales

-

Sales
6 active listings in Welwyn Hatfield, Hertfordshire, England
1,334 total
100 Holdenhurst Road, Bournemouth, BH8 8AQ
View Profile
Auckland Estates Limited
Auckland Estates Limited

Potters Bar

Sales
5 active listings in Welwyn Hatfield, Hertfordshire, England
68 total
36 The Broadway, Darkes Lane, Potters Bar, EN6 2HW
View Profile
Bradford & Howley
Bradford & Howley

Marshalswick

Sales
5 active listings in Welwyn Hatfield, Hertfordshire, England
48 total
5 The Quadrant, Marshalswick, St. Albans, AL4 9RA
View Profile
Lanes Exclusive Homes
Lanes Exclusive Homes

Hertford

Sales
5 active listings in Welwyn Hatfield, Hertfordshire, England
64 total
2 Market Street, Hertford, SG14 1BD
View Profile
Alexander Bond & Company
Alexander Bond & Company

Knebworth

Lettings Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
32 total
The Old Estates Office, Pondcroft Road, Knebworth, SG3 6DB
View Profile
Cassidy & Tate
Cassidy & Tate

Marshalswick

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
44 total
59 The Quadrant Marshalswick St. Albans AL4 9RD
View Profile
Herts Homes
Herts Homes

St. Albans

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
10 total
Arquen House 4-6 Spicer Street St Albans Hertfordshire AL3 4PQ
View Profile
Hobdays
Hobdays

Potters Bar

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
39 total
63 Darkes Lane Potters Bar Hertfordshire, EN6 1BJ
View Profile
Raine & Co
Raine & Co

Potters Bar

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
41 total
11 Darkes Lane Potters Bar EN6 1AJ
View Profile
Welham Estates
Welham Estates

Welham Green

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
2 Fourways Market, Welham Green, North Mymms, AL9 7DU
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 = 'Welwyn Hatfield, Hertfordshire'; const agentType = 'sales'; fetch(`/api/agents/detailed-stats?location=${encodeURIComponent(location)}&type=${agentType}`) .then(response => response.json()) .then(data => { // Build detailed stats HTML let statsHtml = '
'; // Property types breakdown if (data.propertyTypes && Object.keys(data.propertyTypes).length > 0) { statsHtml += `
Property Types
`; for (const [type, count] of Object.entries(data.propertyTypes)) { const percentage = Math.round((count / data.totalProperties) * 100); statsHtml += `
${type}: ${count.toLocaleString()} (${percentage}%)
`; } statsHtml += '
'; } // Price ranges if (data.priceRanges) { statsHtml += `
Price Ranges
Avg Sale Price: £${data.priceRanges.avgSalePrice?.toLocaleString() || 'N/A'}
Avg Rent PCM: £${data.priceRanges.avgRentPrice?.toLocaleString() || 'N/A'}
`; } // Top performing agents if (data.topAgents && data.topAgents.length > 0) { statsHtml += `
Top Agents
`; data.topAgents.slice(0, 3).forEach(agent => { statsHtml += `
${agent.name}: ${agent.property_count} props
`; }); statsHtml += '
'; } statsHtml += '
'; // Show stats statsContainer.innerHTML = statsHtml; statsContainer.classList.remove('hidden'); // Update button button.innerHTML = ` Hide Insights `; }) .catch(error => { // If API fails, show some calculated stats from existing data const agents = [{"core_branch_id":50099,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"0221@spicerhaart.com","sales_phone_number":"01707 708023","address":"23 Stonehills,\r\nWelwyn Garden City,\r\nAL8 6NA","postcode":"AL8 6NA","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\/50099\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:57:33.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50099,"agent_company_id":163,"branch_location":"Welwyn Garden City","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000093C49272F739CABF9B215514AFE64940","agent_brand_id":405,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"23 Stonehills, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Welwyn Garden City","lettings":false,"sales":true,"commercial":false,"h_email":"0221@spicerhaart.com","has_email":true,"h_phone":"01707 708023","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"26","property_count":"27","latitude":51.802218,"longitude":-0.204894},{"core_branch_id":62995,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ashtons","email":"joshua.bland@ashtons.co.uk","sales_phone_number":"01707 903456","address":"32\r\nBridge Street\r\nHitchin\r\nSG5 2DF","postcode":"SG5 2DF","website_url":"https:\/\/www.ashtons.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\/62995\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:49.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":62995,"agent_company_id":1795,"branch_location":"Land \u0026 New Homes","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000657094BC3AC7D1BF00E65AB400F94940","agent_brand_id":2386,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"32, Bridge Street, Hitchin","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ashtons","branch_name":"Land \u0026 New Homes","lettings":false,"sales":true,"commercial":false,"h_email":"joshua.bland@ashtons.co.uk","has_email":true,"h_phone":"01707 903456","has_phone":true,"resolved_brand_color":"#babc9a","boundary_listing_count":"23","property_count":"111","latitude":51.945334,"longitude":-0.277785},{"core_branch_id":62974,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Putterills","email":"ricky@putterills.co.uk","sales_phone_number":"01438 817007","address":"123 London Road,\r\nKnebworth,\r\nSG3 6EX","postcode":"SG3 6EX","website_url":"https:\/\/www.putterills.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\/62974\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:48.000000Z","updated_at":"2026-01-20T19:57:10.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62974,"agent_company_id":6255,"branch_location":"Knebworth","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BB9C12109370C7BF5A0EF450DBEE4940","agent_brand_id":7074,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"123 London Road, Knebworth","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Putterills","branch_name":"Knebworth","lettings":false,"sales":true,"commercial":false,"h_email":"ricky@putterills.co.uk","has_email":true,"h_phone":"01438 817007","has_phone":true,"resolved_brand_color":"#822829","boundary_listing_count":"20","property_count":"83","latitude":51.866068,"longitude":-0.183123},{"core_branch_id":50063,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Moving Places","email":"info@moving-places.com","sales_phone_number":"01707 266176","address":"3 Parkhouse Court,\r\nHatfield,\r\nAL10 9RQ","postcode":"AL10 9RQ","website_url":"http:\/\/www.moving-places.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50063\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50063,"agent_company_id":5666,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000003B16CE690D4CEBF9B58E02BBAE14940","agent_brand_id":6462,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"3 Parkhouse Court, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Moving Places","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"info@moving-places.com","has_email":true,"h_phone":"01707 266176","has_phone":true,"resolved_brand_color":"#6d2461","boundary_listing_count":"19","property_count":"19","latitude":51.763494,"longitude":-0.240862},{"core_branch_id":50109,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Country Properties","email":"hatfield@country-properties.co.uk","sales_phone_number":null,"address":"7 The Broadway,\r\nOld Hatfield,\r\nAL9 5BG","postcode":"AL9 5BG","website_url":"http:\/\/www.country-properties.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\/50109\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50109,"agent_company_id":98,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000057790261A758CBBFF984ECBC8DE14940","agent_brand_id":289,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"7 The Broadway, Old Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Country Properties","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"hatfield@country-properties.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#00463c","boundary_listing_count":"18","property_count":"21","latitude":51.762138,"longitude":-0.213643},{"core_branch_id":50059,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Larkham \u0026 Pike","email":"mail@pikes-estateagents.co.uk","sales_phone_number":"01707 260707","address":"7 The Arcade,\r\nHatfield,\r\nHertfordshire,\r\nAL10 0JY","postcode":"AL10 0JY","website_url":"https:\/\/www.pikes-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\/50059\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50059,"agent_company_id":5664,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006A882AFC19DECCBFFFCC203EB0E14940","agent_brand_id":6460,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"7 The Arcade, Hatfield, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Larkham \u0026 Pike","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"mail@pikes-estateagents.co.uk","has_email":true,"h_phone":"01707 260707","has_phone":true,"resolved_brand_color":"#8cb390","boundary_listing_count":"18","property_count":"18","latitude":51.763191,"longitude":-0.225528},{"core_branch_id":50064,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Strats Estates \u0026 Lettings","email":"info@strats-estates.co.uk","sales_phone_number":"01707 262737","address":"11 Harpsfield Broadway,\r\nComet Way,\r\nHatfield,\r\nAL10 9TF","postcode":"AL10 9TF","website_url":"https:\/\/www.strats-estates.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50064\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50064,"agent_company_id":5668,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000014419C871398CEBFD4BA0D6ABFE14940","agent_brand_id":6464,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11 Harpsfield Broadway, Comet Way, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Strats Estates \u0026 Lettings","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"info@strats-estates.co.uk","has_email":true,"h_phone":"01707 262737","has_phone":true,"resolved_brand_color":"#8b8362","boundary_listing_count":"16","property_count":"17","latitude":51.763654,"longitude":-0.239016},{"core_branch_id":65570,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Purplebricks","email":"Iain.strachan@purplebricks.com","sales_phone_number":"020 4540 1660","address":"Purplebricks,\r\n146 Freston Road, \r\nLondon, \r\nW10 6TR","postcode":"W10 6TR","website_url":"https:\/\/www.purplebricks.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\/65570\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:13.000000Z","updated_at":"2026-01-20T19:59:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65570,"agent_company_id":116,"branch_location":"Covering Chester \u0026 Wirral","lettings_phone_number":"020 4515 5070","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008195438B6CE7CBBFA8C64B3789C14940","agent_brand_id":338,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Purplebricks, 146 Freston Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Purplebricks","branch_name":"Covering Chester \u0026 Wirral","lettings":true,"sales":true,"commercial":false,"h_email":"Iain.strachan@purplebricks.com","has_email":true,"h_phone":"020 4540 1660","has_phone":true,"resolved_brand_color":"#860495","boundary_listing_count":"15","property_count":"7992","latitude":51.512,"longitude":-0.218},{"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":"13","property_count":"261","latitude":51.414825,"longitude":-0.753265},{"core_branch_id":55720,"verification_status":"verified","verified_at":"2026-02-02T10:33:14.000000Z","verified_by":null,"verification_notes":null,"name":"Sown","email":"newhomesenquiries@romans.co.uk","sales_phone_number":"0238 082 0121","address":"Building 1, Meadows Business Park, Blackwater, Camberley GU17 9AB","postcode":"GU17 9AB","website_url":"http:\/\/www.leaders.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\/55720\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:52.000000Z","updated_at":"2026-02-02T10:46:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55720,"agent_company_id":168,"branch_location":"Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EF737CB438E3E8BF8544DAC69FAA4940","agent_brand_id":436,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Building 1, Meadows Business Park, Blackwater, Camberley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Sown","branch_name":"Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"newhomesenquiries@romans.co.uk","has_email":true,"h_phone":"0238 082 0121","has_phone":true,"resolved_brand_color":"#23325f","boundary_listing_count":"13","property_count":"349","latitude":51.333001,"longitude":-0.777737},{"core_branch_id":50081,"verification_status":"verified","verified_at":"2026-02-05T16:55:52.000000Z","verified_by":null,"verification_notes":null,"name":"Connells","email":"marshalswick@connells.co.uk","sales_phone_number":"01727 851100","address":"5 Wycombe Place\r\nMarshalswick\r\nSt. Albans\r\nAL4 9RH ","postcode":"AL4 9RH","website_url":"http:\/\/www.connells.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\/50081\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-02-05T16:58:43.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50081,"agent_company_id":1,"branch_location":"Marshalswick","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000004029D499BAAD3BF628731E9EFE14940","agent_brand_id":4,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 Wycombe Place, Marshalswick, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Connells","branch_name":"Marshalswick","lettings":false,"sales":true,"commercial":false,"h_email":"marshalswick@connells.co.uk","has_email":true,"h_phone":"01727 851100","has_phone":true,"resolved_brand_color":"#cc1e23","boundary_listing_count":"11","property_count":"42","latitude":51.765134,"longitude":-0.307288},{"core_branch_id":50106,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Carnegie","email":"post@carnegieuk.com","sales_phone_number":"01438 716060","address":"131 \r\nHandside Lane\r\nWelwyn Garden City\r\nAL8 6TA ","postcode":"AL8 6TA","website_url":"http:\/\/www.carnegieuk.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50106\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50106,"agent_company_id":6254,"branch_location":"Welwyn Garden City","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BC0853944BE3CBBF74CFBA46CBE54940","agent_brand_id":7073,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"131, Handside Lane, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Carnegie","branch_name":"Welwyn Garden City","lettings":false,"sales":true,"commercial":false,"h_email":"post@carnegieuk.com","has_email":true,"h_phone":"01438 716060","has_phone":true,"resolved_brand_color":"#4fb8e6","boundary_listing_count":"10","property_count":"19","latitude":51.795266,"longitude":-0.217874},{"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":"9","property_count":"71","latitude":51.814772,"longitude":-0.354305},{"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":"9","property_count":"52","latitude":51.657,"longitude":-0.201},{"core_branch_id":62937,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Simply Homes","email":"steven@simplyhomes.biz","sales_phone_number":"01992 558557","address":"114-116 Fore Street\r\nHertford\r\nSG14 1AJ","postcode":"SG14 1AJ","website_url":"https:\/\/www.simply-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\/62937\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:58:22.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62937,"agent_company_id":1533,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006B44300E2E1DB3BF7A008BFCFAE54940","agent_brand_id":2106,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"114-116 Fore Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Simply Homes","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"steven@simplyhomes.biz","has_email":true,"h_phone":"01992 558557","has_phone":true,"resolved_brand_color":"#cc6049","boundary_listing_count":"8","property_count":"35","latitude":51.796722,"longitude":-0.074664},{"core_branch_id":57439,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Yopa","email":"aimee.boston@yopa.co.uk","sales_phone_number":"01923 381187","address":"Meridian House\r\nWheatfield Way\r\nHinckley\r\nLE10 1YG","postcode":"LE10 1YG","website_url":"https:\/\/www.yopa.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\/57439\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:48.000000Z","updated_at":"2026-01-20T19:57:00.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57439,"agent_company_id":8351,"branch_location":"Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000029EB3713D305F6BFF52A323A20474A40","agent_brand_id":9221,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Meridian House, Wheatfield Way, Hinckley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Yopa","branch_name":"Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"aimee.boston@yopa.co.uk","has_email":true,"h_phone":"01923 381187","has_phone":true,"resolved_brand_color":"#56c5cd","boundary_listing_count":"8","property_count":"7222","latitude":52.555671,"longitude":-1.376422},{"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":"7","property_count":"47","latitude":51.707,"longitude":-0.109},{"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":"7","property_count":"47","latitude":51.695449,"longitude":-0.1771},{"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":"7","property_count":"130","latitude":51.668295,"longitude":-0.177411},{"core_branch_id":65858,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Keaze Limited","email":null,"sales_phone_number":"020 3640 7111","address":"2nd Floor\r\nBalfour House\r\n46-54 Great Titchfield Street\r\nLondon\r\nW1W 7QA","postcode":"W1W 7QA","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\/65858\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:23.000000Z","updated_at":"2026-01-20T19:54:14.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65858,"agent_company_id":9478,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000004D13B69F8CF1C1BFB22D03CE52C24940","agent_brand_id":10374,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2nd Floor, Balfour House, 46-54 Great Titchfield Street, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Keaze Limited","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 3640 7111","has_phone":true,"resolved_brand_color":"#302e31","boundary_listing_count":"6","property_count":"196","latitude":51.518152,"longitude":-0.140184},{"core_branch_id":51047,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mccarthy \u0026 Stone Resales","email":null,"sales_phone_number":"03455 564122","address":"100 Holdenhurst Road,\r\nBournemouth,\r\nBH8 8AQ","postcode":"BH8 8AQ","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\/51047\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:18.000000Z","updated_at":"2026-01-20T19:57:48.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":51047,"agent_company_id":5694,"branch_location":"-","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005723BBD232D2FDBF72C284D1AC5C4940","agent_brand_id":6493,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"100 Holdenhurst Road, Bournemouth","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mccarthy \u0026 Stone Resales","branch_name":"-","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"03455 564122","has_phone":true,"resolved_brand_color":"#002c2e","boundary_listing_count":"6","property_count":"1334","latitude":50.724024,"longitude":-1.863818},{"core_branch_id":54826,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Auckland Estates Limited","email":"info@aucklandestates.com","sales_phone_number":"01707 664400","address":"36 The Broadway,\r\nDarkes Lane,\r\nPotters Bar,\r\nEN6 2HW","postcode":"EN6 2HW","website_url":"http:\/\/aucklandestates.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54826\/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":54826,"agent_company_id":7004,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000069554B3ACAC1C8BF65FCFB8C0BD94940","agent_brand_id":7843,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"36 The Broadway, Darkes Lane, Potters Bar","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Auckland Estates Limited","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"info@aucklandestates.com","has_email":true,"h_phone":"01707 664400","has_phone":true,"resolved_brand_color":"#fff01e","boundary_listing_count":"5","property_count":"68","latitude":51.695665,"longitude":-0.193414},{"core_branch_id":50077,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bradford \u0026 Howley","email":"marshalswick@bradfordandhowley.com","sales_phone_number":"01727 856999","address":"5 The Quadrant,\r\nMarshalswick,\r\nSt. Albans,\r\nAL4 9RA","postcode":"AL4 9RA","website_url":"http:\/\/www.bradfordandhowley.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50077\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T20:01:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50077,"agent_company_id":1796,"branch_location":"Marshalswick","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006B8313D1AFADD3BFD9CEF753E3E14940","agent_brand_id":2387,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 The Quadrant, Marshalswick, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bradford \u0026 Howley","branch_name":"Marshalswick","lettings":false,"sales":true,"commercial":false,"h_email":"marshalswick@bradfordandhowley.com","has_email":true,"h_phone":"01727 856999","has_phone":true,"resolved_brand_color":"#40a5af","boundary_listing_count":"5","property_count":"48","latitude":51.76475,"longitude":-0.307476},{"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":"5","property_count":"64","latitude":51.79667,"longitude":-0.076407},{"core_branch_id":62972,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Alexander Bond \u0026 Company","email":"sales@abcproperties.co.uk","sales_phone_number":"01438 811511","address":"The Old Estates Office,\r\nPondcroft Road,\r\nKnebworth,\r\nSG3 6DB","postcode":"SG3 6DB","website_url":"http:\/\/www.abcproperties.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\/62972\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:48.000000Z","updated_at":"2026-01-20T19:57:39.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62972,"agent_company_id":7735,"branch_location":"Knebworth","lettings_phone_number":"01438 811511","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000321CCF6740BDC7BF38328FFCC1EE4940","agent_brand_id":8588,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"The Old Estates Office, Pondcroft Road, Knebworth","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alexander Bond \u0026 Company","branch_name":"Knebworth","lettings":true,"sales":true,"commercial":false,"h_email":"sales@abcproperties.co.uk","has_email":true,"h_phone":"01438 811511","has_phone":true,"resolved_brand_color":"#3a5572","boundary_listing_count":"4","property_count":"32","latitude":51.865295,"longitude":-0.185463},{"core_branch_id":50079,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Cassidy \u0026 Tate","email":"marshalswick@cassidyandtate.co.uk","sales_phone_number":"01727 832383","address":"59 \r\nThe Quadrant\r\nMarshalswick\r\nSt. Albans\r\nAL4 9RD \r\n","postcode":"AL4 9RD","website_url":"https:\/\/cassidyandtate.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\/50079\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T20:01:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50079,"agent_company_id":2651,"branch_location":"Marshalswick","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BAA0BE654E97D3BF030B60CAC0E14940","agent_brand_id":3293,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"59, The Quadrant, Marshalswick, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Cassidy \u0026 Tate","branch_name":"Marshalswick","lettings":false,"sales":true,"commercial":false,"h_email":"marshalswick@cassidyandtate.co.uk","has_email":true,"h_phone":"01727 832383","has_phone":true,"resolved_brand_color":"#5b318d","boundary_listing_count":"4","property_count":"44","latitude":51.763696,"longitude":-0.30611},{"core_branch_id":50068,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Herts Homes","email":"sales@herts-homes.co.uk","sales_phone_number":"01727 809510","address":"Arquen House\r\n4-6 Spicer Street\r\nSt Albans\r\nHertfordshire\r\nAL3 4PQ","postcode":"AL3 4PQ","website_url":"http:\/\/www.herts-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\/50068\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-01-20T19:58:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50068,"agent_company_id":2655,"branch_location":"St. Albans","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006269E04735ECD5BFEFAA07CC43E04940","agent_brand_id":3298,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Arquen House, 4-6 Spicer Street, St Albans, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Herts Homes","branch_name":"St. Albans","lettings":false,"sales":true,"commercial":false,"h_email":"sales@herts-homes.co.uk","has_email":true,"h_phone":"01727 809510","has_phone":true,"resolved_brand_color":"#006437","boundary_listing_count":"4","property_count":"10","latitude":51.752069,"longitude":-0.342542},{"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":"4","property_count":"39","latitude":51.697776,"longitude":-0.190899},{"core_branch_id":54823,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Raine \u0026 Co","email":"pottersbar@raineandco.com","sales_phone_number":"01707 665577","address":"11 \r\nDarkes Lane\r\nPotters Bar\r\nEN6 1AJ \r\n\r\n","postcode":"EN6 1AJ","website_url":"http:\/\/www.raineandco.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54823\/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":54823,"agent_company_id":7012,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A1D634EF3845C7BF9A99999999D94940","agent_brand_id":7851,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11, Darkes Lane, Potters Bar","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Raine \u0026 Co","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"pottersbar@raineandco.com","has_email":true,"h_phone":"01707 665577","has_phone":true,"resolved_brand_color":"#fffe01","boundary_listing_count":"4","property_count":"41","latitude":51.7,"longitude":-0.1818},{"core_branch_id":50111,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Welham Estates","email":"welhamestates@zoom.co.uk","sales_phone_number":"01707 260404","address":"2 Fourways Market,\r\nWelham Green,\r\nNorth Mymms,\r\nAL9 7DU","postcode":"AL9 7DU","website_url":"https:\/\/www.welhamestates.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\/50111\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:52:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50111,"agent_company_id":4292,"branch_location":"Welham Green","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000079C9FFE4EFDECBBF61A417B5FBDD4940","agent_brand_id":5024,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Fourways Market, Welham Green, North Mymms","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Welham Estates","branch_name":"Welham Green","lettings":false,"sales":true,"commercial":false,"h_email":"welhamestates@zoom.co.uk","has_email":true,"h_phone":"01707 260404","has_phone":true,"resolved_brand_color":"#ffffd2","boundary_listing_count":"4","property_count":"4","latitude":51.734244,"longitude":-0.217741}]; 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`; } } }