SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW19 2DW' order by fulladdress
SW19 2DW - 575,000
- Freehold Mid terrace house
SW19 2DW - 233,000
- Leasehold Purpose built flat
SW19 2DW - 227,000
- Leasehold Purpose built flat
SW19 2DW - 220,000
- Leasehold Flat/Maisonette
SW19 2DW - 229,000
- Leasehold Flat/Maisonette
SW19 2DW - 240,000
- Leasehold Purpose built flat
SW19 2DW - 226,000
- Leasehold Purpose built flat
SW19 2DW - 234,000
- Leasehold Flat/Maisonette
SW19 2DW - 235,000
- Leasehold Purpose built flat
SW19 2DW - 535,000
- Freehold Mid terrace house
SW19 2DW - 238,000
- Leasehold Purpose built flat
SW19 2DW - 489,000
- Freehold Mid terrace house
SW19 2DW - 542,000
- Freehold Mid terrace house
SW19 2DW - 491,000
- Freehold End terrace house
SW19 2DW - 564,000
- Freehold End terrace house
SW19 2DW - 494,000
- Freehold Mid terrace house
SW19 2DW - 475,000
- Freehold End terrace house
SW19 2DW - 189,000
- Leasehold Flat/Maisonette
SW19 2DW - 495,000
- Freehold End terrace house
SW19 2DW - 356,000
- Leasehold Flat/Maisonette
SW19 2DW - 367,000
- Leasehold Purpose built flat
SW19 2DW - 496,000
- Freehold Mid terrace house
SW19 2DW - 309,000
- Leasehold Purpose built flat
SW19 2DW - 488,000
- Freehold Mid terrace house
SW19 2DW - 464,000
- Freehold End terrace house
SW19 2DW - 382,000
- Leasehold Flat/Maisonette
SW19 2DW - 359,000
- Leasehold Purpose built flat
SW19 2DW - 413,000
- Freehold End terrace house
SW19 2DW - 354,000
- Leasehold Purpose built flat
SW19 2DW - 365,000
- Leasehold Purpose built flat
SW19 2DW - 361,000
- Feudal Purpose built flat
SW19 2DW - 446,000
- Freehold End terrace house
SW19 2DW - 383,000
- Freehold End terrace house
SW19 2DW - 272,000
- Leasehold Purpose built flat
SW19 2DW - 264,000
- Leasehold Purpose built flat
SW19 2DW - 391,000
- Freehold End terrace house
SW19 2DW - 455,000
- Freehold End terrace house
SW19 2DW - 350,000
- Leasehold Flat/Maisonette
SW19 2DW - 469,000
- Freehold End terrace house
SW19 2DW - 381,000
- Leasehold Purpose built flat
SW19 2DW - 358,000
- Leasehold Purpose built flat
SW19 2DW - 460,000
- Freehold Mid terrace house
SW19 2DW - 278,000
- Leasehold Purpose built flat
SW19 2DW - 267,000
- Leasehold Purpose built flat
SW19 2DW - 472,000
- Freehold Mid terrace house
SW19 2DW - 445,000
- Freehold End terrace house
SW19 2DW - 372,000
- Leasehold Flat/Maisonette
SW19 2DW - 419,000
- Freehold End terrace house