Estate & Letting Agents in Hulcote and Salford, Central Bedfordshire

Find Estate Agents in Hulcote and Salford, Central Bedfordshire
4 results
Lion Prestige, Powered by Keller Williams
5 active listings in Hulcote and Salford, Central Bedfordshire, England
19 total
12a Market Place, Woburn, MK17 9PZ
Bidwells

Rural Agency

Sales
1 active listing in Hulcote and Salford, Central Bedfordshire, England
30 total
Bidwell House, Trumpington Road, Cambridge, CB2 9LD
Lion Estates, Powered by Keller Williams
1 active listing in Hulcote and Salford, Central Bedfordshire, England
121 total
314 Midsummer Boulevard Milton Keynes MK9 2UB
View Profile
Michael Graham

Woburn Sands

Lettings Sales
1 active listing in Hulcote and Salford, Central Bedfordshire, England
39 total
2 Aspley Hill, Woburn Sands, Woburn Sands, MK17 8NJ
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 = 'Hulcote and Salford, Central Bedfordshire'; 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":58740,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lion Prestige, Powered by Keller Williams","email":null,"sales_phone_number":"01908 465800","address":"12a Market Place,\r\nWoburn,\r\nMK17 9PZ","postcode":"MK17 9PZ","website_url":"https:\/\/www.lionprestige.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\/58740\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:31.000000Z","updated_at":"2026-01-20T19:56:34.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58740,"agent_company_id":3836,"branch_location":"Woburn","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000850B790437D2E3BFFDBFEAC891FE4940","agent_brand_id":4539,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"12a Market Place, Woburn","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lion Prestige, Powered by Keller Williams","branch_name":"Woburn","lettings":false,"sales":true,"commercial":false,"h_email":null,"has_email":false,"h_phone":"01908 465800","has_phone":true,"resolved_brand_color":"#edd0b2","boundary_listing_count":"5","property_count":"19","latitude":51.988824,"longitude":-0.619411},{"core_branch_id":52004,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Bidwells","email":"info@bidwells.co.uk","sales_phone_number":null,"address":"Bidwell House, Trumpington Road, Cambridge, \r\nCB2 9LD","postcode":"CB2 9LD","website_url":"https:\/\/www.bidwells.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\/52004\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:14:49.000000Z","updated_at":"2026-01-20T19:59:10.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":52004,"agent_company_id":2762,"branch_location":"Rural Agency","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000009D2D20B41EBEBC3FD3A23EC91D164A40","agent_brand_id":3413,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Bidwell House, Trumpington Road, Cambridge","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Bidwells","branch_name":"Rural Agency","lettings":false,"sales":true,"commercial":false,"h_email":"info@bidwells.co.uk","has_email":true,"h_phone":null,"has_phone":false,"resolved_brand_color":"#14245a","boundary_listing_count":"1","property_count":"30","latitude":52.172784,"longitude":0.112276},{"core_branch_id":58881,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lion Estates, Powered by Keller Williams","email":"dominic@lionestates.co.uk","sales_phone_number":"01908 465700","address":"314\r\nMidsummer Boulevard\r\nMilton Keynes\r\nMK9 2UB","postcode":"MK9 2UB","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\/58881\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:36.000000Z","updated_at":"2026-01-20T19:53:54.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58881,"agent_company_id":3836,"branch_location":"Milton Keynes","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000719010E50B5AE8BF8CD651D504054A40","agent_brand_id":4538,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"314, Midsummer Boulevard, Milton Keynes","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lion Estates, Powered by Keller Williams","branch_name":"Milton Keynes","lettings":false,"sales":true,"commercial":false,"h_email":"dominic@lionestates.co.uk","has_email":true,"h_phone":"01908 465700","has_phone":true,"resolved_brand_color":"#d0d0d0","boundary_listing_count":"1","property_count":"121","latitude":52.03921,"longitude":-0.760992},{"core_branch_id":58735,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Michael Graham","email":"salesws@michaelgraham.co.uk","sales_phone_number":"01908 586400","address":"2 Aspley Hill,\r\nWoburn Sands,\r\nWoburn Sands, MK17 8NJ","postcode":"MK17 8NJ","website_url":"http:\/\/www.michaelgraham.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\/58735\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:18:31.000000Z","updated_at":"2026-01-20T19:57:37.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":58735,"agent_company_id":504,"branch_location":"Woburn Sands","lettings_phone_number":"01908 586400","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C7D79E5912A0E4BFAB22DC6454014A40","agent_brand_id":902,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"2 Aspley Hill, Woburn Sands, Woburn Sands","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Michael Graham","branch_name":"Woburn Sands","lettings":true,"sales":true,"commercial":false,"h_email":"salesws@michaelgraham.co.uk","has_email":true,"h_phone":"01908 586400","has_phone":true,"resolved_brand_color":"#76b5be","boundary_listing_count":"1","property_count":"39","latitude":52.010388,"longitude":-0.64454}]; 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`; } } }