SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW15 2JJ' order by fulladdress
SW15 2JJ - 574,000
- Leasehold Purpose built flat
SW15 2JJ - 666,000
- Leasehold Flat/Maisonette
SW15 2JJ - 689,000
- Feudal Purpose built flat
SW15 2JJ - 648,000
- Leasehold Purpose built flat
SW15 2JJ - 663,000
- Leasehold Flat/Maisonette
SW15 2JJ - 722,000
- Leasehold Flat/Maisonette
SW15 2JJ - 623,000
- Leasehold Purpose built flat
SW15 2JJ - 578,000
- Leasehold Flat/Maisonette
SW15 2JJ - 655,000
- Leasehold Purpose built flat
SW15 2JJ - 630,000
- Leasehold Purpose built flat
SW15 2JJ - 869,000
- Leasehold Flat/Maisonette
SW15 2JJ - 605,000
- Leasehold Purpose built flat
SW15 2JJ - 641,000
- Leasehold Purpose built flat
SW15 2JJ - 749,000
- Leasehold Flat/Maisonette
SW15 2JJ - 711,000
- Leasehold Purpose built flat
SW15 2JJ - 666,000
- Leasehold Purpose built flat
SW15 2JJ - 627,000
- Leasehold Flat/Maisonette
SW15 2JJ - 741,000
- Leasehold Purpose built flat
SW15 2JJ - 1,365,000
- Leasehold Purpose built flat
SW15 2JJ - 740,000
- Leasehold Flat/Maisonette
SW15 2JJ - 814,000
- Leasehold Flat/Maisonette
SW15 2JJ - 725,000
- Leasehold Flat/Maisonette
SW15 2JJ - 670,000
- Leasehold Flat/Maisonette
SW15 2JJ - 469,000
- Leasehold Flat/Maisonette
SW15 2JJ - 429,000
- Leasehold Purpose built flat
SW15 2JJ - 763,000
- Leasehold Flat/Maisonette
SW15 2JJ - 759,000
- Leasehold Flat/Maisonette
SW15 2JJ - 628,000
- Leasehold Flat/Maisonette
SW15 2JJ - 728,000
- Leasehold Flat/Maisonette
SW15 2JJ - 474,000
- Leasehold Purpose built flat
SW15 2JJ - 564,000
- Leasehold Flat/Maisonette
SW15 2JJ - 813,000
- Leasehold Purpose built flat
SW15 2JJ - 794,000
- Leasehold Flat/Maisonette
SW15 2JJ - 760,000
- Leasehold Flat/Maisonette
SW15 2JJ - 699,000
- Leasehold Purpose built flat
SW15 2JJ - 774,000
- Leasehold Flat/Maisonette
SW15 2JJ - 767,000
- Leasehold Flat/Maisonette
SW15 2JJ - 583,000
- Leasehold Flat/Maisonette
SW15 2JJ - 574,000
- Leasehold Flat/Maisonette
SW15 2JJ - 796,000
- Leasehold Flat/Maisonette
SW15 2JJ - 1,122,000
- Leasehold Flat/Maisonette
SW15 2JJ - 1,055,000
- Leasehold Flat/Maisonette
SW15 2JJ - 818,000
- Leasehold Flat/Maisonette
SW15 2JJ - 871,000
- Leasehold Flat/Maisonette
SW15 2JJ - 1,162,000
- Leasehold Purpose built flat
SW15 2JJ - 594,000
- Leasehold Flat/Maisonette