SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM2 9FY' order by fulladdress
CM2 9FY - 737,000
- Freehold Semi-detached house
CM2 9FY - 702,000
- Freehold Mid terrace house
CM2 9FY - 1,471,000
- Freehold Detached house
CM2 9FY - 673,000
- Freehold Mid terrace house
CM2 9FY - 1,561,000
- Freehold Detached house
CM2 9FY - 692,000
- Freehold Mid terrace house
CM2 9FY - 1,423,000
- Freehold Detached house
CM2 9FY - 700,000
- Freehold Mid terrace house
CM2 9FY - 1,452,000
- Freehold Detached house
CM2 9FY - 716,000
- Freehold Detached house
CM2 9FY - 1,519,000
- Freehold Detached house
CM2 9FY - 749,000
- Freehold Detached house
CM2 9FY - 208,000
- Leasehold Purpose built flat
CM2 9FY - 744,000
- Freehold Detached house
CM2 9FY - 249,000
- Leasehold Flat/Maisonette
CM2 9FY - 782,000
- Freehold Detached house
CM2 9FY - 784,000
- Freehold Detached house
CM2 9FY - 753,000
- Freehold Detached house
CM2 9FY - 808,000
- Freehold Detached house
CM2 9FY - 725,000
- Freehold Detached house
CM2 9FY - 169,000
- Leasehold Purpose built flat
CM2 9FY - 798,000
- Freehold Detached house
CM2 9FY - 131,000
- Leasehold Purpose built flat
CM2 9FY - 765,000
- Freehold Detached house
CM2 9FY - 119,000
- Leasehold Purpose built flat
CM2 9FY - 451,000
- Freehold Semi-detached house
CM2 9FY - 592,000
- Freehold Semi-detached house
CM2 9FY - 776,000
- Freehold Detached house
CM2 9FY - 782,000
- Freehold Semi-detached house
CM2 9FY - 429,000
- Freehold End terrace house
CM2 9FY - 494,000
- Freehold Mid terrace house
CM2 9FY - 175,000
- Leasehold Purpose built flat
CM2 9FY - 483,000
- Freehold Mid terrace house
CM2 9FY - 169,000
- Leasehold Purpose built flat
CM2 9FY - 424,000
- Freehold End terrace house
CM2 9FY - 681,000
- Freehold Semi-detached house
CM2 9FY - 230,000
- Leasehold Purpose built flat
CM2 9FY - 235,000
- Feudal Purpose built flat
CM2 9FY - 297,000
- Leasehold Purpose built flat
CM2 9FY - 688,000
- Freehold Mid terrace house
CM2 9FY - 545,000
- Freehold Semi-detached house
CM2 9FY - 682,000
- Freehold Mid terrace house
CM2 9FY - 832,000
- Freehold Detached house
