SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM24 8TQ' order by fulladdress
CM24 8TQ - 470,000
- Freehold End terrace house
CM24 8TQ - 765,000
- Freehold Detached house
CM24 8TQ - 818,000
- Freehold Detached house
CM24 8TQ - 837,000
- Freehold Detached house
CM24 8TQ - 786,000
- Freehold Detached house
CM24 8TQ - 795,000
- Freehold Detached house
CM24 8TQ - 525,000
- Freehold Detached house
CM24 8TQ - 523,000
- Freehold Detached house
CM24 8TQ - 772,000
- Freehold Detached house
CM24 8TQ - 776,000
- Freehold Detached house
CM24 8TQ - 516,000
- Freehold Detached house
CM24 8TQ - 791,000
- Freehold Detached house
CM24 8TQ - 457,000
- Freehold End terrace house
CM24 8TQ - 375,000
- Freehold Semi-detached house
CM24 8TQ - 367,000
- Leasehold Mid terrace house
CM24 8TQ - 376,000
- Freehold Semi-detached house
CM24 8TQ - 345,000
- Freehold Purpose built flat
CM24 8TQ - 527,000
- Freehold Detached house
CM24 8TQ - 495,000
- Freehold Detached house
CM24 8TQ - 369,000
- Freehold Semi-detached house
CM24 8TQ - 825,000
- Freehold Detached house
CM24 8TQ - 774,000
- Freehold Detached house
CM24 8TQ - 763,000
- Freehold Detached house
CM24 8TQ - 754,000
- Freehold Detached house
CM24 8TQ - 291,000
- Freehold End terrace house
CM24 8TQ - 783,000
- Freehold Detached house
CM24 8TQ - 568,000
- Freehold Detached house
CM24 8TQ - 515,000
- Freehold Semi-detached house
CM24 8TQ - 536,000
- Freehold Semi-detached house
CM24 8TQ - 508,000
- Freehold Detached house
CM24 8TQ - 544,000
- Freehold Semi-detached house
CM24 8TQ - 324,000
- Freehold Mid terrace house
CM24 8TQ - 828,000
- Freehold Detached house
CM24 8TQ - 287,000
- Freehold End terrace house
CM24 8TQ - 808,000
- Freehold Detached house
