Estate & Letting Agents in Newsham, North Yorkshire

Find Estate Agents in Newsham, North Yorkshire
5 results
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

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
1 active listing in Newsham, North Yorkshire, England
115 total
7 King Street, Richmond, North Yorkshire DL10 4HP
View Profile
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
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`; } } }