Estate Agents in Hertford, East Hertfordshire

Find Estate Agents in Hertford, East Hertfordshire
49 results
Compare Best Local Agents
Morgan Alexander
Morgan Alexander

Hertford

Sales
70 active listings in Hertford, East Hertfordshire, Hertfordshire, England
125 total
40 Castle Street, Hertford, SG14 1HH
View Featured Profile
Keith Ian
Keith Ian

Ware

Lettings Sales
3 active listings in Hertford, East Hertfordshire, Hertfordshire, England
84 total
70-72 High Street, Ware, SG12 9AT
View Featured Profile
Westwood Leber
Westwood Leber

Hertfordshire

Lettings Sales
3 active listings in Hertford, East Hertfordshire, Hertfordshire, England
104 total
8 The Pavilion Tower Centre Hoddesdon EN11 8UD
View Featured Profile
Exp UK
Exp UK

East Midlands

Sales
1 active listing in Hertford, East Hertfordshire, Hertfordshire, England
7,238 total
114 St. Martin's Lane London WC2N 4BE
View Featured Profile
Steven Oates
Steven Oates

Hertford

Lettings Sales
170 active listings in Hertford, East Hertfordshire, Hertfordshire, England
284 total
70 Fore Street, Hertford, SG14 1BY
View Profile
Shepherds
Shepherds

Hertford

Lettings Sales
66 active listings in Hertford, East Hertfordshire, Hertfordshire, England
78 total
28 Castle Street, Hertford, SG14 1HH
View Profile
William H. Brown
William H. Brown

Hertford

Sales
54 active listings in Hertford, East Hertfordshire, Hertfordshire, England
64 total
21 Castle Street, Hertford, SG14 1ER
View Profile
Hamptons
Hamptons

Hertford

Lettings Sales
19 active listings in Hertford, East Hertfordshire, Hertfordshire, England
50 total
10-11 Market Place, Hertford, SG14 1DG
View Profile
Thomas Childs & Co
Thomas Childs & Co

Hertford

Lettings Sales
11 active listings in Hertford, East Hertfordshire, Hertfordshire, England
22 total
9 Parliament Square Hertford SG14 1EY
View Profile
Simply Homes
Simply Homes

Hertford

Sales
10 active listings in Hertford, East Hertfordshire, Hertfordshire, England
35 total
114-116 Fore Street Hertford SG14 1AJ
View Profile
Big Black Hen.Com
Big Black Hen.Com

Hertfordshire

Sales
9 active listings in Hertford, East Hertfordshire, Hertfordshire, England
28 total
First Floor, 3 Crane Mead, Ware, SG12 9PZ
View Profile
Greenhill Sales and Lettings Limited
Greenhill Sales and Lettings Limited

Cuffley

Sales
8 active listings in Hertford, East Hertfordshire, Hertfordshire, England
22 total
Sopers House Sopers Road, Cuffley, EN6 4RY
View Profile
Elliot Heath
Elliot Heath

Ware

Sales
7 active listings in Hertford, East Hertfordshire, Hertfordshire, England
129 total
7 Star Street, Ware, SG12 7AA
View Profile
Mccarthy & Stone Resales
Mccarthy & Stone Resales

-

Sales
7 active listings in Hertford, East Hertfordshire, Hertfordshire, England
1,331 total
100 Holdenhurst Road, Bournemouth, BH8 8AQ
View Profile
Taylor Phelps
Taylor Phelps

Ware

Sales
7 active listings in Hertford, East Hertfordshire, Hertfordshire, England
65 total
5 Frenchs Yard Ware Town Centre Hertfordshire SG12 9HP
View Profile
Ward Estates
Ward Estates

Hertford

Sales
6 active listings in Hertford, East Hertfordshire, Hertfordshire, England
8 total
12-14 Parliament Square, Hertford, SG14 1EF
View Profile
Anthony Lettings
Anthony Lettings

Hertford

Sales
5 active listings in Hertford, East Hertfordshire, Hertfordshire, England
8 total
Yeomans Court, Hertford, SG13 7HJ
View Profile
Lanes
Lanes

Hertford

Sales
5 active listings in Hertford, East Hertfordshire, Hertfordshire, England
8 total
2 Market Street, Hertford, SG14 1BD
View Profile
Fine & Country
Fine & Country

Ware

Sales
4 active listings in Hertford, East Hertfordshire, Hertfordshire, England
69 total
Office 1, 21 Baldock Street, Ware, SG12 9DH
View Profile
Jonathan Hunt Estate Agency
Jonathan Hunt Estate Agency

Ware

Lettings Sales
4 active listings in Hertford, East Hertfordshire, Hertfordshire, England
78 total
20 High Street, Ware, SG12 9BX
View Profile
Kings Group
Kings Group

Hertford

Sales
4 active listings in Hertford, East Hertfordshire, Hertfordshire, England
9 total
28 Maidenhead Street, Hertford, SG14 1DR
View Profile
Mount & Co.
Mount & Co.

Hertford

Sales
3 active listings in Hertford, East Hertfordshire, Hertfordshire, England
6 total
2 Market Place, Hertford, SG14 1DF
View Profile
Purplebricks
Purplebricks

Covering Chester & Wirral

Lettings Sales
3 active listings in Hertford, East Hertfordshire, Hertfordshire, England
7,984 total
Purplebricks, 146 Freston Road, London, W10 6TR
View Profile
Anthony Davies
Anthony Davies

Hoddesdon

Lettings Sales
2 active listings in Hertford, East Hertfordshire, Hertfordshire, England
23 total
27 High Street, Hoddesdon, EN11 8SX
View Profile
Chris Dellar Properties
Chris Dellar Properties

Buntingford

Sales
2 active listings in Hertford, East Hertfordshire, Hertfordshire, England
26 total
58A High Street, Buntingford, SG9 9AH
View Profile
Ensum Brown
Ensum Brown

Royston

Sales
2 active listings in Hertford, East Hertfordshire, Hertfordshire, England
300 total
Kooky Nohmad, 42 High Street, Royston, SG8 9AG
View Profile
Peter Cuffaro Estate Agents
Peter Cuffaro Estate Agents

Stanstead Abbotts

Sales
2 active listings in Hertford, East Hertfordshire, Hertfordshire, England
47 total
19 High Street, Stanstead Abbotts, SG12 8AA
View Profile
Strutt & Parker
Strutt & Parker

Covering Cornwall

Sales
2 active listings in Hertford, East Hertfordshire, Hertfordshire, England
71 total
Covering Cornwall
View Profile
Ashtons
Ashtons

Welwyn Garden City

Lettings Sales
1 active listing in Hertford, East Hertfordshire, Hertfordshire, England
163 total
29 Wigmores North, Welwyn Garden City, AL8 6PG
View Profile
Aspect Property
Aspect Property

London

Sales
1 active listing in Hertford, East Hertfordshire, Hertfordshire, England
35 total
41 Park Parade, London, NW10 4JE
View Profile
Page 1 of 2
initializeAllPremierCards() }); // Load detailed stats function function loadDetailedStats() { const button = document.getElementById('load-more-stats'); const statsContainer = document.getElementById('detailed-stats'); if (statsContainer.classList.contains('hidden')) { // Show loading state button.innerHTML = ` Loading... `; // Make AJAX call for detailed stats const location = 'Hertford, East 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":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":"70","property_count":"125","latitude":51.794335,"longitude":-0.079827},{"core_branch_id":62927,"verification_status":"verified","verified_at":"2026-01-10T09:34:12.000000Z","verified_by":null,"verification_notes":null,"name":"Keith Ian","email":"ware@keithian.com","sales_phone_number":"01920 463131","address":"70-72 High Street,\r\nWare,\r\nSG12 9AT","postcode":"SG12 9AT","website_url":"http:\/\/www.keithian.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62927\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:58:01.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":62927,"agent_company_id":2703,"branch_location":"Ware","lettings_phone_number":"01920 411007","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000004F5AB8ACC266A0BFDAE55B1FD6E74940","agent_brand_id":3354,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"70-72 High Street, Ware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Keith Ian","branch_name":"Ware","lettings":true,"sales":true,"commercial":false,"h_email":"ware@keithian.com","has_email":true,"h_phone":"01920 463131","has_phone":true,"resolved_brand_color":"#1d315c","boundary_listing_count":"3","property_count":"84","latitude":51.811222,"longitude":-0.032034},{"core_branch_id":54776,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Westwood Leber","email":"jacob@westwoodleber.co.uk","sales_phone_number":"01992 443311","address":"8 The Pavilion\r\nTower Centre\r\nHoddesdon\r\nEN11 8UD ","postcode":"EN11 8UD","website_url":"http:\/\/www.westwoodleber.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\/54776\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:20.000000Z","updated_at":"2026-01-20T20:01:51.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54776,"agent_company_id":1404,"branch_location":"Hertfordshire","lettings_phone_number":"01992 443311","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000003BDF4F8D976E92BFD3DEE00B93E14940","agent_brand_id":1958,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"8 The Pavilion, Tower Centre, Hoddesdon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Westwood Leber","branch_name":"Hertfordshire","lettings":true,"sales":true,"commercial":false,"h_email":"jacob@westwoodleber.co.uk","has_email":true,"h_phone":"01992 443311","has_phone":true,"resolved_brand_color":"#9d107c","boundary_listing_count":"3","property_count":"104","latitude":51.7623,"longitude":-0.018},{"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":"1","property_count":"7238","latitude":51.509779,"longitude":-0.127137},{"core_branch_id":62941,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Steven Oates","email":"info@stevenoates.com","sales_phone_number":"01992 303300","address":"70 Fore Street,\r\nHertford,\r\nSG14 1BY","postcode":"SG14 1BY","website_url":"http:\/\/www.stevenoates.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62941\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:54:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62941,"agent_company_id":1534,"branch_location":"Hertford","lettings_phone_number":"01992 303300","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000DBFD2AC0779BB3BF785E2A36E6E54940","agent_brand_id":2107,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"70 Fore Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Steven Oates","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"info@stevenoates.com","has_email":true,"h_phone":"01992 303300","has_phone":true,"resolved_brand_color":"#d32850","boundary_listing_count":"170","property_count":"284","latitude":51.796088,"longitude":-0.076591},{"core_branch_id":62951,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Shepherds","email":"steve.whyman@shepherds-estates.co.uk","sales_phone_number":"01992 551955","address":"28 Castle Street, Hertford, \r\nSG14 1HH","postcode":"SG14 1HH","website_url":"https:\/\/www.shepherdsofhertford.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62951\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.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":62951,"agent_company_id":1532,"branch_location":"Hertford","lettings_phone_number":"01992 551955","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000897956D28A6FB4BFB988EFC4ACE54940","agent_brand_id":2105,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"28 Castle Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Shepherds","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"steve.whyman@shepherds-estates.co.uk","has_email":true,"h_phone":"01992 551955","has_phone":true,"resolved_brand_color":"#9e1a1a","boundary_listing_count":"66","property_count":"78","latitude":51.794335,"longitude":-0.079827},{"core_branch_id":62948,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"William H. Brown","email":"Hertford@williamhbrown.co.uk","sales_phone_number":"01992 586501","address":"21 Castle Street, \r\nHertford, SG14 1ER","postcode":"SG14 1ER","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\/62948\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.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":62948,"agent_company_id":54,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000C0742B28009B4BFA6EF3504C7E54940","agent_brand_id":216,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21 Castle Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"William H. Brown","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"Hertford@williamhbrown.co.uk","has_email":true,"h_phone":"01992 586501","has_phone":true,"resolved_brand_color":"#8dc3d9","boundary_listing_count":"54","property_count":"64","latitude":51.795136,"longitude":-0.07827},{"core_branch_id":62943,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hamptons","email":"Nadya.basrawi@hamptons.co.uk","sales_phone_number":"01992 939249","address":"10-11 Market Place,\r\nHertford,\r\nSG14 1DG","postcode":"SG14 1DG","website_url":"https:\/\/www.hamptons.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62943\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:58:34.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62943,"agent_company_id":248,"branch_location":"Hertford","lettings_phone_number":"01992 949295","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EE5A423EE8D9BCBFB515FBCBEEE94940","agent_brand_id":533,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10-11 Market Place, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hamptons","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"Nadya.basrawi@hamptons.co.uk","has_email":true,"h_phone":"01992 939249","has_phone":true,"resolved_brand_color":"#14294c","boundary_listing_count":"19","property_count":"50","latitude":51.8276,"longitude":-0.1127},{"core_branch_id":62949,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Thomas Childs \u0026 Co","email":"sales@thomas-childs.com","sales_phone_number":"01992 721321","address":"9 Parliament Square\r\nHertford\r\nSG14 1EY","postcode":"SG14 1EY","website_url":"http:\/\/thomas-childs.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62949\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.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":62949,"agent_company_id":1535,"branch_location":"Hertford","lettings_phone_number":"01992 721321","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000047AD307DAF21B4BF3E9468C9E3E54940","agent_brand_id":2108,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 Parliament Square, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Thomas Childs \u0026 Co","branch_name":"Hertford","lettings":true,"sales":true,"commercial":false,"h_email":"sales@thomas-childs.com","has_email":true,"h_phone":"01992 721321","has_phone":true,"resolved_brand_color":"#012d5f","boundary_listing_count":"11","property_count":"22","latitude":51.796014,"longitude":-0.078639},{"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":"10","property_count":"35","latitude":51.796722,"longitude":-0.074664},{"core_branch_id":62934,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Big Black Hen.Com","email":"enquiries@bigblackhen.com","sales_phone_number":"01992 878580","address":"First Floor,\r\n3 Crane Mead,\r\nWare,\r\nSG12 9PZ","postcode":"SG12 9PZ","website_url":"http:\/\/www.bigblackhen.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62934\/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":62934,"agent_company_id":2699,"branch_location":"Hertfordshire","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006362F3716DA898BF3F1BB96E4AE74940","agent_brand_id":3349,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"First Floor, 3 Crane Mead, Ware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Big Black Hen.Com","branch_name":"Hertfordshire","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@bigblackhen.com","has_email":true,"h_phone":"01992 878580","has_phone":true,"resolved_brand_color":"#b07f5e","boundary_listing_count":"9","property_count":"28","latitude":51.806959,"longitude":-0.02408},{"core_branch_id":54833,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Greenhill Sales and Lettings Limited","email":null,"sales_phone_number":"01707 802001","address":"Sopers House Sopers Road,\r\nCuffley,\r\nEN6 4RY","postcode":"EN6 4RY","website_url":null,"description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54833\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:57:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54833,"agent_company_id":7007,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008195438B6CE7BBBFD122DBF97EDA4940","agent_brand_id":7846,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Sopers House Sopers Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Greenhill Sales and Lettings Limited","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01707 802001","has_phone":true,"resolved_brand_color":"#143635","boundary_listing_count":"8","property_count":"22","latitude":51.707,"longitude":-0.109},{"core_branch_id":62922,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Elliot Heath","email":null,"sales_phone_number":"01920 293333","address":"7 Star Street,\r\nWare,\r\nSG12 7AA","postcode":"SG12 7AA","website_url":"http:\/\/www.elliotheath.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\/62922\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:58:01.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62922,"agent_company_id":2701,"branch_location":"Ware","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000093ACC3D155BA9BBFD02B9E7AA4E74940","agent_brand_id":3352,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"7 Star Street, Ware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Elliot Heath","branch_name":"Ware","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01920 293333","has_phone":true,"resolved_brand_color":"#7f9fa3","boundary_listing_count":"7","property_count":"129","latitude":51.809707,"longitude":-0.027078},{"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":"7","property_count":"1331","latitude":50.724024,"longitude":-1.863818},{"core_branch_id":62933,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Taylor Phelps","email":"hello@taylorphelps.co.uk","sales_phone_number":"01920 459000","address":"5 Frenchs Yard\r\nWare Town Centre\r\nHertfordshire\r\nSG12 9HP","postcode":"SG12 9HP","website_url":"https:\/\/www.taylorphelps.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\/62933\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:55:53.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62933,"agent_company_id":2707,"branch_location":"Ware","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000751F80D4264E9EBF897956D28AE74940","agent_brand_id":3358,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 Frenchs Yard, Ware Town Centre, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Taylor Phelps","branch_name":"Ware","lettings":false,"sales":true,"commercial":false,"h_email":"hello@taylorphelps.co.uk","has_email":true,"h_phone":"01920 459000","has_phone":true,"resolved_brand_color":"#ffc020","boundary_listing_count":"7","property_count":"65","latitude":51.808924,"longitude":-0.029595},{"core_branch_id":62947,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ward Estates","email":"info@wardestates.com","sales_phone_number":"01992 472025","address":"12-14 Parliament Square,\r\nHertford,\r\nSG14 1EF","postcode":"SG14 1EF","website_url":"http:\/\/www.wardestates.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62947\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:57:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62947,"agent_company_id":1531,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000008BFCFA2136B4BF7D96E7C1DDE54940","agent_brand_id":2104,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12-14 Parliament Square, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ward Estates","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"info@wardestates.com","has_email":true,"h_phone":"01992 472025","has_phone":true,"resolved_brand_color":"#0053ff","boundary_listing_count":"6","property_count":"8","latitude":51.79583,"longitude":-0.078951},{"core_branch_id":62935,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Anthony Lettings","email":"newleads@anthonylettings.co.uk","sales_phone_number":"01992 503200","address":"Yeomans Court,\r\nHertford,\r\nSG13 7HJ","postcode":"SG13 7HJ","website_url":"http:\/\/www.anthonylettings.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\/62935\/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":62935,"agent_company_id":8443,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C43E0114234BB2BF2123A0C211E64940","agent_brand_id":9315,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Yeomans Court, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Anthony Lettings","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"newleads@anthonylettings.co.uk","has_email":true,"h_phone":"01992 503200","has_phone":true,"resolved_brand_color":"#fe713b","boundary_listing_count":"5","property_count":"8","latitude":51.797417,"longitude":-0.071459},{"core_branch_id":62939,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lanes","email":"he@lanesproperty.co.uk","sales_phone_number":"01992 582000","address":"2 Market Street,\r\nHertford,\r\nSG14 1BD","postcode":"SG14 1BD","website_url":"https:\/\/www.lanesproperty.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\/62939\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:57:06.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62939,"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":1950,"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","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"he@lanesproperty.co.uk","has_email":true,"h_phone":"01992 582000","has_phone":true,"resolved_brand_color":"#1e0e52","boundary_listing_count":"5","property_count":"8","latitude":51.79667,"longitude":-0.076407},{"core_branch_id":62931,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Fine \u0026 Country","email":"ware@fineandcountry.com","sales_phone_number":"01920 443898","address":"Office 1, \r\n21 Baldock Street, \r\nWare, \r\nSG12 9DH","postcode":"SG12 9DH","website_url":"http:\/\/www.fineandcountry.com\/ware","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62931\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:57:06.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62931,"agent_company_id":2702,"branch_location":"Ware","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000172D40DB6AD6A1BF37A968ACFDE74940","agent_brand_id":3353,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 1, 21 Baldock Street, Ware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Fine \u0026 Country","branch_name":"Ware","lettings":false,"sales":true,"commercial":false,"h_email":"ware@fineandcountry.com","has_email":true,"h_phone":"01920 443898","has_phone":true,"resolved_brand_color":"#c08d41","boundary_listing_count":"4","property_count":"69","latitude":51.812429,"longitude":-0.034839},{"core_branch_id":62929,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jonathan Hunt Estate Agency","email":"daniel@jonathan-hunt.co.uk","sales_phone_number":"01920 411090","address":"20 High Street,\r\nWare,\r\nSG12 9BX","postcode":"SG12 9BX","website_url":"http:\/\/www.jonathanhunt.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\/62929\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:54:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62929,"agent_company_id":1718,"branch_location":"Ware","lettings_phone_number":"01920 411090","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003526C45C52B59DBFDD7BB8E4B8E74940","agent_brand_id":2302,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"20 High Street, Ware","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jonathan Hunt Estate Agency","branch_name":"Ware","lettings":true,"sales":true,"commercial":false,"h_email":"daniel@jonathan-hunt.co.uk","has_email":true,"h_phone":"01920 411090","has_phone":true,"resolved_brand_color":"#0a4132","boundary_listing_count":"4","property_count":"78","latitude":51.81033,"longitude":-0.029012},{"core_branch_id":62944,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Kings Group","email":"managersaleshertford@kings-group.net","sales_phone_number":"01992 586570","address":"28 Maidenhead Street,\r\nHertford,\r\nSG14 1DR","postcode":"SG14 1DR","website_url":"http:\/\/www.kings-group.net\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/62944\/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":62944,"agent_company_id":182,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000059A31EA2D11DB4BFA4C7EF6DFAE54940","agent_brand_id":457,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"28 Maidenhead Street, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Kings Group","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"managersaleshertford@kings-group.net","has_email":true,"h_phone":"01992 586570","has_phone":true,"resolved_brand_color":"#fff102","boundary_listing_count":"4","property_count":"9","latitude":51.796705,"longitude":-0.07858},{"core_branch_id":62942,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mount \u0026 Co.","email":"info@abelestateagent.co.uk","sales_phone_number":"01992 937011","address":"2 Market Place,\r\nHertford,\r\nSG14 1DF","postcode":"SG14 1DF","website_url":"https:\/\/abelestateagent.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\/62942\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:47.000000Z","updated_at":"2026-01-20T19:54:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62942,"agent_company_id":1529,"branch_location":"Hertford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B7CF2A33A5F5B3BFD732198EE7E54940","agent_brand_id":2101,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Market Place, Hertford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mount \u0026 Co.","branch_name":"Hertford","lettings":false,"sales":true,"commercial":false,"h_email":"info@abelestateagent.co.uk","has_email":true,"h_phone":"01992 937011","has_phone":true,"resolved_brand_color":"#002d55","boundary_listing_count":"3","property_count":"6","latitude":51.796129,"longitude":-0.077967},{"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":"3","property_count":"7984","latitude":51.512,"longitude":-0.218},{"core_branch_id":54770,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Anthony Davies","email":"simon@adlettings.com","sales_phone_number":"01992 470335","address":"27 High Street,\r\nHoddesdon,\r\nEN11 8SX","postcode":"EN11 8SX","website_url":"http:\/\/www.anthony-davies.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54770\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:20.000000Z","updated_at":"2026-01-20T20:00:27.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54770,"agent_company_id":1392,"branch_location":"Hoddesdon","lettings_phone_number":"01992 470335","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A87004A9143B8ABF1DCBBBEA01E14940","agent_brand_id":1944,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"27 High Street, Hoddesdon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Anthony Davies","branch_name":"Hoddesdon","lettings":true,"sales":true,"commercial":false,"h_email":"simon@adlettings.com","has_email":true,"h_phone":"01992 470335","has_phone":true,"resolved_brand_color":"#96c222","boundary_listing_count":"2","property_count":"23","latitude":51.757871,"longitude":-0.012808},{"core_branch_id":63027,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Chris Dellar Properties","email":"info@chrisdellar.co.uk","sales_phone_number":"01763 272605","address":"58A High Street,\r\nBuntingford,\r\nSG9 9AH","postcode":"SG9 9AH","website_url":"http:\/\/www.chrisdellar.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\/63027\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:50.000000Z","updated_at":"2026-01-20T19:54:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63027,"agent_company_id":1716,"branch_location":"Buntingford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F0A2AF20CD5894BFCF328B506CF94940","agent_brand_id":2300,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"58A High Street, Buntingford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Chris Dellar Properties","branch_name":"Buntingford","lettings":false,"sales":true,"commercial":false,"h_email":"info@chrisdellar.co.uk","has_email":true,"h_phone":"01763 272605","has_phone":true,"resolved_brand_color":"#344451","boundary_listing_count":"2","property_count":"26","latitude":51.948618,"longitude":-0.01987},{"core_branch_id":63021,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ensum Brown","email":"royston@ensumbrown.com","sales_phone_number":"01763 750000","address":"Kooky Nohmad,\r\n42 High Street,\r\nRoyston,\r\nSG8 9AG","postcode":"SG8 9AG","website_url":"http:\/\/www.ensumbrown.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/63021\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:50.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":63021,"agent_company_id":270,"branch_location":"Royston","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005A643BDF4F8D97BFBC74931804064A40","agent_brand_id":562,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Kooky Nohmad, 42 High Street, Royston","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ensum Brown","branch_name":"Royston","lettings":false,"sales":true,"commercial":false,"h_email":"royston@ensumbrown.com","has_email":true,"h_phone":"01763 750000","has_phone":true,"resolved_brand_color":"#b01a41","boundary_listing_count":"2","property_count":"300","latitude":52.047,"longitude":-0.023},{"core_branch_id":62924,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Peter Cuffaro Estate Agents","email":null,"sales_phone_number":"01920 633333","address":"19 High Street,\r\nStanstead Abbotts,\r\nSG12 8AA","postcode":"SG12 8AA","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\/62924\/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":62924,"agent_company_id":2706,"branch_location":"Stanstead Abbotts","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000008228B34F10E803F5C01857AFAE44940","agent_brand_id":3357,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"19 High Street, Stanstead Abbotts","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Peter Cuffaro Estate Agents","branch_name":"Stanstead Abbotts","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01920 633333","has_phone":true,"resolved_brand_color":"#00235f","boundary_listing_count":"2","property_count":"47","latitude":51.788894,"longitude":0.007841},{"core_branch_id":67529,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Strutt \u0026 Parker","email":"ian.friend@struttandparker.co.uk","sales_phone_number":"07760 998597","address":"Covering Cornwall","postcode":null,"website_url":"https:\/\/www.struttandparker.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/67529\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:17.000000Z","updated_at":"2025-12-12T07:53:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":67529,"agent_company_id":257,"branch_location":"Covering Cornwall","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003BFC3559A31E13C0BC94BA641C2D4940","agent_brand_id":547,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":null,"has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Strutt \u0026 Parker","branch_name":"Covering Cornwall","lettings":false,"sales":true,"commercial":false,"h_email":"ian.friend@struttandparker.co.uk","has_email":true,"h_phone":"07760 998597","has_phone":true,"resolved_brand_color":"#cb1144","boundary_listing_count":"2","property_count":"71","latitude":50.352429,"longitude":-4.77992},{"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":"1","property_count":"163","latitude":51.802234,"longitude":-0.206532},{"core_branch_id":60352,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Aspect Property","email":"info@aspect-property.com","sales_phone_number":"020 8965 0000","address":"41 Park Parade,\r\nLondon,\r\nNW10 4JE","postcode":"NW10 4JE","website_url":"http:\/\/www.aspect-property.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/60352\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:23.000000Z","updated_at":"2026-01-20T19:59:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60352,"agent_company_id":4695,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E5B9BE0F0709CFBF19E59997C3C44940","agent_brand_id":5446,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"41 Park Parade, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Aspect Property","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"info@aspect-property.com","has_email":true,"h_phone":"020 8965 0000","has_phone":true,"resolved_brand_color":"#f1dfc2","boundary_listing_count":"1","property_count":"35","latitude":51.537219,"longitude":-0.242463}]; 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`; } } }