Estate & Letting Agents in North Stainley with Sleningford, North Yorkshire

Find Estate Agents in North Stainley with Sleningford, North Yorkshire
4 results
Compare Best Local Agents
Davis & Lund
Davis & Lund

Ripon

Sales
1 active listing in North Stainley with Sleningford, North Yorkshire, England
74 total
5A Kirkgate, Ripon, HG4 1PA
View Profile
Hunters
Hunters

Ripon

Sales
1 active listing in North Stainley with Sleningford, North Yorkshire, England
82 total
12 Queen Street Ripon HG4 1ED
View Profile
Solo Property Management
Solo Property Management

Ripon

Sales
1 active listing in North Stainley with Sleningford, North Yorkshire, England
37 total
13 Fishergate Ripon HG4 1EA
View Profile
Verity Frearson
Verity Frearson

Harrogate

Sales
1 active listing in North Stainley with Sleningford, North Yorkshire, England
437 total
Tudor House Albert Street, Harrogate, HG1 1JT
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 = 'North Stainley with Sleningford, 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":56099,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Davis \u0026 Lund","email":"sales@davislund.co.uk","sales_phone_number":"01765 602233","address":"5A Kirkgate,\r\nRipon,\r\nHG4 1PA","postcode":"HG4 1PA","website_url":"http:\/\/www.davislund.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\/56099\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:05.000000Z","updated_at":"2026-01-20T19:53:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56099,"agent_company_id":1812,"branch_location":"Ripon","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000008524B37A875BF8BFCC0BB08F4E114B40","agent_brand_id":2405,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5A Kirkgate, Ripon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Davis \u0026 Lund","branch_name":"Ripon","lettings":false,"sales":true,"commercial":false,"h_email":"sales@davislund.co.uk","has_email":true,"h_phone":"01765 602233","has_phone":true,"resolved_brand_color":"#01443c","boundary_listing_count":"1","property_count":"74","latitude":54.13521,"longitude":-1.522346},{"core_branch_id":56097,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Hunters","email":"ripon@hunters.com","sales_phone_number":"01765 530007","address":"12 \r\nQueen Street\r\nRipon\r\nHG4 1ED","postcode":"HG4 1ED","website_url":"https:\/\/www.hunters.com\/office\/ripon\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/56097\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:47.000000Z","updated_at":"2026-01-20T19:53:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56097,"agent_company_id":98,"branch_location":"Ripon","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000007E9065C1C45FF8BF42CD902A8A114B40","agent_brand_id":290,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12, Queen Street, Ripon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Hunters","branch_name":"Ripon","lettings":false,"sales":true,"commercial":false,"h_email":"ripon@hunters.com","has_email":true,"h_phone":"01765 530007","has_phone":true,"resolved_brand_color":"#193273","boundary_listing_count":"1","property_count":"82","latitude":54.137029,"longitude":-1.523381},{"core_branch_id":56095,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Solo Property Management","email":"steve.harris@solopm.com","sales_phone_number":"01765 608203","address":"13 Fishergate\r\nRipon\r\nHG4 1EA ","postcode":"HG4 1EA","website_url":"http:\/\/solopropertymanagement.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/56095\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:04.000000Z","updated_at":"2026-01-20T19:53:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56095,"agent_company_id":1817,"branch_location":"Ripon","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000088DA368C8260F8BFECA2E8818F114B40","agent_brand_id":2410,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"13 Fishergate, Ripon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Solo Property Management","branch_name":"Ripon","lettings":false,"sales":true,"commercial":false,"h_email":"steve.harris@solopm.com","has_email":true,"h_phone":"01765 608203","has_phone":true,"resolved_brand_color":"#a1cd69","boundary_listing_count":"1","property_count":"37","latitude":54.137192,"longitude":-1.523562},{"core_branch_id":56069,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Verity Frearson","email":"sales@verityfrearson.co.uk","sales_phone_number":"01423 562531","address":"Tudor House Albert Street,\r\nHarrogate,\r\nHG1 1JT","postcode":"HG1 1JT","website_url":"https:\/\/www.verityfrearson.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\/56069\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:17:04.000000Z","updated_at":"2026-01-20T19:53:24.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":56069,"agent_company_id":5099,"branch_location":"Harrogate","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000FD6CE4BA29A5F8BF026553AEF0FE4A40","agent_brand_id":5867,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Tudor House Albert Street, Harrogate","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Verity Frearson","branch_name":"Harrogate","lettings":false,"sales":true,"commercial":false,"h_email":"sales@verityfrearson.co.uk","has_email":true,"h_phone":"01423 562531","has_phone":true,"resolved_brand_color":"#101e30","boundary_listing_count":"1","property_count":"437","latitude":53.99172,"longitude":-1.540323}]; 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`; } } }