Estate & Letting Agents in Pidley cum Fenton, Huntingdonshire

Find Estate Agents in Pidley cum Fenton, Huntingdonshire
8 results
Compare Best Local Agents
Harvey Robinson
Harvey Robinson

St Ives

Sales
1 active listing in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
77 total
9 White Hart Court, St. Ives, PE27 5EA
View Profile
Ellis Winters Estate Agents
Ellis Winters Estate Agents

St Ives

Sales
4 active listings in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
91 total
14 Market Hill, St Ives, Cambridgeshire, PE27 5AL
View Profile
Giggs & Mcgrath
Giggs & Mcgrath

St Ives

Sales
4 active listings in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
182 total
6A Abbey Retail Park Harrison Way St. Ives, Cambridgeshire PE27 4AE
View Profile
Lennon James Property
Lennon James Property

Abbots Ripton

Sales
3 active listings in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
100 total
Unit 2 Green Farm The Green Abbots Ripton Huntingdon PE28 2PF
View Profile
Thomas Morris
Thomas Morris

St. Ives

Sales
2 active listings in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
97 total
24-26 Crown Street, St. Ives, PE27 5AB
View Profile
Oliver James
Oliver James

Huntingdon

Lettings Sales
1 active listing in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
197 total
1 George Street, Huntingdon, PE29 3AD
View Profile
Strutt & Parker
Strutt & Parker

Stamford Covering East Midlands

Lettings Sales
1 active listing in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
16 total
5 South View Business Park, Tinwell Road, Stamford, PE9 2JL
View Profile
Wellingtonwise
Wellingtonwise

St Ives

Sales
1 active listing in Pidley cum Fenton, Huntingdonshire, Cambridgeshire, England
99 total
10 The Pavement, St. Ives, Cambridgeshire, PE27 5AD
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 = 'Pidley cum Fenton, Huntingdonshire'; 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":61048,"verification_status":"verified","verified_at":"2026-02-06T11:27:55.000000Z","verified_by":null,"verification_notes":null,"name":"Harvey Robinson","email":"stives@harveyrobinson.co.uk","sales_phone_number":"01480 454040","address":"9 White Hart Court,\r\nSt. Ives,\r\nPE27 5EA","postcode":"PE27 5EA","website_url":"https:\/\/www.harveyrobinson.co.uk\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":"Street.co.uk","logo":"https:\/\/cdn.home.co.uk\/agents\/61048\/logo.png","office_images":null,"claimed_at":"2026-02-06T11:26:24.000000Z","created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-02-06T11:27:55.000000Z","deleted_at":null,"claimed_user_id":"e3c0980f-7991-4752-8d0c-d86d0e9df639","profile_status":"live","assigned_user_id":null,"id":61048,"agent_company_id":3056,"branch_location":"St Ives","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000D6E429ABE97AB2BFC6A52A6D71294A40","agent_brand_id":3722,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"9 White Hart Court, St. Ives","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Harvey Robinson","branch_name":"St Ives","lettings":false,"sales":true,"commercial":false,"h_email":"stives@harveyrobinson.co.uk","has_email":true,"h_phone":"01480 454040","has_phone":true,"resolved_brand_color":"#414645","boundary_listing_count":"1","property_count":"77","latitude":52.323774,"longitude":-0.072188},{"core_branch_id":61045,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Ellis Winters Estate Agents","email":"infostives@elliswinters.co.uk","sales_phone_number":"01480 388888","address":"14 \r\nMarket Hill, \r\nSt Ives, Cambridgeshire, PE27 5AL","postcode":"PE27 5AL","website_url":"https:\/\/www.elliswinters.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\/61045\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-01-20T19:54:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61045,"agent_company_id":3394,"branch_location":"St Ives","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000164F3DD2E0B6B2BF4225AE635C294A40","agent_brand_id":4072,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"14, Market Hill, St Ives, Cambridgeshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Ellis Winters Estate Agents","branch_name":"St Ives","lettings":false,"sales":true,"commercial":false,"h_email":"infostives@elliswinters.co.uk","has_email":true,"h_phone":"01480 388888","has_phone":true,"resolved_brand_color":"#227eb4","boundary_listing_count":"4","property_count":"91","latitude":52.323132,"longitude":-0.073103},{"core_branch_id":61041,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Giggs \u0026 Mcgrath","email":"sales@giggsandmcgrath.com","sales_phone_number":"01480 276826","address":"6A Abbey Retail Park\r\nHarrison Way\r\nSt. Ives, Cambridgeshire\r\nPE27 4AE","postcode":"PE27 4AE","website_url":"http:\/\/giggsandmcgrath.com","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/61041\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-01-20T19:57:15.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61041,"agent_company_id":7530,"branch_location":"St Ives","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000C7D79E5912A0AEBF5D3123BC3D2A4A40","agent_brand_id":8379,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"6A Abbey Retail Park, Harrison Way, St. Ives, Cambridgeshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Giggs \u0026 Mcgrath","branch_name":"St Ives","lettings":false,"sales":true,"commercial":false,"h_email":"sales@giggsandmcgrath.com","has_email":true,"h_phone":"01480 276826","has_phone":true,"resolved_brand_color":"#c1c1c2","boundary_listing_count":"4","property_count":"182","latitude":52.330009,"longitude":-0.059815},{"core_branch_id":61053,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Lennon James Property","email":"hello@lennonjamesproperty.co.uk","sales_phone_number":"01480 570047","address":"Unit 2 Green Farm\r\nThe Green\r\nAbbots Ripton\r\nHuntingdon\r\nPE28 2PF","postcode":"PE28 2PF","website_url":"https:\/\/www.lennonjamesproperty.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\/61053\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-01-20T20:01:05.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61053,"agent_company_id":7531,"branch_location":"Abbots Ripton","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000E6797077D66EC7BF000341800C314A40","agent_brand_id":8380,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"Unit 2 Green Farm, The Green, Abbots Ripton, Huntingdon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Lennon James Property","branch_name":"Abbots Ripton","lettings":false,"sales":true,"commercial":false,"h_email":"hello@lennonjamesproperty.co.uk","has_email":true,"h_phone":"01480 570047","has_phone":true,"resolved_brand_color":"#efe1c0","boundary_listing_count":"3","property_count":"100","latitude":52.383194,"longitude":-0.18307},{"core_branch_id":61042,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Thomas Morris","email":"enquiries@tm-stives.co.uk","sales_phone_number":"01480 468066","address":"24-26 Crown Street,\r\nSt. Ives,\r\nPE27 5AB","postcode":"PE27 5AB","website_url":"http:\/\/www.thomasmerrifield.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\/61042\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-01-20T19:54:18.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61042,"agent_company_id":274,"branch_location":"St. Ives","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000003F575BB1BFECB2BF103FFF3D78294A40","agent_brand_id":567,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"24-26 Crown Street, St. Ives","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Thomas Morris","branch_name":"St. Ives","lettings":false,"sales":true,"commercial":false,"h_email":"enquiries@tm-stives.co.uk","has_email":true,"h_phone":"01480 468066","has_phone":true,"resolved_brand_color":"#ce2b52","boundary_listing_count":"2","property_count":"97","latitude":52.323982,"longitude":-0.073925},{"core_branch_id":61061,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Oliver James","email":"enquiries@ojproperty.co.uk","sales_phone_number":"01480 458762","address":"1 George Street,\r\nHuntingdon,\r\nPE29 3AD","postcode":"PE29 3AD","website_url":"http:\/\/www.ojproperty.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\/61061\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:46.000000Z","updated_at":"2026-01-20T19:59:03.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61061,"agent_company_id":3057,"branch_location":"Huntingdon","lettings_phone_number":"01480 458762","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000CEA623809BC5C7BFB0C56E9F552A4A40","agent_brand_id":3723,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"1 George Street, Huntingdon","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Oliver James","branch_name":"Huntingdon","lettings":true,"sales":true,"commercial":false,"h_email":"enquiries@ojproperty.co.uk","has_email":true,"h_phone":"01480 458762","has_phone":true,"resolved_brand_color":"#134279","boundary_listing_count":"1","property_count":"197","latitude":52.330738,"longitude":-0.185718},{"core_branch_id":61166,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Strutt \u0026 Parker","email":"simon.proctor@struttandparker.co.uk","sales_phone_number":"01780 437359","address":"5 South View Business Park, \r\nTinwell Road, \r\nStamford, \r\nPE9 2JL","postcode":"PE9 2JL","website_url":"http:\/\/www.struttandparker.com\/","description":null,"listings_feed_url":null,"feed_format":null,"last_feed_sync":null,"crm_provider":null,"logo":"https:\/\/cdn.home.co.uk\/agents\/61166\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:49.000000Z","updated_at":"2026-01-20T19:58:12.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61166,"agent_company_id":257,"branch_location":"Stamford Covering East Midlands","lettings_phone_number":"01858 898366","is_sales":true,"is_lettings":true,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E6100000180AD80E46ECDFBF8A7615527E524A40","agent_brand_id":547,"offers_sales":true,"offers_lettings":true,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"5 South View Business Park, Tinwell Road, Stamford","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Strutt \u0026 Parker","branch_name":"Stamford Covering East Midlands","lettings":true,"sales":true,"commercial":false,"h_email":"simon.proctor@struttandparker.co.uk","has_email":true,"h_phone":"01780 437359","has_phone":true,"resolved_brand_color":"#cb1144","boundary_listing_count":"1","property_count":"16","latitude":52.64448,"longitude":-0.498796},{"core_branch_id":61044,"verification_status":"pending","verified_at":null,"verified_by":null,"verification_notes":null,"name":"Wellingtonwise","email":"sales.stives@wellingtonwise.co.uk","sales_phone_number":"01480 498400","address":"10 The Pavement,\r\nSt. Ives,\r\nCambridgeshire,\r\nPE27 5AD","postcode":"PE27 5AD","website_url":"https:\/\/www.wellingtonwise.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\/61044\/logo.png","office_images":null,"claimed_at":null,"created_at":"2025-12-09T17:19:45.000000Z","updated_at":"2026-01-20T19:57:15.000000Z","deleted_at":null,"claimed_user_id":null,"profile_status":"on_hold","assigned_user_id":null,"id":61044,"agent_company_id":275,"branch_location":"St Ives","lettings_phone_number":null,"is_sales":true,"is_lettings":false,"is_commercial":false,"is_hm_agent":false,"geopoint":"0101000020E61000004FE78A5242B0B2BFAB5CA8FC6B294A40","agent_brand_id":569,"offers_sales":true,"offers_lettings":false,"claimed_assigned_user_id":null,"brand_color":null,"logo_rect":null,"address_lines":"10 The Pavement, St. Ives, Cambridgeshire","has_home_listings":false,"external_crm_branch_id":null,"agent_name":"Wellingtonwise","branch_name":"St Ives","lettings":false,"sales":true,"commercial":false,"h_email":"sales.stives@wellingtonwise.co.uk","has_email":true,"h_phone":"01480 498400","has_phone":true,"resolved_brand_color":"#c0d050","boundary_listing_count":"1","property_count":"99","latitude":52.323608,"longitude":-0.073002}]; 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`; } } }