Estate & Letting Agents in South Cambridgeshire, England

Find Estate Agents in South Cambridgeshire, England
215 results
Compare Best Local Agents
Bennett Lorusso Property Agents Limited
Bennett Lorusso Property Agents Limited

St Neots

Sales
1 active listing in South Cambridgeshire, England
60 total
17 Steam Flour Mill, Church Street, St Neots, Cambs PE19 2AB
View Profile
Best Residential
Best Residential

Hitchin

Lettings
1 active listing in South Cambridgeshire, England
13 total
PO BOX 366 Hitchin SG5 9DS
View Profile
Birch'S
Birch'S

Waterbeach

Sales
1 active listing in South Cambridgeshire, England
5 total
Bluebell Woods Ely Road, Waterbeach, CB25 9NW
View Profile
Bletsoes
Bletsoes

Thrapston

Sales
1 active listing in South Cambridgeshire, England
31 total
Oakleigh House, High Street, Thrapston, NN14 4LJ
View Profile
Butler and Co Estate Agents
Butler and Co Estate Agents

Covering East Anglia

Sales
1 active listing in South Cambridgeshire, England
11 total
Covering East Anglia
View Profile
Cheffins Residential
Cheffins Residential

Ely

Lettings Sales
1 active listing in South Cambridgeshire, England
185 total
25 Market Place, Ely, CB7 4NP
View Profile
Citystay Living
Citystay Living

Cambridge

Lettings
1 active listing in South Cambridgeshire, England
2 Nuffield Close, Cambridge, CB4 1SS
View Profile
Citystay Property Agents
Citystay Property Agents

Cambridge

Sales
1 active listing in South Cambridgeshire, England
4 total
2 Nuffield Close, Cambridge, CB4 1SS
View Profile
Daniel Brewer Estate Agents
Daniel Brewer Estate Agents

Essex

Sales
1 active listing in South Cambridgeshire, England
164 total
51 High Street Dunmow Essex CM6 1AE
View Profile
Embassy Lettings & Management Limited
Embassy Lettings & Management Limited

Cambridge

Lettings
1 active listing in South Cambridgeshire, England
9 total
27 Franks Lane Cambridge CB4 1RR
View Profile
Ensum Brown
Ensum Brown

Newmarket

Sales
1 active listing in South Cambridgeshire, England
65 total
Cleveland House, Old Station Road, Newmarket, CB8 8QE
View Profile
Express Estate Agency
Express Estate Agency

Nationwide

Lettings Sales
1 active listing in South Cambridgeshire, England
837 total
St Georges House, 56 Peter St, Manchester M2 3NQ
View Profile
Fmx Properties LTD
Fmx Properties LTD

London

Sales
1 active listing in South Cambridgeshire, England
40 total
Gloucester Road, TW9 3BX
View Profile
Greenhill Sales and Lettings Limited
Greenhill Sales and Lettings Limited

Cuffley

Sales
1 active listing in South Cambridgeshire, England
22 total
Sopers House Sopers Road, Cuffley, EN6 4RY
View Profile
Haart
Haart

Ely

Sales
1 active listing in South Cambridgeshire, England
101 total
1a Forehill, Ely, CB7 4AA
View Profile
Hanson Partners
Hanson Partners

Covering Nationwide

Sales
1 active listing in South Cambridgeshire, England
5 total
London
View Profile
Hazell & Kent
Hazell & Kent

Cambridge

Sales
1 active listing in South Cambridgeshire, England
33 total
168 - 170 Mill Road, Cambridge, CB1 3LP
View Profile
Hockeys
Hockeys

Newmarket

Sales
1 active listing in South Cambridgeshire, England
109 total
97 High Street Newmarket CB8 8JH
View Profile
Inskip & Davie
Inskip & Davie

Sandy

Lettings Sales
1 active listing in South Cambridgeshire, England
66 total
2-4 Park Road, Sandy, SG19 1JB
View Profile
Jackson-Stops
Jackson-Stops

Newmarket

Sales
1 active listing in South Cambridgeshire, England
50 total
168 High Street, Newmarket, CB8 9AJ
View Profile
Jukes Estate Agents
Jukes Estate Agents

Harlow

Sales
1 active listing in South Cambridgeshire, England
51 total
Latton Bush Centre, Southern Way, Harlow, CM18 7BL
View Profile
Keller Williams Plus
Keller Williams Plus

Covering Nationwide

Sales
1 active listing in South Cambridgeshire, England
608 total
Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford, CM1 3AG
View Profile
Kenneally Property Services
Kenneally Property Services

Peterborough

Sales
1 active listing in South Cambridgeshire, England
43 total
Ground Floor Unit A, Greenhill House, Thorpe Road, Peterborough, PE3 6RU
View Profile
Knightsbridge Land
Knightsbridge Land

London

Sales
1 active listing in South Cambridgeshire, England
23 total
Prospect House 2 Athenaeum Road London N20 9AE
View Profile
Lemontree Properties
Lemontree Properties

Newmarket

Lettings
1 active listing in South Cambridgeshire, England
18 total
10a Old Station Road, Newmarket, CB8 8DN
View Profile
Mccarthy & Stone Resales
Mccarthy & Stone Resales

-

Sales
1 active listing in South Cambridgeshire, England
1,330 total
100 Holdenhurst Road, Bournemouth, BH8 8AQ
View Profile
Mchugh & Co
Mchugh & Co

London

Sales
1 active listing in South Cambridgeshire, England
368 total
71 Parkway, London, NW1 7PP
View Profile
Mcqueens London
Mcqueens London

London

Sales
1 active listing in South Cambridgeshire, England
12 total
Eagle House, The Brew, 163 City Road, London, EC1V 1NR
View Profile
Michaels Property Consultants LTD
Michaels Property Consultants LTD

Halstead

Sales
1 active listing in South Cambridgeshire, England
76 total
8 Bridge Street, Halstead, CO9 1HT
View Profile
Mullucks
Mullucks

Bishop'S Stortford

Lettings Sales
1 active listing in South Cambridgeshire, England
105 total
Guild House, Water Lane, Bishop's Stortford, CM23 2JZ
View Profile
initializeAllPremierCards() }); // Load detailed stats function function loadDetailedStats() { const button = document.getElementById('load-more-stats'); const statsContainer = document.getElementById('detailed-stats'); if (statsContainer.classList.contains('hidden')) { // Show loading state button.innerHTML = ` Loading... `; // Make AJAX call for detailed stats const location = 'South Cambridgeshire, England'; const agentType = ''; fetch(`/api/agents/detailed-stats?location=${encodeURIComponent(location)}&type=${agentType}`) .then(response => response.json()) .then(data => { // Build detailed stats HTML let statsHtml = '
'; // Property types breakdown if (data.propertyTypes && Object.keys(data.propertyTypes).length > 0) { statsHtml += `
Property Types
`; for (const [type, count] of Object.entries(data.propertyTypes)) { const percentage = Math.round((count / data.totalProperties) * 100); statsHtml += `
${type}: ${count.toLocaleString()} (${percentage}%)
`; } statsHtml += '
'; } // Price ranges if (data.priceRanges) { statsHtml += `
Price Ranges
Avg Sale Price: £${data.priceRanges.avgSalePrice?.toLocaleString() || 'N/A'}
Avg Rent PCM: £${data.priceRanges.avgRentPrice?.toLocaleString() || 'N/A'}
`; } // Top performing agents if (data.topAgents && data.topAgents.length > 0) { statsHtml += `
Top Agents
`; data.topAgents.slice(0, 3).forEach(agent => { statsHtml += `
${agent.name}: ${agent.property_count} props
`; }); statsHtml += '
'; } statsHtml += '
'; // Show stats statsContainer.innerHTML = statsHtml; statsContainer.classList.remove('hidden'); // Update button button.innerHTML = ` Hide Insights `; }) .catch(error => { // If API fails, show some calculated stats from existing data const agents = [{"core_branch_id":60983,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bennett Lorusso Property Agents Limited","email":"mike@bennettsanders.co.uk","sales_phone_number":"01480 211777","address":"17 Steam Flour Mill,\r\nChurch Street,\r\nSt Neots, Cambs\r\nPE19 2AB","postcode":"PE19 2AB","website_url":"http:\/\/www.bennettsanders.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\/60983\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:43.000000Z","updated_at":"2026-01-20T19:58:10.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60983,"agent_company_id":6609,"branch_location":"St Neots","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000429770E82D1ED1BFE3175E49F21C4A40","agent_brand_id":7437,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"17 Steam Flour Mill, Church Street, St Neots, Cambs","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bennett Lorusso Property Agents Limited","branch_name":"St Neots","lettings":false,"sales":true,"commercial":false,"h_email":"mike@bennettsanders.co.uk","has_email":true,"h_phone":"01480 211777","has_phone":true,"resolved_brand_color":"#51feb2","boundary_listing_count":"1","property_count":"60","latitude":52.226144,"longitude":-0.267467},{"core_branch_id":63000,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Best Residential","email":"info@bestresidential.co.uk","sales_phone_number":null,"address":"PO BOX 366\r\nHitchin\r\nSG5 9DS","postcode":"SG5 9DS","website_url":"https:\/\/www.bestresidential.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\/63000\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:49.000000Z","updated_at":"2026-01-20T20:01:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63000,"agent_company_id":9731,"branch_location":"Hitchin","lettings_phone_number":"01462 713713","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000567DAEB6627FD5BF2575029A08FB4940","agent_brand_id":10630,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"PO BOX 366, Hitchin","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Best Residential","branch_name":"Hitchin","lettings":true,"sales":false,"commercial":false,"h_email":"info@bestresidential.co.uk","has_email":true,"h_phone":"01462 713713","has_phone":true,"resolved_brand_color":"#0e4613","boundary_listing_count":"1","property_count":"13","latitude":51.9612,"longitude":-0.3359},{"core_branch_id":52035,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Birch\u0027S","email":"enquiries@birchsgroup.co.uk","sales_phone_number":"01223 661114","address":"Bluebell Woods Ely Road,\r\nWaterbeach,\r\nCB25 9NW","postcode":"CB25 9NW","website_url":"https:\/\/www.birchsgroup.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\/52035\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:50.000000Z","updated_at":"2026-01-20T19:53:29.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52035,"agent_company_id":5633,"branch_location":"Waterbeach","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009EB64604E3E0C63F99F5622827224A40","agent_brand_id":6429,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Bluebell Woods Ely Road, Waterbeach","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Birch\u0027S","branch_name":"Waterbeach","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@birchsgroup.co.uk","has_email":true,"h_phone":"01223 661114","has_phone":true,"resolved_brand_color":"#706f70","boundary_listing_count":"1","property_count":"5","latitude":52.26682,"longitude":0.178738},{"core_branch_id":59876,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bletsoes","email":"estateagents@bletsoes.co.uk","sales_phone_number":"01832 732188","address":"Oakleigh House,\r\nHigh Street,\r\nThrapston,\r\nNN14 4LJ","postcode":"NN14 4LJ","website_url":"http:\/\/www.bletsoes.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\/59876\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:08.000000Z","updated_at":"2026-01-20T19:54:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59876,"agent_company_id":8173,"branch_location":"Thrapston","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E84EB0FF3A37E1BFEC4D0CC9C9324A40","agent_brand_id":9038,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Oakleigh House, High Street, Thrapston","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bletsoes","branch_name":"Thrapston","lettings":false,"sales":true,"commercial":false,"h_email":"estateagents@bletsoes.co.uk","has_email":true,"h_phone":"01832 732188","has_phone":true,"resolved_brand_color":"#7d224b","boundary_listing_count":"1","property_count":"31","latitude":52.396783,"longitude":-0.537992},{"core_branch_id":66960,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Butler and Co Estate Agents","email":null,"sales_phone_number":"03301 338699","address":"Covering East Anglia","postcode":null,"website_url":"https:\/\/www.butlerandcoestateagents.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\/66960\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:59.000000Z","updated_at":"2025-12-09T23:21:15.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":66960,"agent_company_id":682,"branch_location":"Covering East Anglia","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":null,"agent_brand_id":1159,"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":"Butler and Co Estate Agents","branch_name":"Covering East Anglia","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"03301 338699","has_phone":true,"resolved_brand_color":"#ffa36d","boundary_listing_count":"1","property_count":"11","latitude":null,"longitude":null},{"core_branch_id":52069,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Cheffins Residential","email":"ely@cheffins.co.uk","sales_phone_number":"01353 654900","address":"25 Market Place,\r\nEly,\r\nCB7 4NP","postcode":"CB7 4NP","website_url":"http:\/\/www.cheffins.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\/52069\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-01-20T19:57:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52069,"agent_company_id":981,"branch_location":"Ely","lettings_phone_number":"01353 654900","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006C43C5387F13D13F62F8889812334A40","agent_brand_id":1499,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"25 Market Place, Ely","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Cheffins Residential","branch_name":"Ely","lettings":true,"sales":true,"commercial":false,"h_email":"ely@cheffins.co.uk","has_email":true,"h_phone":"01353 654900","has_phone":true,"resolved_brand_color":"#011335","boundary_listing_count":"1","property_count":"185","latitude":52.399005,"longitude":0.266815},{"core_branch_id":52044,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Citystay Living","email":null,"sales_phone_number":null,"address":"2 Nuffield Close,\r\nCambridge,\r\nCB4 1SS","postcode":"CB4 1SS","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\/52044\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:50.000000Z","updated_at":"2026-01-20T19:57:27.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52044,"agent_company_id":3978,"branch_location":"Cambridge","lettings_phone_number":"01223 420920","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C443183F8D7BC33F289CDD5A261D4A40","agent_brand_id":4693,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Nuffield Close, Cambridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Citystay Living","branch_name":"Cambridge","lettings":true,"sales":false,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01223 420920","has_phone":true,"resolved_brand_color":"#f4efea","boundary_listing_count":"1","property_count":"1","latitude":52.227733,"longitude":0.152208},{"core_branch_id":52045,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Citystay Property Agents","email":null,"sales_phone_number":"01223 658228","address":"2 Nuffield Close,\r\nCambridge,\r\nCB4 1SS","postcode":"CB4 1SS","website_url":"https:\/\/www.citystaypropertyagents.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\/52045\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:50.000000Z","updated_at":"2026-01-20T19:56:46.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52045,"agent_company_id":3978,"branch_location":"Cambridge","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C443183F8D7BC33F289CDD5A261D4A40","agent_brand_id":4694,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Nuffield Close, Cambridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Citystay Property Agents","branch_name":"Cambridge","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01223 658228","has_phone":true,"resolved_brand_color":"#031c6b","boundary_listing_count":"1","property_count":"4","latitude":52.227733,"longitude":0.152208},{"core_branch_id":52665,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Daniel Brewer Estate Agents","email":"info@danielbrewer.co.uk","sales_phone_number":"01371 856585","address":"51 High Street\r\nDunmow\r\nEssex\r\nCM6 1AE\r\n","postcode":"CM6 1AE","website_url":"http:\/\/www.danielbrewer.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\/52665\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:11.000000Z","updated_at":"2026-01-20T19:52:48.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52665,"agent_company_id":1328,"branch_location":"Essex","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D99601672959D73F094E7D2079EF4940","agent_brand_id":1875,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"51 High Street, Dunmow, Essex","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Daniel Brewer Estate Agents","branch_name":"Essex","lettings":false,"sales":true,"commercial":false,"h_email":"info@danielbrewer.co.uk","has_email":true,"h_phone":"01371 856585","has_phone":true,"resolved_brand_color":"#831d3c","boundary_listing_count":"1","property_count":"164","latitude":51.870884,"longitude":0.364817},{"core_branch_id":52043,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Embassy Lettings \u0026 Management Limited","email":"info@embassylettings.co.uk","sales_phone_number":null,"address":"27 Franks Lane\r\nCambridge\r\nCB4 1RR\r\n","postcode":"CB4 1RR","website_url":"http:\/\/www.embassylettings.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\/52043\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:50.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":52043,"agent_company_id":3979,"branch_location":"Cambridge","lettings_phone_number":"07720 984987","is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000A565A4DE5339C33F95826E2F691C4A40","agent_brand_id":4695,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"27 Franks Lane, Cambridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Embassy Lettings \u0026 Management Limited","branch_name":"Cambridge","lettings":true,"sales":false,"commercial":false,"h_email":"info@embassylettings.co.uk","has_email":true,"h_phone":"07720 984987","has_phone":true,"resolved_brand_color":"#e1ffee","boundary_listing_count":"1","property_count":"9","latitude":52.22196,"longitude":0.150187},{"core_branch_id":52078,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ensum Brown","email":"lettings@ensumbrown.com","sales_phone_number":"01638 280030","address":"Cleveland House, \r\nOld Station Road,\r\nNewmarket,\r\nCB8 8QE","postcode":"CB8 8QE","website_url":"https:\/\/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\/52078\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-01-20T19:52:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52078,"agent_company_id":984,"branch_location":"Newmarket","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D508FD4CBD6EDA3FFE7C5BB0541F4A40","agent_brand_id":1502,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Cleveland House, Old Station Road, Newmarket","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ensum Brown","branch_name":"Newmarket","lettings":false,"sales":true,"commercial":false,"h_email":"lettings@ensumbrown.com","has_email":true,"h_phone":"01638 280030","has_phone":true,"resolved_brand_color":"#b11a40","boundary_listing_count":"1","property_count":"65","latitude":52.244772,"longitude":0.413009},{"core_branch_id":58255,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Express Estate Agency","email":"Melissa.traynor@expressestateagency.co.uk","sales_phone_number":"03330 165458","address":"St Georges House, 56 Peter St, Manchester M2 3NQ","postcode":"M2 3NQ","website_url":"https:\/\/www.expressestateagency.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\/58255\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:16.000000Z","updated_at":"2026-01-20T19:57:43.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58255,"agent_company_id":2261,"branch_location":"Nationwide","lettings_phone_number":"03330 165458","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000322C495B3F701C002D9EBDD1FBD4A40","agent_brand_id":2878,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"St Georges House, 56 Peter St, Manchester","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Express Estate Agency","branch_name":"Nationwide","lettings":true,"sales":true,"commercial":false,"h_email":"Melissa.traynor@expressestateagency.co.uk","has_email":true,"h_phone":"03330 165458","has_phone":true,"resolved_brand_color":"#cf197a","boundary_listing_count":"1","property_count":"837","latitude":53.477535,"longitude":-2.245948},{"core_branch_id":65487,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Fmx Properties LTD","email":null,"sales_phone_number":"07375 049961","address":"Gloucester Road, TW9 3BX ","postcode":"TW9 3BX","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\/65487\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:22:10.000000Z","updated_at":"2026-01-20T19:55:06.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":65487,"agent_company_id":8324,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E9263108AC1CD2BF21B0726891BD4940","agent_brand_id":9191,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Gloucester Road","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Fmx Properties LTD","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"07375 049961","has_phone":true,"resolved_brand_color":"#4eaed2","boundary_listing_count":"1","property_count":"40","latitude":51.481,"longitude":-0.283},{"core_branch_id":54833,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Greenhill Sales and Lettings Limited","email":null,"sales_phone_number":"01707 802001","address":"Sopers House Sopers Road,\r\nCuffley,\r\nEN6 4RY","postcode":"EN6 4RY","website_url":null,"description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/54833\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:22.000000Z","updated_at":"2026-01-20T19:57:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54833,"agent_company_id":7007,"branch_location":"Cuffley","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008195438B6CE7BBBFD122DBF97EDA4940","agent_brand_id":7846,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Sopers House Sopers Road, Cuffley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Greenhill Sales and Lettings Limited","branch_name":"Cuffley","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01707 802001","has_phone":true,"resolved_brand_color":"#143635","boundary_listing_count":"1","property_count":"22","latitude":51.707,"longitude":-0.109},{"core_branch_id":52063,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Haart","email":"0141@spicerhaart.com","sales_phone_number":"01353 664112","address":"1a Forehill,\r\nEly,\r\nCB7 4AA","postcode":"CB7 4AA","website_url":"https:\/\/www.haart.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52063\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-01-20T19:57:51.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52063,"agent_company_id":163,"branch_location":"Ely","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BDC458A65F22D13F1F679AB0FD324A40","agent_brand_id":405,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1a Forehill, Ely","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Haart","branch_name":"Ely","lettings":false,"sales":true,"commercial":false,"h_email":"0141@spicerhaart.com","has_email":true,"h_phone":"01353 664112","has_phone":true,"resolved_brand_color":"#46195f","boundary_listing_count":"1","property_count":"101","latitude":52.398367,"longitude":0.267723},{"core_branch_id":67137,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hanson Partners","email":null,"sales_phone_number":"020 3633 1819","address":"London","postcode":null,"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\/67137\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:05.000000Z","updated_at":"2025-12-09T23:22:02.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":67137,"agent_company_id":3904,"branch_location":"Covering Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":null,"agent_brand_id":4617,"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":"Hanson Partners","branch_name":"Covering Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 3633 1819","has_phone":true,"resolved_brand_color":"#e8d9cd","boundary_listing_count":"1","property_count":"5","latitude":null,"longitude":null},{"core_branch_id":51979,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hazell \u0026 Kent","email":null,"sales_phone_number":"01223 778081","address":"168 - 170 Mill Road,\r\nCambridge,\r\nCB1 3LP","postcode":"CB1 3LP","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\/51979\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:48.000000Z","updated_at":"2026-01-20T19:52:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":51979,"agent_company_id":6223,"branch_location":"Cambridge","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008B506C054D4BC23F58C85C1954194A40","agent_brand_id":7042,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"168 - 170 Mill Road, Cambridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hazell \u0026 Kent","branch_name":"Cambridge","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01223 778081","has_phone":true,"resolved_brand_color":"#262e59","boundary_listing_count":"1","property_count":"33","latitude":52.197879,"longitude":0.142923},{"core_branch_id":52076,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hockeys","email":"newmarket@hockeys.co.uk","sales_phone_number":"01638 354553","address":"97 High Street\r\nNewmarket\r\nCB8 8JH","postcode":"CB8 8JH","website_url":"https:\/\/www.hockeys.co.uk\/estate-agents\/newmarket\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52076\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-02-06T12:30:48.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52076,"agent_company_id":100285,"branch_location":"Newmarket","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000011C30E63D2DFD93FAF95D05D121F4A40","agent_brand_id":10827,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"97 High Street, Newmarket","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hockeys","branch_name":"Newmarket","lettings":false,"sales":true,"commercial":false,"h_email":"newmarket@hockeys.co.uk","has_email":true,"h_phone":"01638 354553","has_phone":true,"resolved_brand_color":"#003f50","boundary_listing_count":"1","property_count":"109","latitude":52.242748,"longitude":0.404286},{"core_branch_id":62967,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Inskip \u0026 Davie","email":"Daniel@inskipanddavie.co.uk","sales_phone_number":"01767 699090","address":"2-4 Park Road,\r\nSandy,\r\nSG19 1JB","postcode":"SG19 1JB","website_url":"http:\/\/www.inskipanddavie.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\/62967\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:20:48.000000Z","updated_at":"2026-01-20T19:57:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":62967,"agent_company_id":9315,"branch_location":"Sandy","lettings_phone_number":"01767 699090","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003B8A73D4D171D2BF16F9F5436C104A40","agent_brand_id":10211,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2-4 Park Road, Sandy","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Inskip \u0026 Davie","branch_name":"Sandy","lettings":true,"sales":true,"commercial":false,"h_email":"Daniel@inskipanddavie.co.uk","has_email":true,"h_phone":"01767 699090","has_phone":true,"resolved_brand_color":"#ffc00f","boundary_listing_count":"1","property_count":"66","latitude":52.128304,"longitude":-0.288197},{"core_branch_id":52081,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jackson-Stops","email":"newmarket@jackson-stops.co.uk","sales_phone_number":"01638 662231","address":"168 High Street,\r\nNewmarket,\r\nCB8 9AJ","postcode":"CB8 9AJ","website_url":"https:\/\/www.jackson-stops.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\/52081\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-01-20T19:52:42.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52081,"agent_company_id":986,"branch_location":"Newmarket","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000030BB270F0BB5D93F5BEA20AF071F4A40","agent_brand_id":1504,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"168 High Street, Newmarket","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jackson-Stops","branch_name":"Newmarket","lettings":false,"sales":true,"commercial":false,"h_email":"newmarket@jackson-stops.co.uk","has_email":true,"h_phone":"01638 662231","has_phone":true,"resolved_brand_color":"#151a45","boundary_listing_count":"1","property_count":"50","latitude":52.242422,"longitude":0.401675},{"core_branch_id":52588,"verification_status":"verified","verified_at":"2026-01-26T14:45:38.000000Z","verified_by":null,"verification_notes":null,"name":"Jukes Estate Agents","email":null,"sales_phone_number":"01279 295524","address":"Latton Bush Centre,\r\nSouthern Way,\r\nHarlow,\r\nCM18 7BL","postcode":"CM18 7BL","website_url":"https:\/\/www.jukesestates.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\/52588\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:08.000000Z","updated_at":"2026-01-26T14:45:38.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":52588,"agent_company_id":2169,"branch_location":"Harlow","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000069C9E369F981BB3FEC3191D26CE04940","agent_brand_id":2783,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Latton Bush Centre, Southern Way, Harlow","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jukes Estate Agents","branch_name":"Harlow","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01279 295524","has_phone":true,"resolved_brand_color":"#192855","boundary_listing_count":"1","property_count":"51","latitude":51.753321,"longitude":0.107452},{"core_branch_id":52529,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Keller Williams Plus","email":"wonmaungthein@gmail.com","sales_phone_number":"07753375229","address":"Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford, CM1 3AG","postcode":"G5 0GY","website_url":"https:\/\/www.kwukplus.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/52529\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:06.000000Z","updated_at":"2026-01-21T17:12:44.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52529,"agent_company_id":3836,"branch_location":"Covering Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007250C24CDBBFDC3F2AFF5A5EB9DC4940","agent_brand_id":4537,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Suite 1G, Widford Business Centre, 33 Robjohns Road, Chelmsford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Keller Williams Plus","branch_name":"Covering Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"wonmaungthein@gmail.com","has_email":true,"h_phone":"07753375229","has_phone":true,"resolved_brand_color":"#cb011e","boundary_listing_count":"1","property_count":"608","latitude":51.724407,"longitude":0.44921},{"core_branch_id":61069,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Kenneally Property Services","email":"dkenneally@kenneallypropertyservices.co.uk","sales_phone_number":null,"address":"Ground Floor Unit A,\r\nGreenhill House,\r\nThorpe Road,\r\nPeterborough,\r\nPE3 6RU","postcode":"PE3 6RU","website_url":"http:\/\/www.kenneallypropertyservices.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\/61069\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:46.000000Z","updated_at":"2026-01-20T19:54:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61069,"agent_company_id":6374,"branch_location":"Peterborough","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000010E9B7AF03E7D2BFC84274081C494A40","agent_brand_id":7196,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Ground Floor Unit A, Greenhill House, Thorpe Road, Peterborough","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Kenneally Property Services","branch_name":"Peterborough","lettings":false,"sales":true,"commercial":false,"h_email":"dkenneally@kenneallypropertyservices.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#fff455","boundary_listing_count":"1","property_count":"43","latitude":52.571168,"longitude":-0.29535},{"core_branch_id":59136,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Knightsbridge Land","email":"info@knightsbridgeland.com","sales_phone_number":"020 3583 5058","address":"Prospect House\r\n2 Athenaeum Road\r\nLondon\r\nN20 9AE","postcode":"N20 9AE","website_url":"http:\/\/media.estatesit.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59136\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:44.000000Z","updated_at":"2026-01-20T19:53:57.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59136,"agent_company_id":5767,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000363E93FDF334C6BF1A6A1492CCD04940","agent_brand_id":6573,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Prospect House, 2 Athenaeum Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Knightsbridge Land","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"info@knightsbridgeland.com","has_email":true,"h_phone":"020 3583 5058","has_phone":true,"resolved_brand_color":"#373c19","boundary_listing_count":"1","property_count":"23","latitude":51.631243,"longitude":-0.173491},{"core_branch_id":52075,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lemontree Properties","email":"beth@lemontreeproperties.co.uk","sales_phone_number":null,"address":"10a \r\nOld Station Road, \r\nNewmarket, \r\nCB8 8DN","postcode":"CB8 8DN","website_url":"https:\/\/www.lemontreeproperties.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\/52075\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:51.000000Z","updated_at":"2026-01-20T19:53:51.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52075,"agent_company_id":987,"branch_location":"Newmarket","lettings_phone_number":null,"is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E7FBA9F1D24DDA3F8FC2F5285C1F4A40","agent_brand_id":1506,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10a, Old Station Road, Newmarket","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lemontree Properties","branch_name":"Newmarket","lettings":true,"sales":false,"commercial":false,"h_email":"beth@lemontreeproperties.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#fdd100","boundary_listing_count":"1","property_count":"18","latitude":52.245,"longitude":0.411},{"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":"1","property_count":"1330","latitude":50.724024,"longitude":-1.863818},{"core_branch_id":60325,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mchugh \u0026 Co","email":"sales@mchughandcompany.co.uk","sales_phone_number":"020 7485 0112","address":"71 Parkway,\r\nLondon,\r\nNW1 7PP","postcode":"NW1 7PP","website_url":"http:\/\/www.mchughandco.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/60325\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:22.000000Z","updated_at":"2026-01-20T19:54:08.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60325,"agent_company_id":3692,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006F675F79909EC2BFCC7B9C69C2C44940","agent_brand_id":4383,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"71 Parkway, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mchugh \u0026 Co","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"sales@mchughandcompany.co.uk","has_email":true,"h_phone":"020 7485 0112","has_phone":true,"resolved_brand_color":"#30c05e","boundary_listing_count":"1","property_count":"368","latitude":51.537183,"longitude":-0.145464},{"core_branch_id":54441,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mcqueens London","email":"jamal.gormati@gmail.com","sales_phone_number":"07734 052999","address":"Eagle House, \r\nThe Brew, \r\n163 City Road,\r\nLondon,\r\nEC1V 1NR","postcode":"EC1V 1NR","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\/54441\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:09.000000Z","updated_at":"2026-01-20T19:53:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":54441,"agent_company_id":7387,"branch_location":"London","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003C4D66BCADF4B6BF967840D994C34940","agent_brand_id":8231,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Eagle House, The Brew, 163 City Road, London","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mcqueens London","branch_name":"London","lettings":false,"sales":true,"commercial":false,"h_email":"jamal.gormati@gmail.com","has_email":true,"h_phone":"07734 052999","has_phone":true,"resolved_brand_color":"#f40101","boundary_listing_count":"1","property_count":"12","latitude":51.52798,"longitude":-0.089671},{"core_branch_id":52837,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Michaels Property Consultants LTD","email":"halstead@michaelsproperty.co.uk","sales_phone_number":"01787 322799","address":"8 Bridge Street,\r\nHalstead,\r\nCO9 1HT","postcode":"CO9 1HT","website_url":"https:\/\/michaelsproperty.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\/52837\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:17.000000Z","updated_at":"2026-01-20T19:56:58.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52837,"agent_company_id":2341,"branch_location":"Halstead","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F4DC42572250E43F93020B60CAF84940","agent_brand_id":2966,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"8 Bridge Street, Halstead","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Michaels Property Consultants LTD","branch_name":"Halstead","lettings":false,"sales":true,"commercial":false,"h_email":"halstead@michaelsproperty.co.uk","has_email":true,"h_phone":"01787 322799","has_phone":true,"resolved_brand_color":"#c3d532","boundary_listing_count":"1","property_count":"76","latitude":51.943676,"longitude":0.634782},{"core_branch_id":52626,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Mullucks","email":"sscott@mullucks.co.uk","sales_phone_number":"01279 755400","address":"Guild House,\r\nWater Lane,\r\nBishop\u0027s Stortford,\r\nCM23 2JZ","postcode":"CM23 2JZ","website_url":"https:\/\/www.mullucks.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\/52626\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:09.000000Z","updated_at":"2026-01-20T19:59:54.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52626,"agent_company_id":98,"branch_location":"Bishop\u0027S Stortford","lettings_phone_number":"01279 653067","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000CE6C57E88365C43F6BB75D68AEEF4940","agent_brand_id":297,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Guild House, Water Lane, Bishop\u0027s Stortford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Mullucks","branch_name":"Bishop\u0027S Stortford","lettings":true,"sales":true,"commercial":false,"h_email":"sscott@mullucks.co.uk","has_email":true,"h_phone":"01279 755400","has_phone":true,"resolved_brand_color":"#1f0f50","boundary_listing_count":"1","property_count":"105","latitude":51.87251,"longitude":0.159348}]; 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`; } } }