Estate & Letting Agents in Staverton, Tewkesbury

Find Estate Agents in Staverton, Tewkesbury
5 results
Cook Residential
Cook Residential

Cheltenham

Sales
1 active listing in Staverton, Tewkesbury, Gloucestershire, England
129 total
4 Tebbit Mews Winchcombe Street Cheltenham GL52 2NF
View Featured Profile
The Property Centre

Churchdown

Sales
6 active listings in Staverton, Tewkesbury, Gloucestershire, England
97 total
21 St. Johns Avenue, Churchdown, Gloucester, GL3 2DG
View Profile
Steve Gooch Estate Agents
2 active listings in Staverton, Tewkesbury, Gloucestershire, England
82 total
27 Windsor Drive, Tuffley, Gloucester, GL4 0QJ
View Profile
Frowens Estate Agents
1 active listing in Staverton, Tewkesbury, Gloucestershire, England
35 total
50 London Road Stroud GL5 2AD
View Profile
Knight Frank

Cheltenham

Sales
1 active listing in Staverton, Tewkesbury, Gloucestershire, England
109 total
123 Promenade, Cheltenham, GL50 1NW
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 = 'Staverton, Tewkesbury'; 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":55563,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Cook Residential","email":"enquiries@cookresidential.co.uk","sales_phone_number":"01242 500259","address":"4 \r\n Tebbit Mews\r\nWinchcombe Street\r\nCheltenham\r\nGL52 2NF ","postcode":"GL52 2NF","website_url":"http:\/\/www.cookresidential.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\/55563\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:47.000000Z","updated_at":"2026-01-20T20:01:49.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55563,"agent_company_id":1449,"branch_location":"Cheltenham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":true,"geopoint":"0101000020E61000004D13B69F8C9100C04ACFF41263F34940","agent_brand_id":2007,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"4, Tebbit Mews, Winchcombe Street, Cheltenham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Cook Residential","branch_name":"Cheltenham","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@cookresidential.co.uk","has_email":true,"h_phone":"01242 500259","has_phone":true,"resolved_brand_color":"#4b0c43","boundary_listing_count":"1","property_count":"129","latitude":51.901461,"longitude":-2.071069},{"core_branch_id":55498,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"The Property Centre","email":"churchdown@thepropertycentres.co.uk","sales_phone_number":"01452 545554","address":"21 St. Johns Avenue,\r\nChurchdown,\r\nGloucester,\r\nGL3 2DG","postcode":"GL3 2DG","website_url":"http:\/\/www.thepropertycentres.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\/55498\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:44.000000Z","updated_at":"2026-01-20T19:53:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55498,"agent_company_id":1110,"branch_location":"Churchdown","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000005DBF60376C7B01C01C78B5DC99F14940","agent_brand_id":1642,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"21 St. Johns Avenue, Churchdown, Gloucester","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"The Property Centre","branch_name":"Churchdown","lettings":false,"sales":true,"commercial":false,"h_email":"churchdown@thepropertycentres.co.uk","has_email":true,"h_phone":"01452 545554","has_phone":true,"resolved_brand_color":"#23418c","boundary_listing_count":"6","property_count":"97","latitude":51.887508,"longitude":-2.185265},{"core_branch_id":55506,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Steve Gooch Estate Agents","email":"gloucester@stevegooch.co.uk","sales_phone_number":"01452 505566","address":"27 Windsor Drive,\r\nTuffley,\r\nGloucester,\r\nGL4 0QJ","postcode":"GL4 0QJ","website_url":"http:\/\/www.stevegooch.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\/55506\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:45.000000Z","updated_at":"2026-01-20T19:59:31.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55506,"agent_company_id":194,"branch_location":"Gloucester","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000059315C1D001102C00E677E3507EA4940","agent_brand_id":470,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"27 Windsor Drive, Tuffley, Gloucester","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Steve Gooch Estate Agents","branch_name":"Gloucester","lettings":false,"sales":true,"commercial":false,"h_email":"gloucester@stevegooch.co.uk","has_email":true,"h_phone":"01452 505566","has_phone":true,"resolved_brand_color":"#053778","boundary_listing_count":"2","property_count":"82","latitude":51.828345,"longitude":-2.258301},{"core_branch_id":55513,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Frowens Estate Agents","email":"info@frowens.co.uk","sales_phone_number":"01453 762501","address":"50 London Road\r\nStroud\r\nGL5 2AD ","postcode":"GL5 2AD","website_url":"https:\/\/www.frowens.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\/55513\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:45.000000Z","updated_at":"2026-01-20T19:53:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55513,"agent_company_id":2531,"branch_location":"Stroud","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E610000024456458C5BB01C0770FD07D39DF4940","agent_brand_id":3165,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"50 London Road, Stroud","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Frowens Estate Agents","branch_name":"Stroud","lettings":false,"sales":true,"commercial":false,"h_email":"info@frowens.co.uk","has_email":true,"h_phone":"01453 762501","has_phone":true,"resolved_brand_color":"#611f7f","boundary_listing_count":"1","property_count":"35","latitude":51.743942,"longitude":-2.216685},{"core_branch_id":55537,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Knight Frank","email":"tom.banwell@knightfrank.com","sales_phone_number":"01242 246959","address":"123 Promenade,\r\nCheltenham,\r\nGL50 1NW","postcode":"GL50 1NW","website_url":"https:\/\/www.knightfrank.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\/55537\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:16:46.000000Z","updated_at":"2026-01-20T20:01:06.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":55537,"agent_company_id":146,"branch_location":"Cheltenham","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000795C548B88A200C004013274ECF24940","agent_brand_id":372,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"123 Promenade, Cheltenham","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Knight Frank","branch_name":"Cheltenham","lettings":false,"sales":true,"commercial":false,"h_email":"tom.banwell@knightfrank.com","has_email":true,"h_phone":"01242 246959","has_phone":true,"resolved_brand_color":"#d2113e","boundary_listing_count":"1","property_count":"109","latitude":51.897841,"longitude":-2.079362}]; 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`; } } }