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 9GE' order by fulladdress
CM2 9GE - 375,000
- Freehold Flat/Maisonette
CM2 9GE - 358,000
- Leasehold Flat/Maisonette
CM2 9GE - 458,000
- Leasehold Flat/Maisonette
CM2 9GE - 443,000
- Leasehold Flat/Maisonette
CM2 9GE - 474,000
- Leasehold Flat/Maisonette
CM2 9GE - 455,000
- Leasehold Flat/Maisonette
CM2 9GE - 372,000
- Leasehold Flat/Maisonette
CM2 9GE - 388,000
- Leasehold Flat/Maisonette
CM2 9GE - 486,000
- Leasehold Flat/Maisonette
CM2 9GE - 486,000
- Leasehold Flat/Maisonette
CM2 9GE - 459,000
- Leasehold Flat/Maisonette
CM2 9GE - 479,000
- Leasehold Flat/Maisonette
CM2 9GE - 500,000
- Leasehold Flat/Maisonette
CM2 9GE - 489,000
- Leasehold Flat/Maisonette
CM2 9GE - 496,000
- Leasehold Flat/Maisonette
CM2 9GE - 500,000
- Leasehold Flat/Maisonette
CM2 9GE - 497,000
- Leasehold Flat/Maisonette
CM2 9GE - 479,000
- Leasehold Flat/Maisonette
CM2 9GE - 359,000
- Leasehold Flat/Maisonette
CM2 9GE - 376,000
- Leasehold Flat/Maisonette
CM2 9GE - 347,000
- Leasehold Flat/Maisonette
CM2 9GE - 478,000
- Leasehold Flat/Maisonette
CM2 9GE - 427,000
- Leasehold Flat/Maisonette
CM2 9GE - 473,000
- Leasehold Flat/Maisonette
CM2 9GE - 347,000
- Leasehold Flat/Maisonette
CM2 9GE - 374,000
- Leasehold Flat/Maisonette
CM2 9GE - 371,000
- Leasehold Flat/Maisonette
CM2 9GE - 501,000
- Leasehold Flat/Maisonette
CM2 9GE - 487,000
- Leasehold Flat/Maisonette
CM2 9GE - 469,000
- Leasehold Flat/Maisonette
CM2 9GE - 508,000
- Leasehold Flat/Maisonette
CM2 9GE - 474,000
- Leasehold Flat/Maisonette
CM2 9GE - 503,000
- Leasehold Flat/Maisonette
CM2 9GE - 492,000
- Leasehold Flat/Maisonette
CM2 9GE - 478,000
- Leasehold Flat/Maisonette
CM2 9GE - 505,000
- Leasehold Flat/Maisonette
CM2 9GE - 352,000
- Leasehold Flat/Maisonette
CM2 9GE - 326,000
- Leasehold Flat/Maisonette
CM2 9GE - 375,000
- Leasehold Flat/Maisonette
CM2 9GE - 473,000
- Leasehold Flat/Maisonette
CM2 9GE - 478,000
- Leasehold Flat/Maisonette
CM2 9GE - 469,000
- Leasehold Flat/Maisonette
CM2 9GE - 490,000
- Leasehold Flat/Maisonette
CM2 9GE - 490,000
- Leasehold Flat/Maisonette
CM2 9GE - 365,000
- Leasehold Flat/Maisonette
CM2 9GE - 476,000
- Leasehold Flat/Maisonette
CM2 9GE - 489,000
- Leasehold Flat/Maisonette
CM2 9GE - 499,000
- Leasehold Flat/Maisonette
CM2 9GE - 497,000
- Leasehold Flat/Maisonette
CM2 9GE - 503,000
- Leasehold Flat/Maisonette
CM2 9GE - 378,000
- Leasehold Flat/Maisonette
CM2 9GE - 380,000
- Leasehold Flat/Maisonette
CM2 9GE - 466,000
- Leasehold Flat/Maisonette
CM2 9GE - 491,000
- Leasehold Flat/Maisonette
CM2 9GE - 487,000
- Leasehold Flat/Maisonette
CM2 9GE - 311,000
- Leasehold Flat/Maisonette
CM2 9GE - 371,000
- Leasehold Flat/Maisonette