Estate & Letting Agents in Yarwell, North Northamptonshire

Find Estate Agents in Yarwell, North Northamptonshire
8 results
Young Residential
Young Residential

St Neots

Sales
1 active listing in Yarwell, North Northamptonshire, England
30 total
View Featured Profile
Ewemove

Covering Scotland

Lettings Sales
5 active listings in Yarwell, North Northamptonshire, England
1,817 total
Cavendish House Littlewood Court West 26 Industrial Estate Cleckheaton BD19 4TE
View Profile
Newton Fallowell

Stamford

Lettings Sales
3 active listings in Yarwell, North Northamptonshire, England
120 total
4 Ironmonger Street, Stamford, PE9 1PL
View Profile
Sharman Quinney

Oundle

Sales
3 active listings in Yarwell, North Northamptonshire, England
53 total
The Old Town Hall, Market Place, Oundle, PE8 4BQ
View Profile
City & County (Uk) LTD

Peterborough

Lettings Sales
2 active listings in Yarwell, North Northamptonshire, England
197 total
6 Cowgate Peterborough PE1 1NA
View Profile
Firmin & Co

Orton Waterville

Sales
1 active listing in Yarwell, North Northamptonshire, England
104 total
48b Church Drive, Orton, Waterville, Peterborough, PE2 5HE
View Profile
King West

Stamford

Sales
1 active listing in Yarwell, North Northamptonshire, England
21 total
St. Marys Street, Stamford, PE9 2DE
View Profile
Your Move Nolan Throw

Oundle

Lettings
1 active listing in Yarwell, North Northamptonshire, England
12 total
12 Market Place, Oundle, PE8 4BQ
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 = 'Yarwell, North Northamptonshire'; 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":67635,"verification_status":"verified","verified_at":"2025-12-19T13:08:59.000000Z","verified_by":null,"verification_notes":null,"name":"Young Residential","email":null,"sales_phone_number":"01480 582007","address":"St. Neots\r\n","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\/67635\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:23:21.000000Z","updated_at":"2025-12-19T13:08:59.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"live","assigned_user_id":null,"id":67635,"agent_company_id":6622,"branch_location":"St Neots","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000009EEFA7C64B37D1BFCCEEC9C3421D4A40","agent_brand_id":7451,"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":"Young Residential","branch_name":"St Neots","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01480 582007","has_phone":true,"resolved_brand_color":"#54bfff","boundary_listing_count":"1","property_count":"30","latitude":52.2286,"longitude":-0.269},{"core_branch_id":50830,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ewemove","email":"katy.lamsin@ewemove.com","sales_phone_number":"01274 888790","address":"Cavendish House \r\nLittlewood Court\r\nWest 26 Industrial Estate\r\nCleckheaton\r\nBD19 4TE ","postcode":"BD19 4TE","website_url":"https:\/\/www.ewemove.com\/estate-agents\/greenford\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"SME Professional","logo":"https:\/\/cdn.home.co.uk\/agents\/50830\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:14:11.000000Z","updated_at":"2026-01-20T20:01:26.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"on_hold","assigned_user_id":null,"id":50830,"agent_company_id":44,"branch_location":"Covering Scotland","lettings_phone_number":"01274 888790","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000001C7E37DDB283FBBF3ACFD8976CDE4A40","agent_brand_id":74,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Cavendish House, Littlewood Court, West 26 Industrial Estate, Cleckheaton","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ewemove","branch_name":"Covering Scotland","lettings":true,"sales":true,"commercial":false,"h_email":"katy.lamsin@ewemove.com","has_email":true,"h_phone":"01274 888790","has_phone":true,"resolved_brand_color":"#9ebe3d","boundary_listing_count":"5","property_count":"1817","latitude":53.737689,"longitude":-1.719653},{"core_branch_id":61159,"verification_status":"verified","verified_at":"2025-12-22T15:24:50.000000Z","verified_by":null,"verification_notes":null,"name":"Newton Fallowell","email":"stamford@newtonfallowell.co.uk","sales_phone_number":"01780 754530","address":"4 Ironmonger Street,\r\nStamford,\r\nPE9 1PL","postcode":"PE9 1PL","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\/61159\/logo.png","office_images":null,"claimed_at":"2025-12-22T15:24:09.000000Z","created_at":"2025-12-09T17:19:49.000000Z","updated_at":"2026-01-20T19:58:12.000000Z","deleted_at":null,"claimed_user_id":"cb096143-431a-4200-ba92-f3ac46037fb3","profile_status":"live","assigned_user_id":null,"id":61159,"agent_company_id":44,"branch_location":"Stamford","lettings_phone_number":"01780 754530","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000004FE5B4A7E49CDEBF5000C5C892534A40","agent_brand_id":84,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4 Ironmonger Street, Stamford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Newton Fallowell","branch_name":"Stamford","lettings":true,"sales":true,"commercial":false,"h_email":"stamford@newtonfallowell.co.uk","has_email":true,"h_phone":"01780 754530","has_phone":true,"resolved_brand_color":"#ff5e21","boundary_listing_count":"3","property_count":"120","latitude":52.652917,"longitude":-0.478326},{"core_branch_id":61147,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Sharman Quinney","email":"oundle@sharmanquinney.co.uk","sales_phone_number":"01832 274567","address":"The Old Town Hall, \r\nMarket Place,\r\nOundle,\r\nPE8 4BQ ","postcode":"PE8 4BQ","website_url":"http:\/\/www.sharmanquinney.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\/61147\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:49.000000Z","updated_at":"2026-01-20T19:58:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61147,"agent_company_id":695,"branch_location":"Oundle","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000FBA84436FF1DDBF4C8E3BA5833D4A40","agent_brand_id":1176,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"The Old Town Hall, Market Place, Oundle","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Sharman Quinney","branch_name":"Oundle","lettings":false,"sales":true,"commercial":false,"h_email":"oundle@sharmanquinney.co.uk","has_email":true,"h_phone":"01832 274567","has_phone":true,"resolved_brand_color":"#263345","boundary_listing_count":"3","property_count":"53","latitude":52.48058,"longitude":-0.467861},{"core_branch_id":60918,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"City \u0026 County (Uk) LTD","email":"info@cityandcounty.net","sales_phone_number":"01733 563965","address":"6 \r\nCowgate\r\nPeterborough\r\nPE1 1NA ","postcode":"PE1 1NA","website_url":"https:\/\/www.bairstoweves.co.uk\/branch\/estate-agents\/peterborough","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/60918\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:41.000000Z","updated_at":"2026-01-20T19:57:13.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":60918,"agent_company_id":683,"branch_location":"Peterborough","lettings_phone_number":"01733 561161","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C2120F289B72CFBF2C4833164D494A40","agent_brand_id":1160,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"6, Cowgate, Peterborough","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"City \u0026 County (Uk) LTD","branch_name":"Peterborough","lettings":true,"sales":true,"commercial":false,"h_email":"info@cityandcounty.net","has_email":true,"h_phone":"01733 563965","has_phone":true,"resolved_brand_color":"#f06937","boundary_listing_count":"2","property_count":"197","latitude":52.572665,"longitude":-0.245685},{"core_branch_id":61003,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Firmin \u0026 Co","email":"orton@firminandco.co.uk","sales_phone_number":"01733 852257","address":"48b Church Drive,\r\nOrton, Waterville,\r\nPeterborough,\r\nPE2 5HE","postcode":"PE2 5HE","website_url":"https:\/\/www.firminandco.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\/61003\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:44.000000Z","updated_at":"2026-01-20T19:59:02.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61003,"agent_company_id":685,"branch_location":"Orton Waterville","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E1D05B3CBCE7D2BF75CDE49B6D464A40","agent_brand_id":1162,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"48b Church Drive, Orton, Waterville, Peterborough","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Firmin \u0026 Co","branch_name":"Orton Waterville","lettings":false,"sales":true,"commercial":false,"h_email":"orton@firminandco.co.uk","has_email":true,"h_phone":"01733 852257","has_phone":true,"resolved_brand_color":"#4eb2e3","boundary_listing_count":"1","property_count":"104","latitude":52.55022,"longitude":-0.295394},{"core_branch_id":61162,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"King West","email":"pmoore@kingwest.co.uk","sales_phone_number":"01780 484520","address":"St. Marys Street,\r\nStamford,\r\nPE9 2DE","postcode":"PE9 2DE","website_url":"http:\/\/www.kingwest.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\/61162\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:49.000000Z","updated_at":"2026-01-20T19:57:16.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61162,"agent_company_id":322,"branch_location":"Stamford","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C0E8F2E670ADDEBF14268C6665534A40","agent_brand_id":644,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"St. Marys Street, Stamford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"King West","branch_name":"Stamford","lettings":false,"sales":true,"commercial":false,"h_email":"pmoore@kingwest.co.uk","has_email":true,"h_phone":"01780 484520","has_phone":true,"resolved_brand_color":"#194137","boundary_listing_count":"1","property_count":"21","latitude":52.651532,"longitude":-0.479336},{"core_branch_id":61149,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Your Move Nolan Throw","email":null,"sales_phone_number":null,"address":"12 Market Place,\r\nOundle,\r\nPE8 4BQ","postcode":"PE8 4BQ","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\/61149\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:49.000000Z","updated_at":"2026-01-20T19:56:25.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61149,"agent_company_id":47,"branch_location":"Oundle","lettings_phone_number":null,"is_sales":false,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000FBA84436FF1DDBF4C8E3BA5833D4A40","agent_brand_id":130,"offers_sales":false,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12 Market Place, Oundle","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Your Move Nolan Throw","branch_name":"Oundle","lettings":true,"sales":false,"commercial":false,"h_email":null,"has_email":false,"h_phone":null,"has_phone":false,"resolved_brand_color":"#60aa2e","boundary_listing_count":"1","property_count":"12","latitude":52.48058,"longitude":-0.467861}]; 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`; } } }