Estate & Letting Agents in Michelmersh and Timsbury, Test Valley

Find Estate Agents in Michelmersh and Timsbury, Test Valley
5 results
Henshaw Fox

Romsey

Sales
9 active listings in Michelmersh and Timsbury, Test Valley, Hampshire, England
174 total
1 Middlebridge Street, Romsey, Hampshire, SO51 8HJ
View Profile
Charters

Romsey

Sales
2 active listings in Michelmersh and Timsbury, Test Valley, Hampshire, England
161 total
21A Market Place Romsey SO51 8NA
View Profile
Michael Rhodes

Romsey

Lettings Sales
2 active listings in Michelmersh and Timsbury, Test Valley, Hampshire, England
212 total
36 The Hundred, Romsey, SO51 8BX
View Profile
Pearsons

Romsey

Sales
2 active listings in Michelmersh and Timsbury, Test Valley, Hampshire, England
99 total
21 The Hundred, Romsey, SO51 8GB
View Profile
Woolley & Wallis

Romsey

Lettings Sales
2 active listings in Michelmersh and Timsbury, Test Valley, Hampshire, England
64 total
4-6 Bell Street, Romsey, SO51 8ZN
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 = 'Michelmersh and Timsbury, Test Valley'; 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":63700,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Henshaw Fox","email":"homes@henshawfox.co.uk","sales_phone_number":"01794 521339","address":"1 Middlebridge Street, \r\nRomsey, \r\nHampshire,\r\nSO51 8HJ","postcode":"SO51 8HJ","website_url":"https:\/\/www.henshawfox.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\/63700\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:12.000000Z","updated_at":"2026-01-20T20:00:43.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63700,"agent_company_id":2604,"branch_location":"Romsey","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000027FF8F9EF01F8BF1B2B31CF4A7E4940","agent_brand_id":3245,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 Middlebridge Street, Romsey, Hampshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Henshaw Fox","branch_name":"Romsey","lettings":false,"sales":true,"commercial":false,"h_email":"homes@henshawfox.co.uk","has_email":true,"h_phone":"01794 521339","has_phone":true,"resolved_brand_color":"#dcfcd1","boundary_listing_count":"9","property_count":"174","latitude":50.986658,"longitude":-1.500473},{"core_branch_id":63702,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Charters","email":"romsey@chartersestateagents.co.uk","sales_phone_number":"01794 511107","address":"21A Market Place\r\nRomsey\r\nSO51 8NA","postcode":"SO51 8NA","website_url":"https:\/\/www.chartersestateagents.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\/63702\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:12.000000Z","updated_at":"2026-01-20T19:54:45.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63702,"agent_company_id":496,"branch_location":"Romsey","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000011C64FE3DEFCF7BFCFC0C8CB9A7E4940","agent_brand_id":869,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21A Market Place, Romsey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Charters","branch_name":"Romsey","lettings":false,"sales":true,"commercial":false,"h_email":"romsey@chartersestateagents.co.uk","has_email":true,"h_phone":"01794 511107","has_phone":true,"resolved_brand_color":"#af9f52","boundary_listing_count":"2","property_count":"161","latitude":50.989099,"longitude":-1.499236},{"core_branch_id":63695,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Michael Rhodes","email":"sales@michaelrhodes.co.uk","sales_phone_number":null,"address":"36 The Hundred,\r\nRomsey,\r\nSO51 8BX","postcode":"SO51 8BX","website_url":"http:\/\/www.michaelrhodes.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\/63695\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:11.000000Z","updated_at":"2026-01-20T19:56:32.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63695,"agent_company_id":2605,"branch_location":"Romsey","lettings_phone_number":"01794 514455","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000B6494563EDEFF7BFCD3B4ED1917E4940","agent_brand_id":3246,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"36 The Hundred, Romsey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Michael Rhodes","branch_name":"Romsey","lettings":true,"sales":true,"commercial":false,"h_email":"sales@michaelrhodes.co.uk","has_email":true,"h_phone":"01794 514455","has_phone":true,"resolved_brand_color":"#000f41","boundary_listing_count":"2","property_count":"212","latitude":50.988825,"longitude":-1.496076},{"core_branch_id":63698,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Pearsons","email":"romsey@pearsons.com","sales_phone_number":"01794 514516","address":"21 The Hundred,\r\nRomsey,\r\nSO51 8GB","postcode":"SO51 8GB","website_url":"https:\/\/www.pearsons.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/63698\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:12.000000Z","updated_at":"2026-01-20T19:56:03.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63698,"agent_company_id":465,"branch_location":"Romsey","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000CD751A69A9FCF7BFA2EF6E65897E4940","agent_brand_id":832,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21 The Hundred, Romsey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Pearsons","branch_name":"Romsey","lettings":false,"sales":true,"commercial":false,"h_email":"romsey@pearsons.com","has_email":true,"h_phone":"01794 514516","has_phone":true,"resolved_brand_color":"#0c7251","boundary_listing_count":"2","property_count":"99","latitude":50.988568,"longitude":-1.499185},{"core_branch_id":63706,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Woolley \u0026 Wallis","email":"romsey@w-w.co.uk","sales_phone_number":"01794 512129","address":"4-6 Bell Street,\r\nRomsey,\r\nSO51 8ZN","postcode":"SO51 8ZN","website_url":"https:\/\/www.w-w.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\/63706\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:21:12.000000Z","updated_at":"2026-01-20T20:00:43.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":63706,"agent_company_id":815,"branch_location":"Romsey","lettings_phone_number":"01425 655900","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D5EB1681B1FEF7BF5CC823B8917E4940","agent_brand_id":1306,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4-6 Bell Street, Romsey","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Woolley \u0026 Wallis","branch_name":"Romsey","lettings":true,"sales":true,"commercial":false,"h_email":"romsey@w-w.co.uk","has_email":true,"h_phone":"01794 512129","has_phone":true,"resolved_brand_color":"#f2be40","boundary_listing_count":"2","property_count":"64","latitude":50.988822,"longitude":-1.499681}]; 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`; } } }