SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW18 1GY' order by fulladdress
SW18 1GY - 711,000
- Leasehold Purpose built flat
SW18 1GY - 682,000
- Leasehold Flat/Maisonette
SW18 1GY - 365,000
- Leasehold Purpose built flat
SW18 1GY - 788,000
- Leasehold Purpose built flat
SW18 1GY - 544,000
- Leasehold Purpose built flat
SW18 1GY - 319,000
- Leasehold Purpose built flat
SW18 1GY - 517,000
- Leasehold Purpose built flat
SW18 1GY - 724,000
- Leasehold Purpose built flat
SW18 1GY - 555,000
- Leasehold Purpose built flat
SW18 1GY - 694,000
- Leasehold Flat/Maisonette
SW18 1GY - 531,000
- Leasehold Purpose built flat
SW18 1GY - 538,000
- Leasehold Purpose built flat
SW18 1GY - 723,000
- Leasehold Flat/Maisonette
SW18 1GY - 455,000
- Leasehold Purpose built flat
SW18 1GY - 698,000
- Leasehold Flat/Maisonette
SW18 1GY - 552,000
- Leasehold Purpose built flat
SW18 1GY - 600,000
- Feudal Purpose built flat
SW18 1GY - 712,000
- Leasehold Flat/Maisonette
SW18 1GY - 604,000
- Feudal Purpose built flat
SW18 1GY - 695,000
- Leasehold Purpose built flat
SW18 1GY - 734,000
- Leasehold Purpose built flat
SW18 1GY - 578,000
- Leasehold Purpose built flat
SW18 1GY - 453,000
- Leasehold Purpose built flat
SW18 1GY - 740,000
- Leasehold Flat/Maisonette
SW18 1GY - 502,000
- Leasehold Purpose built flat
SW18 1GY - 2,145,000
- Leasehold Flat/Maisonette
SW18 1GY - 1,877,000
- Leasehold Flat/Maisonette
SW18 1GY - 339,000
- Leasehold Purpose built flat
SW18 1GY - 542,000
- Leasehold Flat/Maisonette
SW18 1GY - 650,000
- Leasehold Flat/Maisonette
SW18 1GY - 532,000
- Leasehold Purpose built flat
SW18 1GY - 570,000
- Leasehold Purpose built flat
SW18 1GY - 582,000
- Feudal Purpose built flat
SW18 1GY - 582,000
- Leasehold Purpose built flat
SW18 1GY - 488,000
- Leasehold Flat/Maisonette
SW18 1GY - 691,000
- Leasehold Purpose built flat
SW18 1GY - 579,000
- Leasehold Flat/Maisonette
SW18 1GY - 546,000
- Leasehold Purpose built flat
SW18 1GY - 453,000
- Feudal Purpose built flat
SW18 1GY - 599,000
- Leasehold Purpose built flat
SW18 1GY - 564,000
- Leasehold Purpose built flat
SW18 1GY - 655,000
- Leasehold Flat/Maisonette
SW18 1GY - 496,000
- Leasehold Flat/Maisonette
SW18 1GY - 623,000
- Leasehold Purpose built flat
SW18 1GY - 654,000
- Leasehold Purpose built flat
SW18 1GY - 533,000
- Leasehold Purpose built flat
SW18 1GY - 680,000
- Leasehold Flat/Maisonette
SW18 1GY - 717,000
- Leasehold Flat/Maisonette
SW18 1GY - 595,000
- Leasehold Purpose built flat
SW18 1GY - 540,000
- Leasehold Flat/Maisonette
SW18 1GY - 784,000
- Leasehold Flat/Maisonette
SW18 1GY - 562,000
- Leasehold Purpose built flat
SW18 1GY - 453,000
- Leasehold Purpose built flat
SW18 1GY - 530,000
- Feudal Purpose built flat
SW18 1GY - 547,000
- Leasehold Flat/Maisonette
SW18 1GY - 713,000
- Leasehold Flat/Maisonette
SW18 1GY - 508,000
- Leasehold Purpose built flat
SW18 1GY - 564,000
- Leasehold Purpose built flat
SW18 1GY - 596,000
- Leasehold Purpose built flat
SW18 1GY - 724,000
- Leasehold Flat/Maisonette
SW18 1GY - 528,000
- Leasehold Purpose built flat
SW18 1GY - 448,000
- Leasehold Purpose built flat
SW18 1GY - 676,000
- Freehold Flat/Maisonette
SW18 1GY - 622,000
- Leasehold Purpose built flat
SW18 1GY - 694,000
- Leasehold Purpose built flat
SW18 1GY - 453,000
- Feudal Purpose built flat
SW18 1GY - 596,000
- Leasehold Purpose built flat
SW18 1GY - 969,000
- Leasehold Flat/Maisonette
SW18 1GY - 565,000
- Feudal Purpose built flat
SW18 1GY - 530,000
- Leasehold Flat/Maisonette
SW18 1GY - 532,000
- Leasehold Purpose built flat
SW18 1GY - 557,000
- Leasehold Purpose built flat
SW18 1GY - 710,000
- Leasehold Flat/Maisonette
SW18 1GY - 1,471,000
- Leasehold Flat/Maisonette
SW18 1GY - 1,527,000
- Leasehold Flat/Maisonette
SW18 1GY - 517,000
- Leasehold Purpose built flat