Estate Agents in Welwyn Hatfield, Hertfordshire

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

Brookmans Park

Sales
34 active listings in Welwyn Hatfield, Hertfordshire, England
39 total
79 Bradmore Green, Brookmans Park, AL9 7QT
View Featured Profile
Kings
Kings

Hatfield

Sales
24 active listings in Welwyn Hatfield, Hertfordshire, England
64, Town Centre, Hatfield, AL10 0JJ
View Featured Profile
Duncan Perry Estate Agents
Duncan Perry Estate Agents

Potters Bar

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
63 total
The Estate Office, 48 The Broadway, Potters Bar, EN6 2HW
View Featured Profile
Exp UK
Exp UK

East Midlands

Sales
3 active listings in Welwyn Hatfield, Hertfordshire, England
7,238 total
114 St. Martin's Lane London WC2N 4BE
View Featured Profile
Morgan Alexander
Morgan Alexander

Hertford

Sales
2 active listings in Welwyn Hatfield, Hertfordshire, England
125 total
40 Castle Street, Hertford, SG14 1HH
View Featured Profile
Belvoir
Belvoir

Welwyn

Lettings Sales
27 active listings in Welwyn Hatfield, Hertfordshire, England
53 total
9 High Street, Welwyn, AL6 9EE
View Profile
Ewemove
Ewemove

Covering Scotland

Lettings Sales
19 active listings in Welwyn Hatfield, Hertfordshire, England
1,596 total
Cavendish House Littlewood Court West 26 Industrial Estate Cleckheaton BD19 4TE
View Profile
Martin & Co
Martin & Co

Welwyn

Sales
11 active listings in Welwyn Hatfield, Hertfordshire, England
15 total
16 Howardsgate Welwyn Garden City AL8 6BQ
View Profile
Frost's
Frost's

Marshalswick

Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
67 total
61 The Quadrant, St. Albans, AL4 9RF
View Profile
Northwood
Northwood

St Albans

Lettings Sales
4 active listings in Welwyn Hatfield, Hertfordshire, England
35 total
48 London Road, St. Albans, AL1 1NG
View Profile
Martin & Co
Martin & Co

St. Albans

Sales
2 active listings in Welwyn Hatfield, Hertfordshire, England
22 total
92 London Road, St. Albans, AL1 1NX
View Profile
Pindrop Property
Pindrop Property

London

Lettings Sales
2 active listings in Welwyn Hatfield, Hertfordshire, England
35 total
., .
View Profile
Agreed.co.Uk
Agreed.co.Uk

Nationwide

Sales
1 active listing in Welwyn Hatfield, Hertfordshire, England
148 total
37 Temple Street, Birmingham, B2 5DP
View Profile
Frost's
Frost's

Wheathampstead

Lettings Sales
1 active listing in Welwyn Hatfield, Hertfordshire, England
39 total
4 High Street, Wheathampstead, AL4 8AA
View Profile
Ashtons
Ashtons

Welwyn Garden City

Lettings Sales
148 active listings in Welwyn Hatfield, Hertfordshire, England
163 total
29 Wigmores North, Welwyn Garden City, AL8 6PG
View Profile
Wrights of Welwyn Garden City
Wrights of Welwyn Garden City

Welwyn Garden City

Lettings Sales
108 active listings in Welwyn Hatfield, Hertfordshire, England
114 total
36 Stonehills, Welwyn Garden City, AL8 6PD
View Profile
Raine and Co
Raine and Co

Hatfield

Sales
92 active listings in Welwyn Hatfield, Hertfordshire, England
106 total
11 Market Place, Hatfield, AL10 0LJ
View Profile
Connells
Connells

Welwyn Garden City

Lettings Sales
91 active listings in Welwyn Hatfield, Hertfordshire, England
95 total
38 Wigmores North, Welwyn Garden City, AL8 6PH
View Profile
William H. Brown
William H. Brown

Welwyn Garden City

Lettings Sales
89 active listings in Welwyn Hatfield, Hertfordshire, England
92 total
53 Wigmores North, Welwyn Garden City, AL8 6PG
View Profile
Putterills
Putterills

Welwyn Garden City

Sales
63 active listings in Welwyn Hatfield, Hertfordshire, England
65 total
34 Wigmores North, Welwyn Garden City, AL8 6PH
View Profile
Wrights of Hatfield
Wrights of Hatfield

Hatfield

Lettings Sales
52 active listings in Welwyn Hatfield, Hertfordshire, England
58 total
9 Market Place, Hatfield, AL10 0LJ
View Profile
Bryan Bishop and Partners
Bryan Bishop and Partners

Welwyn

Sales
50 active listings in Welwyn Hatfield, Hertfordshire, England
82 total
6A, High Street, Welwyn, AL6 9EG
View Profile
Mather Estates
Mather Estates

Hatfield

Lettings Sales
49 active listings in Welwyn Hatfield, Hertfordshire, England
51 total
27 Market Place, Hatfield, AL10 0LJ
View Profile
Vanessa Mccallum Estates
Vanessa Mccallum Estates

Potters Bar

Sales
42 active listings in Welwyn Hatfield, Hertfordshire, England
78 total
Maple House, High Street, Potters Bar, EN6 5BS
View Profile
Country Properties
Country Properties

Welwyn Garden City

Sales
35 active listings in Welwyn Hatfield, Hertfordshire, England
37 total
3 Bridge Road, Fretherne Road, Welwyn Garden City, AL8 6UN
View Profile
Statons
Statons

Brookmans Park

Sales
34 active listings in Welwyn Hatfield, Hertfordshire, England
52 total
53 Bradmore Green, Brookmans Park, AL9 7QS
View Profile
Banc Property
Banc Property

Cuffley

Sales
32 active listings in Welwyn Hatfield, Hertfordshire, England
62 total
1 Station Road, Cuffley, Herts, EN6 4HU
View Profile
Andrew Ward
Andrew Ward

Of Brookmans Park and Potters Bar

Sales
31 active listings in Welwyn Hatfield, Hertfordshire, England
59 total
35 Bradmore Green, Brookmans Park, AL9 7QR
View Profile
Jr Property Services
Jr Property Services

Cuffley

Sales
28 active listings in Welwyn Hatfield, Hertfordshire, England
63 total
24 Station Road, Cuffley, EN6 4HT
View Profile
Deakin-White
Deakin-White

St Albans

Sales
27 active listings in Welwyn Hatfield, Hertfordshire, England
35 total
Office 224, 17 Holywell Hill, St Albans, AL1 1DT
View Profile
Page 1 of 5
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":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":"34","property_count":"39","latitude":51.721607,"longitude":-0.202761},{"core_branch_id":50058,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Kings","email":"hatfieldsales@kingsestateagent.co.uk","sales_phone_number":"01707 268100","address":"64,\r\nTown Centre,\r\nHatfield,\r\nAL10 0JJ","postcode":"AL10 0JJ","website_url":"http:\/\/www.kingsestateagent.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\/50058\/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":50058,"agent_company_id":5663,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000FBEAAA402D06CDBF7216F6B4C3E14940","agent_brand_id":6459,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"64, Town Centre, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Kings","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"hatfieldsales@kingsestateagent.co.uk","has_email":true,"h_phone":"01707 268100","has_phone":true,"resolved_brand_color":"#eb8031","boundary_listing_count":"24","property_count":"24","latitude":51.763785,"longitude":-0.226751},{"core_branch_id":54828,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Duncan Perry Estate Agents","email":"pottersbar@duncanperry.co.uk","sales_phone_number":"01707 655466","address":"The Estate Office,\r\n48 The Broadway,\r\nPotters Bar,\r\nEN6 2HW","postcode":"EN6 2HW","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\/54828\/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":54828,"agent_company_id":4290,"branch_location":"Potters Bar","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E610000069554B3ACAC1C8BF65FCFB8C0BD94940","agent_brand_id":5021,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"The Estate Office, 48 The Broadway, Potters Bar","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Duncan Perry Estate Agents","branch_name":"Potters Bar","lettings":false,"sales":true,"commercial":false,"h_email":"pottersbar@duncanperry.co.uk","has_email":true,"h_phone":"01707 655466","has_phone":true,"resolved_brand_color":"#b6aac5","boundary_listing_count":"4","property_count":"63","latitude":51.695665,"longitude":-0.193414},{"core_branch_id":66292,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Exp UK","email":"carl.mcintosh-ormerod@exp.uk.com","sales_phone_number":"03304 609968","address":"114 St. Martin\u0027s Lane\r\nLondon\r\nWC2N 4BE","postcode":"WC2N 4BE","website_url":"https:\/\/exp.uk.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/66292\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:38.000000Z","updated_at":"2026-01-20T19:55:20.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66292,"agent_company_id":510,"branch_location":"East Midlands","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E610000056478E740646C0BF0398327040C14940","agent_brand_id":924,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"114 St. Martin\u0027s Lane, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Exp UK","branch_name":"East Midlands","lettings":false,"sales":true,"commercial":false,"h_email":"carl.mcintosh-ormerod@exp.uk.com","has_email":true,"h_phone":"03304 609968","has_phone":true,"resolved_brand_color":"#ffffff","boundary_listing_count":"3","property_count":"7238","latitude":51.509779,"longitude":-0.127137},{"core_branch_id":62950,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Morgan Alexander","email":"info@morgan-alexander.co.uk","sales_phone_number":"01992 248028","address":"40 Castle Street,\r\nHertford,\r\nSG14 1HH","postcode":"SG14 1HH","website_url":"https:\/\/morgan-alexander.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\/62950\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.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":62950,"agent_company_id":1528,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000897956D28A6FB4BFB988EFC4ACE54940","agent_brand_id":2100,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"40 Castle Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Morgan Alexander","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"info@morgan-alexander.co.uk","has_email":true,"h_phone":"01992 248028","has_phone":true,"resolved_brand_color":"#ffd601","boundary_listing_count":"2","property_count":"125","latitude":51.794335,"longitude":-0.079827},{"core_branch_id":50095,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Belvoir","email":"welwyn@belvoir.co.uk","sales_phone_number":"01438 717701","address":"9 High Street,\r\nWelwyn,\r\nAL6 9EE","postcode":"AL6 9EE","website_url":"https:\/\/www.belvoir.co.uk\/welwyn","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50095\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:57:33.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50095,"agent_company_id":44,"branch_location":"Welwyn","lettings_phone_number":"01438 717701","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F2B391EBA694CBBFB1F9B83654EA4940","agent_brand_id":67,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 High Street, Welwyn","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Belvoir","branch_name":"Welwyn","lettings":true,"sales":true,"commercial":false,"h_email":"welwyn@belvoir.co.uk","has_email":true,"h_phone":"01438 717701","has_phone":true,"resolved_brand_color":"#ba3232","boundary_listing_count":"27","property_count":"53","latitude":51.830695,"longitude":-0.215474},{"core_branch_id":50830,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ewemove","email":"katy.lamsin@ewemove.com","sales_phone_number":"01274 888790","address":"Cavendish House \r\nLittlewood Court\r\nWest 26 Industrial Estate\r\nCleckheaton\r\nBD19 4TE ","postcode":"BD19 4TE","website_url":"https:\/\/www.ewemove.com\/estate-agents\/greenford\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50830\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:14:11.000000Z","updated_at":"2026-01-20T20:01:26.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50830,"agent_company_id":44,"branch_location":"Covering Scotland","lettings_phone_number":"01274 888790","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001C7E37DDB283FBBF3ACFD8976CDE4A40","agent_brand_id":74,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Cavendish House, Littlewood Court, West 26 Industrial Estate, Cleckheaton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ewemove","branch_name":"Covering Scotland","lettings":true,"sales":true,"commercial":false,"h_email":"katy.lamsin@ewemove.com","has_email":true,"h_phone":"01274 888790","has_phone":true,"resolved_brand_color":"#9ebe3d","boundary_listing_count":"19","property_count":"1596","latitude":53.737689,"longitude":-1.719653},{"core_branch_id":50098,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"martincoukagency.martin___co_welwyn_garden_city@ptlp.co.uk","sales_phone_number":"01707 334576","address":"16 Howardsgate\r\nWelwyn Garden City\r\nAL8 6BQ ","postcode":"AL8 6BQ","website_url":"https:\/\/www.martinco.com\/estate-agents-and-letting-agents\/branch\/welwyn","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50098\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:13:47.000000Z","updated_at":"2026-01-20T19:53:41.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50098,"agent_company_id":44,"branch_location":"Welwyn","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009FAEEE586C93CABF2AA8A8FA95E64940","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"16 Howardsgate, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Welwyn","lettings":false,"sales":true,"commercial":false,"h_email":"martincoukagency.martin___co_welwyn_garden_city@ptlp.co.uk","has_email":true,"h_phone":"01707 334576","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"11","property_count":"15","latitude":51.801452,"longitude":-0.207624},{"core_branch_id":50080,"verification_status":"verified","verified_at":"2026-02-05T17:38:46.000000Z","verified_by":null,"verification_notes":null,"name":"Frost\u0027s","email":"andrew.Gilchrist@frosts.co.uk","sales_phone_number":"01727 852295","address":"61 The Quadrant,\r\nSt. Albans,\r\nAL4 9RF","postcode":"AL4 9RF","website_url":"https:\/\/www.frosts.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"Reapit","logo":"https:\/\/cdn.home.co.uk\/agents\/50080\/logo.png","office_images":null,"claimed_at":"2026-02-05T17:34:00.000000Z","created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-02-05T17:38:46.000000Z","deleted_at":null,"claimed_user_id":"d1916b60-b79a-46d5-97ea-491f50f7ba56","profile_status":"live","assigned_user_id":null,"id":50080,"agent_company_id":1798,"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":2389,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"61 The Quadrant, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Frost\u0027s","branch_name":"Marshalswick","lettings":false,"sales":true,"commercial":false,"h_email":"andrew.Gilchrist@frosts.co.uk","has_email":true,"h_phone":"01727 852295","has_phone":true,"resolved_brand_color":"#a12846","boundary_listing_count":"4","property_count":"67","latitude":51.763696,"longitude":-0.30611},{"core_branch_id":50041,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Northwood","email":"stalbans@northwooduk.com","sales_phone_number":"01727 734550","address":"48 London Road,\r\nSt. Albans,\r\nAL1 1NG","postcode":"AL1 1NG","website_url":"https:\/\/www.northwooduk.com\/branches\/estate-agents-st-albans","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50041\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:13:45.000000Z","updated_at":"2026-01-20T20:01:12.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50041,"agent_company_id":44,"branch_location":"St Albans","lettings_phone_number":"01727 734550","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000FE65F7E461A1D5BF5A9C31CC09E04940","agent_brand_id":88,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"48 London Road, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Northwood","branch_name":"St Albans","lettings":true,"sales":true,"commercial":false,"h_email":"stalbans@northwooduk.com","has_email":true,"h_phone":"01727 734550","has_phone":true,"resolved_brand_color":"#34203f","boundary_listing_count":"4","property_count":"35","latitude":51.750299,"longitude":-0.337975},{"core_branch_id":50045,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"stalbans@martinco.com","sales_phone_number":"01727 898236","address":"92 London Road,\r\nSt. Albans,\r\nAL1 1NX","postcode":"AL1 1NX","website_url":"https:\/\/www.martinco.com\/estate-agents-and-letting-agents\/branch\/st-albans","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50045\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:13:45.000000Z","updated_at":"2026-01-20T19:53:41.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50045,"agent_company_id":44,"branch_location":"St. Albans","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007808E3A7716FD5BF5320B3B3E8DF4940","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"92 London Road, St. Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"St. Albans","lettings":false,"sales":true,"commercial":false,"h_email":"stalbans@martinco.com","has_email":true,"h_phone":"01727 898236","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"2","property_count":"22","latitude":51.749289,"longitude":-0.334927},{"core_branch_id":67408,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Pindrop Property","email":"info@pindropproperty.com","sales_phone_number":"020 3869 0201","address":"., .","postcode":".","website_url":"https:\/\/pindropproperty.com\/","description":"PinDrop Property is a hybrid estate agency that combines traditional marketing with the latest technology to match you with the best buyers for your property. With years of industry expertise, we present homes in the best possible light, using everything from professional 360 tours to drone \u0026 professional photography. Our goal is simple: to get your property noticed by the right buyers and secure the best results all whilst keeping you informed every step of the way.\r\n\r\nWe believe in a tailored, hands-on approach to every sale. From property portals to social media, we leverage every proven method and the latest tools to give your property maximum exposure. Whether you\u0027re selling your home or exploring options, we\u0027re here to guide you every step of the way.\r\n\r\nLooking to sell? PinDrop Property have got you covered","listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"Alto","logo":"https:\/\/cdn.home.co.uk\/agents\/67408\/logo.png","office_images":null,"claimed_at":"2026-02-03T20:43:07.000000Z","created_at":"2025-12-09T17:23:14.000000Z","updated_at":"2026-02-03T23:49:28.000000Z","deleted_at":null,"claimed_user_id":"8e71356f-57e5-4dd4-a3a9-fcf9bd2639eb","profile_status":"live","assigned_user_id":null,"id":67408,"agent_company_id":8631,"branch_location":"London","lettings_phone_number":"02038690201","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":null,"agent_brand_id":9507,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":"#ffcf5c","logo_rect":null,"address_lines":".","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Pindrop Property","branch_name":"London","lettings":true,"sales":true,"commercial":false,"h_email":"info@pindropproperty.com","has_email":true,"h_phone":"020 3869 0201","has_phone":true,"resolved_brand_color":"#ffcf5c","boundary_listing_count":"2","property_count":"35","latitude":null,"longitude":null},{"core_branch_id":50207,"verification_status":"verified","verified_at":"2025-11-12T11:59:01.000000Z","verified_by":null,"verification_notes":null,"name":"Agreed.co.Uk","email":"hello@agreed.co.uk","sales_phone_number":"020 3959 7591","address":"37 Temple Street, Birmingham, B2 5DP","postcode":"B2 5DP","website_url":"https:\/\/agreed.co.uk","description":null,"listings_feed_url":"https:\/\/agreed.co.uk","feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50207\/logo.png","office_images":null,"claimed_at":"2025-11-12T11:58:19.000000Z","created_at":"2025-12-09T17:13:51.000000Z","updated_at":"2026-01-20T20:01:13.000000Z","deleted_at":null,"claimed_user_id":"f16eceb3-3371-49ee-a9c5-72b89179ebad","profile_status":"live","assigned_user_id":null,"id":50207,"agent_company_id":4036,"branch_location":"Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D0F1D1E28C61FEBFED9C6681763D4A40","agent_brand_id":4754,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"37 Temple Street, Birmingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Agreed.co.Uk","branch_name":"Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"hello@agreed.co.uk","has_email":true,"h_phone":"020 3959 7591","has_phone":true,"resolved_brand_color":"#ff3a6e","boundary_listing_count":"1","property_count":"148","latitude":52.480179,"longitude":-1.898816},{"core_branch_id":50075,"verification_status":"verified","verified_at":"2026-02-05T17:38:46.000000Z","verified_by":null,"verification_notes":null,"name":"Frost\u0027s","email":"sales@frosts.co.uk","sales_phone_number":"01582 833444","address":"4 High Street,\r\nWheathampstead,\r\nAL4 8AA","postcode":"AL4 8AA","website_url":"http:\/\/www.frosts.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"Reapit","logo":"https:\/\/cdn.home.co.uk\/agents\/50075\/logo.png","office_images":null,"claimed_at":"2026-02-05T17:34:00.000000Z","created_at":"2025-12-09T17:13:46.000000Z","updated_at":"2026-02-05T17:38:46.000000Z","deleted_at":null,"claimed_user_id":"d1916b60-b79a-46d5-97ea-491f50f7ba56","profile_status":"live","assigned_user_id":null,"id":50075,"agent_company_id":1798,"branch_location":"Wheathampstead","lettings_phone_number":"01582 833444","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008E739B70AFCCD2BF52431B800DE84940","agent_brand_id":2389,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4 High Street, Wheathampstead","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Frost\u0027s","branch_name":"Wheathampstead","lettings":true,"sales":true,"commercial":false,"h_email":"sales@frosts.co.uk","has_email":true,"h_phone":"01582 833444","has_phone":true,"resolved_brand_color":"#a12846","boundary_listing_count":"1","property_count":"39","latitude":51.812912,"longitude":-0.293743},{"core_branch_id":50102,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ashtons","email":"jingram@ashtons.co.uk","sales_phone_number":"01707 331100","address":"29 Wigmores North,\r\nWelwyn Garden City,\r\nAL8 6PG","postcode":"AL8 6PG","website_url":"http:\/\/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\/50102\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.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":50102,"agent_company_id":1795,"branch_location":"Welwyn Garden City","lettings_phone_number":"01707 383133","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009AEAC9FCA36FCABFA0DE8C9AAFE64940","agent_brand_id":2386,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"29 Wigmores North, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ashtons","branch_name":"Welwyn Garden City","lettings":true,"sales":true,"commercial":false,"h_email":"jingram@ashtons.co.uk","has_email":true,"h_phone":"01707 331100","has_phone":true,"resolved_brand_color":"#babc9a","boundary_listing_count":"148","property_count":"163","latitude":51.802234,"longitude":-0.206532},{"core_branch_id":50101,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Wrights of Welwyn Garden City","email":"wgc@wrightsof.com","sales_phone_number":"01707 332211","address":"36 Stonehills,\r\nWelwyn Garden City,\r\nAL8 6PD","postcode":"AL8 6PD","website_url":"http:\/\/wgc.wrightsof.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50101\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.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":50101,"agent_company_id":5669,"branch_location":"Welwyn Garden City","lettings_phone_number":"01707 332211","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B29E5A7D7555CABFCF11F92EA5E64940","agent_brand_id":6467,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"36 Stonehills, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Wrights of Welwyn Garden City","branch_name":"Welwyn Garden City","lettings":true,"sales":true,"commercial":false,"h_email":"wgc@wrightsof.com","has_email":true,"h_phone":"01707 332211","has_phone":true,"resolved_brand_color":"#194279","boundary_listing_count":"108","property_count":"114","latitude":51.801916,"longitude":-0.205733},{"core_branch_id":50061,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Raine and Co","email":"hatfield@raineandco.com","sales_phone_number":"01707 266885","address":"11 Market Place, \r\nHatfield,\r\nAL10 0LJ","postcode":"AL10 0LJ","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\/50061\/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":50061,"agent_company_id":5667,"branch_location":"Hatfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A609DB4FC6F8CCBF309C6B98A1E14940","agent_brand_id":6463,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11 Market Place, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Raine and Co","branch_name":"Hatfield","lettings":false,"sales":true,"commercial":false,"h_email":"hatfield@raineandco.com","has_email":true,"h_phone":"01707 266885","has_phone":true,"resolved_brand_color":"#fffe01","boundary_listing_count":"92","property_count":"106","latitude":51.762744,"longitude":-0.226342},{"core_branch_id":50104,"verification_status":"verified","verified_at":"2026-02-05T16:55:52.000000Z","verified_by":null,"verification_notes":null,"name":"Connells","email":"welwyngardencity@connells.co.uk","sales_phone_number":"01707 322903","address":"38 Wigmores North,\r\nWelwyn Garden City,\r\nAL8 6PH","postcode":"AL8 6PH","website_url":"https:\/\/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\/50104\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:47.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":50104,"agent_company_id":1,"branch_location":"Welwyn Garden City","lettings_phone_number":"01707 322903","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000002F302B14E97ECABFB39AAE27BAE64940","agent_brand_id":4,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"38 Wigmores North, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Connells","branch_name":"Welwyn Garden City","lettings":true,"sales":true,"commercial":false,"h_email":"welwyngardencity@connells.co.uk","has_email":true,"h_phone":"01707 322903","has_phone":true,"resolved_brand_color":"#cc1e23","boundary_listing_count":"91","property_count":"95","latitude":51.802556,"longitude":-0.206998},{"core_branch_id":50103,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"William H. Brown","email":"WelwynGardenCitylet@williamhbrown.co.uk","sales_phone_number":"01707 324361","address":"53 Wigmores North, \r\nWelwyn Garden City, AL8 6PG","postcode":"AL8 6PG","website_url":"http:\/\/www.williamhbrown.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\/50103\/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":50103,"agent_company_id":54,"branch_location":"Welwyn Garden City","lettings_phone_number":"01707 330228","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009AEAC9FCA36FCABFA0DE8C9AAFE64940","agent_brand_id":216,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"53 Wigmores North, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"William H. Brown","branch_name":"Welwyn Garden City","lettings":true,"sales":true,"commercial":false,"h_email":"WelwynGardenCitylet@williamhbrown.co.uk","has_email":true,"h_phone":"01707 324361","has_phone":true,"resolved_brand_color":"#8dc3d9","boundary_listing_count":"89","property_count":"92","latitude":51.802234,"longitude":-0.206532},{"core_branch_id":50105,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Putterills","email":"nick.brown@putterills.co.uk","sales_phone_number":"01707 393333","address":"34 Wigmores North,\r\nWelwyn Garden City,\r\nAL8 6PH","postcode":"AL8 6PH","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\/50105\/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":50105,"agent_company_id":6255,"branch_location":"Welwyn Garden City","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000002F302B14E97ECABFB39AAE27BAE64940","agent_brand_id":7074,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"34 Wigmores North, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Putterills","branch_name":"Welwyn Garden City","lettings":false,"sales":true,"commercial":false,"h_email":"nick.brown@putterills.co.uk","has_email":true,"h_phone":"01707 393333","has_phone":true,"resolved_brand_color":"#822829","boundary_listing_count":"63","property_count":"65","latitude":51.802556,"longitude":-0.206998},{"core_branch_id":50062,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Wrights of Hatfield","email":"saleshatfield@wrightsof.com","sales_phone_number":"01707 272727","address":"9 Market Place,\r\nHatfield,\r\nAL10 0LJ","postcode":"AL10 0LJ","website_url":"https:\/\/www.wrightsof.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50062\/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":50062,"agent_company_id":5669,"branch_location":"Hatfield","lettings_phone_number":"01707 272727","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A609DB4FC6F8CCBF309C6B98A1E14940","agent_brand_id":6466,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 Market Place, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Wrights of Hatfield","branch_name":"Hatfield","lettings":true,"sales":true,"commercial":false,"h_email":"saleshatfield@wrightsof.com","has_email":true,"h_phone":"01707 272727","has_phone":true,"resolved_brand_color":"#194279","boundary_listing_count":"52","property_count":"58","latitude":51.762744,"longitude":-0.226342},{"core_branch_id":50096,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bryan Bishop and Partners","email":"info@bryanbishop.co.uk","sales_phone_number":"01438 718877","address":"6A, \r\nHigh Street,\r\nWelwyn,\r\nAL6 9EG ","postcode":"AL6 9EG","website_url":"https:\/\/www.bryanbishop.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\/50096\/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":50096,"agent_company_id":9072,"branch_location":"Welwyn","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F8713447567ECBBFBEF8A23D5EEA4940","agent_brand_id":9959,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"6A, High Street, Welwyn","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bryan Bishop and Partners","branch_name":"Welwyn","lettings":false,"sales":true,"commercial":false,"h_email":"info@bryanbishop.co.uk","has_email":true,"h_phone":"01438 718877","has_phone":true,"resolved_brand_color":"#0a4641","boundary_listing_count":"50","property_count":"82","latitude":51.831001,"longitude":-0.214793},{"core_branch_id":50060,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mather Estates","email":"hatfield@mathermarshall.com","sales_phone_number":"01707 270777","address":"27 \r\nMarket Place,\r\nHatfield,\r\nAL10 0LJ \r\n","postcode":"AL10 0LJ","website_url":"https:\/\/www.mathermarshall.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50060\/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":50060,"agent_company_id":5665,"branch_location":"Hatfield","lettings_phone_number":"01707 270777","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A609DB4FC6F8CCBF309C6B98A1E14940","agent_brand_id":6461,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"27, Market Place, Hatfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mather Estates","branch_name":"Hatfield","lettings":true,"sales":true,"commercial":false,"h_email":"hatfield@mathermarshall.com","has_email":true,"h_phone":"01707 270777","has_phone":true,"resolved_brand_color":"#2f3f5f","boundary_listing_count":"49","property_count":"51","latitude":51.762744,"longitude":-0.226342},{"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":"42","property_count":"78","latitude":51.692809,"longitude":-0.179666},{"core_branch_id":50107,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Country Properties","email":"chris.chalkley@country-properties.co.uk","sales_phone_number":"01707 339146","address":"3 Bridge Road,\r\nFretherne Road,\r\nWelwyn Garden City,\r\nAL8 6UN","postcode":"AL8 6UN","website_url":"http:\/\/www.country-properties.co.uk\/branch\/welwyn-garden\/branch.html","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50107\/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":50107,"agent_company_id":98,"branch_location":"Welwyn Garden City","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000022179CC1DF2FCABFA9C29FE1CDE64940","agent_brand_id":289,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"3 Bridge Road, Fretherne Road, Welwyn Garden City","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Country Properties","branch_name":"Welwyn Garden City","lettings":false,"sales":true,"commercial":false,"h_email":"chris.chalkley@country-properties.co.uk","has_email":true,"h_phone":"01707 339146","has_phone":true,"resolved_brand_color":"#00463c","boundary_listing_count":"35","property_count":"37","latitude":51.803158,"longitude":-0.204586},{"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":"34","property_count":"52","latitude":51.721675,"longitude":-0.201933},{"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":"32","property_count":"62","latitude":51.707974,"longitude":-0.113245},{"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":"31","property_count":"59","latitude":51.722259,"longitude":-0.201881},{"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":"28","property_count":"63","latitude":51.707721,"longitude":-0.112618},{"core_branch_id":50033,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Deakin-White","email":"hleads@dwrealestate.co.uk","sales_phone_number":"01727 620131","address":"Office 224,\r\n17 Holywell Hill,\r\nSt Albans,\r\nAL1 1DT","postcode":"AL1 1DT","website_url":"http:\/\/www.dwrealestate.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/50033\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:45.000000Z","updated_at":"2026-01-20T19:52:23.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50033,"agent_company_id":1481,"branch_location":"St Albans","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000390D51853FC3D5BFA0C37C7901E04940","agent_brand_id":2041,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 224, 17 Holywell Hill, St Albans","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Deakin-White","branch_name":"St Albans","lettings":false,"sales":true,"commercial":false,"h_email":"hleads@dwrealestate.co.uk","has_email":true,"h_phone":"01727 620131","has_phone":true,"resolved_brand_color":"#5f0a8c","boundary_listing_count":"27","property_count":"35","latitude":51.750045,"longitude":-0.340042}]; 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`; } } }