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 9FW' order by fulladdress
CM2 9FW - 258,000
- Leasehold Converted flat
CM2 9FW - 537,000
- Freehold Mid terrace house
CM2 9FW - 277,000
- Leasehold Flat/Maisonette
CM2 9FW - 523,000
- Freehold Mid terrace house
CM2 9FW - 308,000
- Leasehold Purpose built flat
CM2 9FW - 524,000
- Freehold Mid terrace house
CM2 9FW - 307,000
- Feudal Converted flat
CM2 9FW - 531,000
- Freehold Mid terrace house
CM2 9FW - 277,000
- Leasehold Purpose built flat
CM2 9FW - 526,000
- Freehold Mid terrace house
CM2 9FW - 250,000
- Leasehold Flat/Maisonette
CM2 9FW - 674,000
- Freehold End terrace house
CM2 9FW - 454,000
- Freehold Mid terrace house
CM2 9FW - 471,000
- Freehold End terrace property
CM2 9FW - 519,000
- Freehold Mid terrace house
CM2 9FW - 422,000
- Freehold Mid terrace house
CM2 9FW - 248,000
- Leasehold Flat/Maisonette
CM2 9FW - 429,000
- Freehold Mid terrace house
CM2 9FW - 288,000
- Leasehold Flat/Maisonette
CM2 9FW - 438,000
- Freehold Terrace property
CM2 9FW - 236,000
- Leasehold Purpose built flat
CM2 9FW - 430,000
- Freehold Mid terrace house
CM2 9FW - 280,000
- Leasehold Flat/Maisonette
CM2 9FW - 290,000
- Leasehold Flat/Maisonette
CM2 9FW - 435,000
- Freehold End terrace house
CM2 9FW - 287,000
- Leasehold Purpose built flat
CM2 9FW - 518,000
- Freehold Semi-detached house
CM2 9FW - 238,000
- Leasehold Flat/Maisonette
CM2 9FW - 486,000
- Freehold Semi-detached house
CM2 9FW - 289,000
- Leasehold Flat/Maisonette
CM2 9FW - 291,000
- Leasehold Purpose built flat
CM2 9FW - 504,000
- Freehold Mid terrace house
CM2 9FW - 563,000
- Freehold Mid terrace house
CM2 9FW - 501,000
- Freehold Detached house
CM2 9FW - 271,000
- Leasehold Purpose built flat
CM2 9FW - 480,000
- Freehold Mid terrace house
CM2 9FW - 522,000
- Freehold Detached house
CM2 9FW - 560,000
- Freehold Mid terrace house
CM2 9FW - 294,000
- Leasehold Flat/Maisonette
CM2 9FW - 516,000
- Freehold Semi-detached house
CM2 9FW - 294,000
- Feudal Purpose built flat
CM2 9FW - 305,000
- Leasehold Flat/Maisonette
CM2 9FW - 559,000
- Freehold Mid terrace house
CM2 9FW - 304,000
- Leasehold Purpose built flat
CM2 9FW - 583,000
- Freehold Semi-detached house
CM2 9FW - 305,000
- Leasehold Flat/Maisonette
CM2 9FW - 448,000
- Freehold Detached house
CM2 9FW - 309,000
- Leasehold Purpose built flat
CM2 9FW - 288,000
- Leasehold Purpose built flat
CM2 9FW - 296,000
- Leasehold Flat/Maisonette
CM2 9FW - 560,000
- Freehold Mid terrace house
CM2 9FW - 291,000
- Leasehold Purpose built flat
CM2 9FW - 304,000
- Leasehold Flat/Maisonette
CM2 9FW - 479,000
- Freehold End terrace house
CM2 9FW - 479,000
- Freehold Mid terrace house
CM2 9FW - 432,000
- Freehold Mid terrace house
CM2 9FW - 293,000
- Leasehold Flat/Maisonette
CM2 9FW - 290,000
- Freehold Mid terrace house
CM2 9FW - 537,000
- Freehold Semi-detached house
CM2 9FW - 508,000
- Freehold Mid terrace house
CM2 9FW - 528,000
- Freehold Mid terrace house
CM2 9FW - 498,000
- Freehold Mid terrace house
CM2 9FW - 520,000
- Freehold Mid terrace house
CM2 9FW - 530,000
- Freehold Mid terrace house
CM2 9FW - 535,000
- Freehold Mid terrace house
CM2 9FW - 443,000
- Freehold Mid terrace house
CM2 9FW - 297,000
- Leasehold Purpose built flat
CM2 9FW - 241,000
- Leasehold Purpose built flat
CM2 9FW - 269,000
- Leasehold Flat/Maisonette
CM2 9FW - 299,000
- Leasehold Purpose built flat
CM2 9FW - 548,000
- Freehold Detached house
