Estate Agents in Newark and Sherwood, Nottinghamshire

Find Estate Agents in Newark and Sherwood, Nottinghamshire
132 results
Exp UK
Exp UK

East Midlands

Sales
60 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
7,242 total
114 St. Martin's Lane London WC2N 4BE
View Featured Profile
Johnsons and Partners
Johnsons and Partners

Burton Joyce

Sales
8 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
70 total
111 Church Road, Burton Joyce, Nottingham, NG14 5DJ
View Featured Profile
Homemove Estate Agents LTD
Homemove Estate Agents LTD

Covering East Midlands

Sales
3 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
223 total
HomeMove Estate Agents Unit 2, Cottage Farm, Mears Ashby Road, Sywell, Northampton NN6 0BJ
View Featured Profile
Tristrams
Tristrams

Nottingham

Sales
2 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
127 total
260-262 Derby Road, Bramcote, Nottingham, NG9 3JN
View Featured Profile
Alexander Jacob LTD
Alexander Jacob LTD

Retford

Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
78 total
11 Grove Street, Retford, DN22 6JP
View Featured Profile
Tauk
Tauk

Covering Nationwide

Lettings Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
2,096 total
Covering Nationwide
View Featured Profile
The Avenue
The Avenue

Covering National

Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
306 total
Office 5, 10 Burnett Road, Sutton Coldfield, B74 3LP
View Featured Profile
Newton Fallowell

Newark

Sales
97 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
115 total
12 - 14 Middle Gate Newark NG24 1AG
View Profile
Martin & Co

Newark

Sales
23 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
2 - 4 Lombard Street, Newark, NG24 1XB
View Profile
Whitegates

Newark

Sales
11 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
Lombard Street, Newark, NG24 1XG
View Profile
Belvoir

Nottingham

Lettings Sales
5 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
45 total
23-25 Market Street, Nottingham NG1 6HX
View Profile
Martin & Co

Mansfield

Sales
5 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
42 total
4a Market Street Mansfield NG18 1JQ
Lovelle Estate Agency

North Hykeham

Lettings Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
86 total
32 The Forum, North Hykeham, Lincoln, LN6 8HW
View Profile
Newton Fallowell

Bingham

Lettings Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
44 total
Cranmer House Market Place, Bingham, NG13 8AN
View Profile
Whitegates

Sherwood

Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
49 total
564 Mansfield Road, Nottingham, NG5 2FS
View Profile
Whitegates

Dronfield

Sales
1 active listing in Newark and Sherwood, Nottinghamshire, East Midlands, England
31 total
Office 2, The Grange, Church Street, Dronfield, S18 1QB
Oliver Reilly

Newark

Sales
159 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
174 total
4 Middle Gate, Newark, NG24 1AG
View Profile
Buckleybrown

Mansfield

Sales
113 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
593 total
55-57 Leeming Street, Mansfield, Notts, NG18 1ND
View Profile
Richard Watkinson & Partners

Newark

Lettings Sales
73 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
95 total
25 Stodman Street Newark NG24 1AT
View Profile
Jon Brambles

Newark

Sales
69 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
82 total
9-10 Paxtons Court, Newark, Notts, NG24 1DH
View Profile
Edlin & Jarvis Estate Agents LTD
67 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
75 total
36 Middle Gate, Newark, NG24 1AL
View Profile
Gascoines

Southwell

Lettings Sales
54 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
71 total
1 Church Street, Southwell, NG25 0HQ
View Profile
William H. Brown

Newark

Sales
50 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
62 total
Newark,
View Profile
Chadwells Estate Agents

New Ollerton

Sales
49 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
50 total
Forest Road, New Ollerton, Newark, NG22 9QT
View Profile
Alasdair Morrison & Mundys
46 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
49 total
46 Middle Gate, Newark, NG24 1AL
View Profile
Alasdair Morrison & Mundys
43 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
47 total
22 King Street, Southwell, NG25 0EN
View Profile
Yopa

Nationwide

Sales
35 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
7,215 total
Meridian House Wheatfield Way Hinckley LE10 1YG
View Profile
Purplebricks

Covering Chester & Wirral

Lettings Sales
24 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
7,987 total
Purplebricks, 146 Freston Road, London, W10 6TR
View Profile
Richard Watkinson & Partners
24 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
26 total
20 King Street, Southwell, NG25 0EH
View Profile
Jf Village & Country Homes
21 active listings in Newark and Sherwood, Nottinghamshire, East Midlands, England
23 total
64 Main Street Farnsfield Nottingham NG22 8EF
View Profile
Page 1 of 5
initializeAllPremierCards() }); // Load detailed stats function function loadDetailedStats() { const button = document.getElementById('load-more-stats'); const statsContainer = document.getElementById('detailed-stats'); if (statsContainer.classList.contains('hidden')) { // Show loading state button.innerHTML = ` Loading... `; // Make AJAX call for detailed stats const location = 'Newark and Sherwood, Nottinghamshire'; 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":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":"60","property_count":"7242","latitude":51.509779,"longitude":-0.127137},{"core_branch_id":59588,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Johnsons and Partners","email":"enquiries@johnsonsandpartners.co.uk","sales_phone_number":"0115 931 2020","address":"111 Church Road,\r\nBurton Joyce,\r\nNottingham,\r\nNG14 5DJ","postcode":"NG14 5DJ","website_url":"http:\/\/www.johnsonsandpartners.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\/59588\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:59.000000Z","updated_at":"2026-01-20T19:54:03.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59588,"agent_company_id":2395,"branch_location":"Burton Joyce","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000002EAC1BEF8E8CF0BFBB4560AC6F7E4A40","agent_brand_id":3023,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"111 Church Road, Burton Joyce, Nottingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Johnsons and Partners","branch_name":"Burton Joyce","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@johnsonsandpartners.co.uk","has_email":true,"h_phone":"0115 931 2020","has_phone":true,"resolved_brand_color":"#64c8c8","boundary_listing_count":"8","property_count":"70","latitude":52.987783,"longitude":-1.034316},{"core_branch_id":59960,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Homemove Estate Agents LTD","email":"info@homemoveea.co.uk","sales_phone_number":"03333 220321","address":"HomeMove Estate Agents\r\nUnit 2, Cottage Farm,\r\nMears Ashby Road,\r\nSywell, Northampton\r\nNN6 0BJ","postcode":"NN6 0BJ","website_url":"https:\/\/homemoveea.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\/59960\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:11.000000Z","updated_at":"2026-01-20T19:58:56.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59960,"agent_company_id":5715,"branch_location":"Covering East Midlands","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000736891ED7C3FE9BFA245B6F3FD244A40","agent_brand_id":6517,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"HomeMove Estate Agents, Unit 2, Cottage Farm, Mears Ashby Road, Sywell, Northampton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Homemove Estate Agents LTD","branch_name":"Covering East Midlands","lettings":false,"sales":true,"commercial":false,"h_email":"info@homemoveea.co.uk","has_email":true,"h_phone":"03333 220321","has_phone":true,"resolved_brand_color":"#ffdd3a","boundary_listing_count":"3","property_count":"223","latitude":52.289,"longitude":-0.789},{"core_branch_id":59788,"verification_status":"verified","verified_at":"2026-01-08T10:51:03.000000Z","verified_by":null,"verification_notes":null,"name":"Tristrams","email":"fraser@tristrams.uk.com","sales_phone_number":"0115 828 4760","address":"260-262 Derby Road,\r\nBramcote,\r\nNottingham,\r\nNG9 3JN","postcode":"NG9 3JN","website_url":"http:\/\/www.tristrams.uk.com","description":"Tristrams is a family-run estate and letting agency serving Nottingham and Derby with a strong focus on customer service. Specializing in sales, lettings, and student properties, they offer a professional, single point of contact service to ensure a smooth client experience. Their modern approach, combined with a commitment to being \u0027Always Ahead\u0027, makes them a trusted partner in the local property market.","listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59788\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:05.000000Z","updated_at":"2026-01-20T19:54:04.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":59788,"agent_company_id":6986,"branch_location":"Nottingham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000F9669B1BD313F4BF5BD1E638B7774A40","agent_brand_id":7824,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":"#3896d2","logo_rect":null,"address_lines":"260-262 Derby Road, Bramcote, Nottingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Tristrams","branch_name":"Nottingham","lettings":false,"sales":true,"commercial":false,"h_email":"fraser@tristrams.uk.com","has_email":true,"h_phone":"0115 828 4760","has_phone":true,"resolved_brand_color":"#3896d2","boundary_listing_count":"2","property_count":"127","latitude":52.935279,"longitude":-1.25484},{"core_branch_id":53868,"verification_status":"verified","verified_at":"2026-02-10T14:40:19.000000Z","verified_by":null,"verification_notes":null,"name":"Alexander Jacob LTD","email":"info@alexanderjacob.co.uk","sales_phone_number":"01777 566400","address":"11 Grove Street,\r\nRetford,\r\nDN22 6JP","postcode":"DN22 6JP","website_url":"http:\/\/www.alexanderjacob.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\/53868\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:50.000000Z","updated_at":"2026-02-10T14:40:59.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":53868,"agent_company_id":3248,"branch_location":"Retford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000003BFC3559A31EEEBF1EFE9AAC51A94A40","agent_brand_id":3919,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"11 Grove Street, Retford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alexander Jacob LTD","branch_name":"Retford","lettings":false,"sales":true,"commercial":false,"h_email":"info@alexanderjacob.co.uk","has_email":true,"h_phone":"01777 566400","has_phone":true,"resolved_brand_color":"#5e5e5f","boundary_listing_count":"1","property_count":"78","latitude":53.322805,"longitude":-0.94124},{"core_branch_id":67542,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Tauk","email":null,"sales_phone_number":"020 4530 6761","address":"Covering Nationwide","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\/67542\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:18.000000Z","updated_at":"2026-01-16T23:13:55.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":67542,"agent_company_id":4769,"branch_location":"Covering Nationwide","lettings_phone_number":"07403 937217","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000750305DEC9A7BFBFA77A32FFE8C14940","agent_brand_id":5522,"offers_sales":true,"offers_lettings":true,"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":"Tauk","branch_name":"Covering Nationwide","lettings":true,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"020 4530 6761","has_phone":true,"resolved_brand_color":"#e0e0de","boundary_listing_count":"1","property_count":"2096","latitude":51.514923,"longitude":-0.123654},{"core_branch_id":50439,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"The Avenue","email":"home@theavenue.co.uk","sales_phone_number":"03300 432394","address":"Office 5,\r\n10 Burnett Road,\r\nSutton Coldfield,\r\nB74 3LP","postcode":"B74 3LP","website_url":"https:\/\/theavenue.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\/50439\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:58.000000Z","updated_at":"2026-01-20T19:52:28.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50439,"agent_company_id":3825,"branch_location":"Covering National","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E6100000C8CD70033E3FFEBF58C9C7EE024B4A40","agent_brand_id":4526,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 5, 10 Burnett Road, Sutton Coldfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"The Avenue","branch_name":"Covering National","lettings":false,"sales":true,"commercial":false,"h_email":"home@theavenue.co.uk","has_email":true,"h_phone":"03300 432394","has_phone":true,"resolved_brand_color":"#cbcab2","boundary_listing_count":"1","property_count":"306","latitude":52.586027,"longitude":-1.89044},{"core_branch_id":59673,"verification_status":"verified","verified_at":"2025-12-22T15:24:50.000000Z","verified_by":null,"verification_notes":null,"name":"Newton Fallowell","email":"newark@newtonfallowell.co.uk","sales_phone_number":"01636 706444","address":"12 - 14 \r\nMiddle Gate\r\nNewark\r\nNG24 1AG","postcode":"NG24 1AG","website_url":"http:\/\/www.newtonfallowell.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59673\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:19:01.000000Z","updated_at":"2026-01-20T19:55:31.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"live","assigned_user_id":null,"id":59673,"agent_company_id":44,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000014E7A8A3E3EAE9BF7BFA08FCE1894A40","agent_brand_id":84,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12 - 14, Middle Gate, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Newton Fallowell","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"newark@newtonfallowell.co.uk","has_email":true,"h_phone":"01636 706444","has_phone":true,"resolved_brand_color":"#ff5e21","boundary_listing_count":"97","property_count":"115","latitude":53.077209,"longitude":-0.809923},{"core_branch_id":59684,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"newark@martinco.com","sales_phone_number":"01636 605006","address":"2 - 4 Lombard Street,\r\nNewark,\r\nNG24 1XB","postcode":"NG24 1XB","website_url":"http:\/\/www.martinco.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59684\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:52.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59684,"agent_company_id":44,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C4EC65DB69EBE9BF66C0594A96894A40","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 - 4 Lombard Street, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"newark@martinco.com","has_email":true,"h_phone":"01636 605006","has_phone":true,"resolved_brand_color":"#006996","boundary_listing_count":"23","property_count":"23","latitude":53.074899,"longitude":-0.809987},{"core_branch_id":59685,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Whitegates","email":"newark@whitegates.co.uk","sales_phone_number":"01636 705868","address":"Lombard Street,\r\nNewark,\r\nNG24 1XG","postcode":"NG24 1XG","website_url":"https:\/\/www.whitegates.co.uk\/estate-agents-and-letting-agents\/branch\/newark","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59685\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:27.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59685,"agent_company_id":44,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000F6EB4E779EF8E9BF1F1494A295894A40","agent_brand_id":97,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Lombard Street, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Whitegates","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"newark@whitegates.co.uk","has_email":true,"h_phone":"01636 705868","has_phone":true,"resolved_brand_color":"#00324b","boundary_listing_count":"11","property_count":"11","latitude":53.074879,"longitude":-0.811599},{"core_branch_id":59548,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Belvoir","email":"Matthew.Hill@belvoir.co.uk","sales_phone_number":"0115 824 8800","address":"23-25 Market Street,\r\nNottingham\r\nNG1 6HX ","postcode":"NG1 6HX","website_url":"https:\/\/www.belvoir.co.uk\/nottingham-central-estate-agents","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59548\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:18:57.000000Z","updated_at":"2026-01-20T19:58:52.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59548,"agent_company_id":44,"branch_location":"Nottingham","lettings_phone_number":"0115 985 9259","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003BDF4F8D976EF2BF0AD7A3703D7A4A40","agent_brand_id":67,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"23-25 Market Street, Nottingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Belvoir","branch_name":"Nottingham","lettings":true,"sales":true,"commercial":false,"h_email":"Matthew.Hill@belvoir.co.uk","has_email":true,"h_phone":"0115 824 8800","has_phone":true,"resolved_brand_color":"#ba3232","boundary_listing_count":"5","property_count":"45","latitude":52.955,"longitude":-1.152},{"core_branch_id":59632,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Martin \u0026 Co","email":"mansfield@martinco.com","sales_phone_number":null,"address":"4a Market Street\r\nMansfield\r\nNG18 1JQ\r\n","postcode":"NG18 1JQ","website_url":"https:\/\/www.martinco.com\/estate-agents-and-letting-agents\/branch\/mansfield","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59632\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:19:00.000000Z","updated_at":"2026-01-20T19:55:25.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59632,"agent_company_id":44,"branch_location":"Mansfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E4486760E425F3BFAAD4EC8156924A40","agent_brand_id":83,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4a Market Street, Mansfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Martin \u0026 Co","branch_name":"Mansfield","lettings":false,"sales":true,"commercial":false,"h_email":"mansfield@martinco.com","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#006996","boundary_listing_count":"5","property_count":"42","latitude":53.143265,"longitude":-1.196751},{"core_branch_id":57801,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lovelle Estate Agency","email":"northhykeham@lovelle-property.co.uk","sales_phone_number":"01522 694775","address":"32 The Forum,\r\nNorth Hykeham,\r\nLincoln,\r\nLN6 8HW","postcode":"LN6 8HW","website_url":"https:\/\/www.lovelleestateagency.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/57801\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:18:00.000000Z","updated_at":"2026-01-20T19:57:44.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":57801,"agent_company_id":44,"branch_location":"North Hykeham","lettings_phone_number":"01522 694775","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E60297C79A91E2BF2D26361FD7984A40","agent_brand_id":82,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"32 The Forum, North Hykeham, Lincoln","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lovelle Estate Agency","branch_name":"North Hykeham","lettings":true,"sales":true,"commercial":false,"h_email":"northhykeham@lovelle-property.co.uk","has_email":true,"h_phone":"01522 694775","has_phone":true,"resolved_brand_color":"#003d51","boundary_listing_count":"1","property_count":"86","latitude":53.194065,"longitude":-0.580274},{"core_branch_id":59584,"verification_status":"verified","verified_at":"2025-12-22T15:24:50.000000Z","verified_by":null,"verification_notes":null,"name":"Newton Fallowell","email":"bingham@newtonfallowell.co.uk","sales_phone_number":"01949 839839","address":"Cranmer House Market Place,\r\nBingham,\r\nNG13 8AN","postcode":"NG13 8AN","website_url":"http:\/\/www.newtonfallowell.co.uk","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59584\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:18:59.000000Z","updated_at":"2026-01-20T20:00:53.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"live","assigned_user_id":null,"id":59584,"agent_company_id":44,"branch_location":"Bingham","lettings_phone_number":"01949 839839","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008E226B0DA576EEBFC0ED0912DB794A40","agent_brand_id":84,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Cranmer House Market Place, Bingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Newton Fallowell","branch_name":"Bingham","lettings":true,"sales":true,"commercial":false,"h_email":"bingham@newtonfallowell.co.uk","has_email":true,"h_phone":"01949 839839","has_phone":true,"resolved_brand_color":"#ff5e21","boundary_listing_count":"1","property_count":"44","latitude":52.951998,"longitude":-0.951983},{"core_branch_id":59739,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Whitegates","email":"sherwood@whitegates.co.uk","sales_phone_number":"0115 684 7173","address":"564 Mansfield Road,\r\nNottingham,\r\nNG5 2FS","postcode":"NG5 2FS","website_url":"https:\/\/www.whitegates.co.uk\/estate-agents-and-letting-agents\/branch\/nottingham-sherwood","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/59739\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:19:04.000000Z","updated_at":"2026-01-20T19:55:27.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":59739,"agent_company_id":44,"branch_location":"Sherwood","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000EB0088BB7A55F2BFDFA9807B9E7D4A40","agent_brand_id":97,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"564 Mansfield Road, Nottingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Whitegates","branch_name":"Sherwood","lettings":false,"sales":true,"commercial":false,"h_email":"sherwood@whitegates.co.uk","has_email":true,"h_phone":"0115 684 7173","has_phone":true,"resolved_brand_color":"#00324b","boundary_listing_count":"1","property_count":"49","latitude":52.981399,"longitude":-1.145869},{"core_branch_id":62298,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Whitegates","email":"info@xchangeproperties.co.uk","sales_phone_number":null,"address":"Office 2, \r\nThe Grange, \r\nChurch Street, \r\nDronfield, \r\nS18 1QB","postcode":"S18 1QB","website_url":"https:\/\/www.whitegates.co.uk\/estate-agents-and-letting-agents\/branch\/dronfield","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/62298\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:08.000000Z","created_at":"2025-12-09T17:20:26.000000Z","updated_at":"2026-01-20T19:55:29.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":62298,"agent_company_id":44,"branch_location":"Dronfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C520B0726891F7BF4A0C022B87A64A40","agent_brand_id":97,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Office 2, The Grange, Church Street, Dronfield","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Whitegates","branch_name":"Dronfield","lettings":false,"sales":true,"commercial":false,"h_email":"info@xchangeproperties.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#00324b","boundary_listing_count":"1","property_count":"31","latitude":53.301,"longitude":-1.473},{"core_branch_id":59674,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Oliver Reilly","email":"sales@oliver-reilly.co.uk","sales_phone_number":"01636 558540","address":"4 Middle Gate,\r\nNewark,\r\nNG24 1AG","postcode":"NG24 1AG","website_url":"https:\/\/oliver-reilly.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\/59674\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59674,"agent_company_id":6214,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000014E7A8A3E3EAE9BF7BFA08FCE1894A40","agent_brand_id":7033,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4 Middle Gate, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Oliver Reilly","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"sales@oliver-reilly.co.uk","has_email":true,"h_phone":"01636 558540","has_phone":true,"resolved_brand_color":"#224051","boundary_listing_count":"159","property_count":"174","latitude":53.077209,"longitude":-0.809923},{"core_branch_id":59633,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Buckleybrown","email":"mansfield@buckleybrown.co.uk","sales_phone_number":"01623 633633","address":"55-57 Leeming Street,\r\nMansfield,\r\nNotts,\r\nNG18 1ND","postcode":"NG18 1ND","website_url":"https:\/\/www.buckleybrown.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\/59633\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:00.000000Z","updated_at":"2026-01-20T19:56:07.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59633,"agent_company_id":1818,"branch_location":"Mansfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000992CEE3F321DF3BF19E59997C3924A40","agent_brand_id":2411,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"55-57 Leeming Street, Mansfield, Notts","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Buckleybrown","branch_name":"Mansfield","lettings":false,"sales":true,"commercial":false,"h_email":"mansfield@buckleybrown.co.uk","has_email":true,"h_phone":"01623 633633","has_phone":true,"resolved_brand_color":"#412c55","boundary_listing_count":"113","property_count":"593","latitude":53.146594,"longitude":-1.194628},{"core_branch_id":59677,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Richard Watkinson \u0026 Partners","email":"newark@richardwatkinson.co.uk","sales_phone_number":"01636 611811","address":"25\r\nStodman Street\r\nNewark\r\nNG24 1AT","postcode":"NG24 1AT","website_url":"http:\/\/www.richardwatkinson.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\/59677\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.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":59677,"agent_company_id":1479,"branch_location":"Newark","lettings_phone_number":"01636 677154","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000006CEA3C2AFEEFE9BF679C86A8C2894A40","agent_brand_id":2039,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"25, Stodman Street, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Richard Watkinson \u0026 Partners","branch_name":"Newark","lettings":true,"sales":true,"commercial":false,"h_email":"newark@richardwatkinson.co.uk","has_email":true,"h_phone":"01636 611811","has_phone":true,"resolved_brand_color":"#8f2433","boundary_listing_count":"73","property_count":"95","latitude":53.076253,"longitude":-0.810546},{"core_branch_id":59680,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jon Brambles","email":"sales@jonbrambles.com","sales_phone_number":"01636 613513","address":"9-10 Paxtons Court,\r\nNewark,\r\nNotts,\r\nNG24 1DH","postcode":"NG24 1DH","website_url":"http:\/\/www.jonbrambles.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59680\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.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":59680,"agent_company_id":6212,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E62329E961E8E9BF1F813FFCFC894A40","agent_brand_id":7031,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9-10 Paxtons Court, Newark, Notts","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jon Brambles","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"sales@jonbrambles.com","has_email":true,"h_phone":"01636 613513","has_phone":true,"resolved_brand_color":"#fd0000","boundary_listing_count":"69","property_count":"82","latitude":53.078033,"longitude":-0.809617},{"core_branch_id":59676,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Edlin \u0026 Jarvis Estate Agents LTD","email":"enquiries@edlinandjarvis.co.uk","sales_phone_number":"01636 555043","address":"36 Middle Gate,\r\nNewark,\r\nNG24 1AL","postcode":"NG24 1AL","website_url":"http:\/\/www.edlinandjarvis.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\/59676\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59676,"agent_company_id":6210,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000005471E316F3E9BFB9AB5791D1894A40","agent_brand_id":7028,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"36 Middle Gate, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Edlin \u0026 Jarvis Estate Agents LTD","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@edlinandjarvis.co.uk","has_email":true,"h_phone":"01636 555043","has_phone":true,"resolved_brand_color":"#b1fcff","boundary_listing_count":"67","property_count":"75","latitude":53.076708,"longitude":-0.810924},{"core_branch_id":59697,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Gascoines","email":"karenfenton@gascoines.com","sales_phone_number":"01636 813245","address":"1 Church Street,\r\nSouthwell,\r\nNG25 0HQ","postcode":"NG25 0HQ","website_url":"https:\/\/www.gascoines.co","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59697\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:03.000000Z","updated_at":"2026-01-20T20:00:41.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59697,"agent_company_id":4782,"branch_location":"Southwell","lettings_phone_number":"01636 813245","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000053AEF02E1771EEBF8BC3995FCD894A40","agent_brand_id":5536,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 Church Street, Southwell","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Gascoines","branch_name":"Southwell","lettings":true,"sales":true,"commercial":false,"h_email":"karenfenton@gascoines.com","has_email":true,"h_phone":"01636 813245","has_phone":true,"resolved_brand_color":"#193325","boundary_listing_count":"54","property_count":"71","latitude":53.07658,"longitude":-0.951305},{"core_branch_id":67613,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"William H. Brown","email":"newark@williamhbrown.co.uk","sales_phone_number":"01636 640473","address":"Newark,\r\n","postcode":null,"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\/67613\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:20.000000Z","updated_at":"2025-12-09T23:24:09.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":67613,"agent_company_id":54,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":null,"agent_brand_id":216,"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":"William H. Brown","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"newark@williamhbrown.co.uk","has_email":true,"h_phone":"01636 640473","has_phone":true,"resolved_brand_color":"#8dc3d9","boundary_listing_count":"50","property_count":"62","latitude":null,"longitude":null},{"core_branch_id":59671,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Chadwells Estate Agents","email":"sales@chadwells.co.uk","sales_phone_number":"01623 861861","address":"Forest Road,\r\nNew Ollerton,\r\nNewark,\r\nNG22 9QT","postcode":"NG22 9QT","website_url":"http:\/\/www.chadwells.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\/59671\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:54:03.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59671,"agent_company_id":129,"branch_location":"New Ollerton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003D9B559FAB2DF0BF0B9755D80C9A4A40","agent_brand_id":352,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Forest Road, New Ollerton, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Chadwells Estate Agents","branch_name":"New Ollerton","lettings":false,"sales":true,"commercial":false,"h_email":"sales@chadwells.co.uk","has_email":true,"h_phone":"01623 861861","has_phone":true,"resolved_brand_color":"#73050a","boundary_listing_count":"49","property_count":"50","latitude":53.203517,"longitude":-1.01115},{"core_branch_id":59675,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Alasdair Morrison \u0026 Mundys","email":"residential@mundys.net","sales_phone_number":"01636 700888","address":"46 Middle Gate,\r\nNewark,\r\nNG24 1AL","postcode":"NG24 1AL","website_url":"http:\/\/www.amorrison.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\/59675\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.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":59675,"agent_company_id":4780,"branch_location":"Newark","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000005471E316F3E9BFB9AB5791D1894A40","agent_brand_id":5533,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"46 Middle Gate, Newark","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alasdair Morrison \u0026 Mundys","branch_name":"Newark","lettings":false,"sales":true,"commercial":false,"h_email":"residential@mundys.net","has_email":true,"h_phone":"01636 700888","has_phone":true,"resolved_brand_color":"#123053","boundary_listing_count":"46","property_count":"49","latitude":53.076708,"longitude":-0.810924},{"core_branch_id":59694,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Alasdair Morrison \u0026 Mundys","email":"southwell@amorrison.co.uk","sales_phone_number":"01636 813971","address":"22 King Street,\r\nSouthwell,\r\nNG25 0EN","postcode":"NG25 0EN","website_url":"https:\/\/amorrison-mundys.net\/about\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/59694\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59694,"agent_company_id":4780,"branch_location":"Southwell","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003A747ADE8D85EEBFA8565F5D158A4A40","agent_brand_id":5533,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"22 King Street, Southwell","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alasdair Morrison \u0026 Mundys","branch_name":"Southwell","lettings":false,"sales":true,"commercial":false,"h_email":"southwell@amorrison.co.uk","has_email":true,"h_phone":"01636 813971","has_phone":true,"resolved_brand_color":"#123053","boundary_listing_count":"43","property_count":"47","latitude":53.078777,"longitude":-0.953803},{"core_branch_id":57439,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Yopa","email":"aimee.boston@yopa.co.uk","sales_phone_number":"01923 381187","address":"Meridian House\r\nWheatfield Way\r\nHinckley\r\nLE10 1YG","postcode":"LE10 1YG","website_url":"https:\/\/www.yopa.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/57439\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:48.000000Z","updated_at":"2026-01-20T19:57:00.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":57439,"agent_company_id":8351,"branch_location":"Nationwide","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000029EB3713D305F6BFF52A323A20474A40","agent_brand_id":9221,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Meridian House, Wheatfield Way, Hinckley","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Yopa","branch_name":"Nationwide","lettings":false,"sales":true,"commercial":false,"h_email":"aimee.boston@yopa.co.uk","has_email":true,"h_phone":"01923 381187","has_phone":true,"resolved_brand_color":"#56c5cd","boundary_listing_count":"35","property_count":"7215","latitude":52.555671,"longitude":-1.376422},{"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":"24","property_count":"7987","latitude":51.512,"longitude":-0.218},{"core_branch_id":59693,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Richard Watkinson \u0026 Partners","email":"southwell@richardwatkinson.co.uk","sales_phone_number":"01636 816200","address":"20 King Street,\r\nSouthwell,\r\nNG25 0EH","postcode":"NG25 0EH","website_url":"http:\/\/www.richardwatkinson.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\/59693\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.000000Z","updated_at":"2026-01-20T19:55:52.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":59693,"agent_company_id":1479,"branch_location":"Southwell","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000723271AB2086EEBF4A07EBFF1C8A4A40","agent_brand_id":2039,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"20 King Street, Southwell","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Richard Watkinson \u0026 Partners","branch_name":"Southwell","lettings":false,"sales":true,"commercial":false,"h_email":"southwell@richardwatkinson.co.uk","has_email":true,"h_phone":"01636 816200","has_phone":true,"resolved_brand_color":"#8f2433","boundary_listing_count":"24","property_count":"26","latitude":53.07901,"longitude":-0.953873},{"core_branch_id":59669,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Jf Village \u0026 Country Homes","email":"attenborough@jfea.co.uk","sales_phone_number":"01623 392676","address":"64 Main Street\r\nFarnsfield\r\nNottingham\r\nNG22 8EF","postcode":"NG22 8EF","website_url":"https:\/\/www.jfea.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\/59669\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:02.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":59669,"agent_company_id":131,"branch_location":"Farnsfield","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BFBB95253A8BF0BFB0E600C11C8D4A40","agent_brand_id":354,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"64 Main Street, Farnsfield, Nottingham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Jf Village \u0026 Country Homes","branch_name":"Farnsfield","lettings":false,"sales":true,"commercial":false,"h_email":"attenborough@jfea.co.uk","has_email":true,"h_phone":"01623 392676","has_phone":true,"resolved_brand_color":"#fabb2c","boundary_listing_count":"21","property_count":"23","latitude":53.10244,"longitude":-1.033991}]; 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`; } } }