Estate & Letting Agents in Newsham, North Yorkshire

Find Estate Agents in Newsham, North Yorkshire
5 results
Compare Best Local Agents
Carver Residential
Carver Residential

Richmond

Sales
3 active listings in Newsham, North Yorkshire, England
40 total
41 Market Place, Richmond DL10 4QL
View Profile
George F.White
George F.White

Barnard Castle

Sales
2 active listings in Newsham, North Yorkshire, England
87 total
14c Redwell Court, Barnard Castle, County Durham DL12 8BN
View Profile
Alderson Estate Agents
Alderson Estate Agents

Richmond

Sales
1 active listing in Newsham, North Yorkshire, England
115 total
7 King Street, Richmond, North Yorkshire DL10 4HP
View Profile
British Homesellers
British Homesellers

National

Sales
1 active listing in Newsham, North Yorkshire, England
725 total
Third Floor St. Peters House, 45 Victoria Street, St. Albans, Hertfordshire, AL1 3HZ
View Profile
Irvings Property Limited
Irvings Property Limited

Richmond

Sales
1 active listing in Newsham, North Yorkshire, England
128 total
21 Market Place Richmond North Yorkshire DL10 4QG
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 = 'Newsham, North Yorkshire'; 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":53738,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Carver Residential","email":"richmond@carvergroup.co.uk","sales_phone_number":"01748 825317","address":"41 Market Place, Richmond DL10 4QL","postcode":"DL10 4QL","website_url":"https:\/\/www.nickcarver.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/53738\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:46.000000Z","updated_at":"2026-01-20T19:52:35.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53738,"agent_company_id":1074,"branch_location":"Richmond","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000042B456B439CEFBBFEAE923F087334B40","agent_brand_id":1602,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"41 Market Place, Richmond","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Carver Residential","branch_name":"Richmond","lettings":false,"sales":true,"commercial":false,"h_email":"richmond@carvergroup.co.uk","has_email":true,"h_phone":"01748 825317","has_phone":true,"resolved_brand_color":"#011d50","boundary_listing_count":"3","property_count":"40","latitude":54.402586,"longitude":-1.737848},{"core_branch_id":53739,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"George F.White","email":"barnardcastle@georgefwhite.co.uk","sales_phone_number":"03339 202220","address":"14c Redwell Court,\r\nBarnard Castle,\r\nCounty Durham\r\nDL12 8BN","postcode":"DL12 8BN","website_url":"http:\/\/www.georgefwhite.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\/53739\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:46.000000Z","updated_at":"2026-01-20T19:53:00.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53739,"agent_company_id":5926,"branch_location":"Barnard Castle","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000000A68226C78BAFEBF1E5036E50A474B40","agent_brand_id":6736,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"14c Redwell Court, Barnard Castle, County Durham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"George F.White","branch_name":"Barnard Castle","lettings":false,"sales":true,"commercial":false,"h_email":"barnardcastle@georgefwhite.co.uk","has_email":true,"h_phone":"03339 202220","has_phone":true,"resolved_brand_color":"#163d35","boundary_listing_count":"2","property_count":"87","latitude":54.55502,"longitude":-1.920525},{"core_branch_id":53735,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Alderson Estate Agents","email":"info@marcusalderson.co.uk","sales_phone_number":"01748 822711","address":"7 King Street,\r\nRichmond,\r\nNorth Yorkshire\r\nDL10 4HP","postcode":"DL10 4HP","website_url":"http:\/\/www.marcusalderson.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\/53735\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:46.000000Z","updated_at":"2026-01-20T19:52:59.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53735,"agent_company_id":6691,"branch_location":"Richmond","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000BFBB95253ACBFBBF0FD07D39B3334B40","agent_brand_id":7522,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"7 King Street, Richmond, North Yorkshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Alderson Estate Agents","branch_name":"Richmond","lettings":false,"sales":true,"commercial":false,"h_email":"info@marcusalderson.co.uk","has_email":true,"h_phone":"01748 822711","has_phone":true,"resolved_brand_color":"#435c4d","boundary_listing_count":"1","property_count":"115","latitude":54.403907,"longitude":-1.737116},{"core_branch_id":50047,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"British Homesellers","email":"enquries@britihshomesellers.co.uk","sales_phone_number":"01727 861580","address":"Third Floor St. Peters House,\r\n45 Victoria Street,\r\nSt. Albans,\r\nHertfordshire,\r\nAL1 3HZ","postcode":"AL1 3HZ","website_url":"http:\/\/www.britishhomesellers.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\/50047\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:13:45.000000Z","updated_at":"2026-01-20T19:56:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":50047,"agent_company_id":4241,"branch_location":"National","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000FBAC32535A7FD5BFD97C5C1B2AE04940","agent_brand_id":4970,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Third Floor St. Peters House, 45 Victoria Street, St. Albans, Hertfordshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"British Homesellers","branch_name":"National","lettings":false,"sales":true,"commercial":false,"h_email":"enquries@britihshomesellers.co.uk","has_email":true,"h_phone":"01727 861580","has_phone":true,"resolved_brand_color":"#afdfef","boundary_listing_count":"1","property_count":"725","latitude":51.751285,"longitude":-0.335898},{"core_branch_id":53737,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Irvings Property Limited","email":"info@irvingsproperty.co.uk","sales_phone_number":"01748 821700","address":"21\r\nMarket Place\r\nRichmond\r\nNorth Yorkshire\r\nDL10 4QG","postcode":"DL10 4QG","website_url":"https:\/\/irvingsproperty.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\/53737\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:15:46.000000Z","updated_at":"2026-01-20T19:52:59.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":53737,"agent_company_id":6693,"branch_location":"Richmond","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000002BDF3312A1D1FBBF429946938B334B40","agent_brand_id":7524,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21, Market Place, Richmond, North Yorkshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Irvings Property Limited","branch_name":"Richmond","lettings":false,"sales":true,"commercial":false,"h_email":"info@irvingsproperty.co.uk","has_email":true,"h_phone":"01748 821700","has_phone":true,"resolved_brand_color":"#e67428","boundary_listing_count":"1","property_count":"128","latitude":54.402697,"longitude":-1.738679}]; 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`; } } }