SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W2 2SB' order by fulladdress
W2 2SB - 1,705,000
- Freehold Mid terrace house
W2 2SB - 1,486,000
- Leasehold Mid terrace house
W2 2SB - 1,805,000
- Leasehold Mid terrace house
W2 2SB - 1,893,000
- Leasehold Mid terrace house
W2 2SB - 2,017,000
- Leasehold Mid terrace house
W2 2SB - 1,055,000
- Leasehold Flat/Maisonette
W2 2SB - 1,432,000
- Leasehold Flat/Maisonette
W2 2SB - 2,993,000
- Freehold Mid terrace house
W2 2SB - 2,356,000
- Freehold Mid terrace house
W2 2SB - 1,944,000
- Leasehold Terraced
W2 2SB - 2,286,000
- Freehold Terrace property
W2 2SB - 2,081,000
- Leasehold Mid terrace house
W2 2SB - 1,807,000
- Terrace property
W2 2SB - 2,126,000
- Freehold Mid terrace house
W2 2SB - 1,759,000
- Leasehold Mid terrace house
W2 2SB - 0
- Leasehold Terrace property
W2 2SB - 1,644,000
- Mid terrace house
W2 2SB - 1,955,000
- Freehold Mid terrace house
W2 2SB - 1,680,000
- Freehold Mid terrace house
W2 2SB - 2,624,000
- Mid terrace house
W2 2SB - 1,704,000
- Freehold Terraced
W2 2SB - 1,038,000
- Flat/Maisonette
W2 2SB - 2,106,000
- Freehold Mid terrace house
W2 2SB - 2,122,000
- Leasehold Terraced
W2 2SB - 2,157,000
- Leasehold Mid terrace house
W2 2SB - 2,675,000
- Leasehold Mid terrace house
W2 2SB - 2,264,000
- Freehold Mid terrace house
W2 2SB - 2,860,000
- Freehold Mid terrace house
W2 2SB - 760,000
- Leasehold Flat/Maisonette
W2 2SB - 2,014,000
- Freehold End terrace house
W2 2SB - 2,014,000
- Freehold Mid terrace house
W2 2SB - 1,744,000
- Freehold Mid terrace house
W2 2SB - 2,088,000
- Leasehold Mid terrace house
W2 2SB - 2,365,000
- Leasehold Terraced
W2 2SB - 2,728,000
- Freehold End terrace house
W2 2SB - 3,635,000
- Freehold Terrace property
W2 2SB - 1,806,000
- Freehold Mid terrace house
W2 2SB - 1,765,000
- Leasehold Terrace property
W2 2SB - 1,581,000
- Leasehold Terrace property
W2 2SB - 1,958,000
- Freehold Mid terrace house
W2 2SB - 2,593,000
- Freehold Mid terrace house
W2 2SB - 2,464,000
- Freehold Terraced
W2 2SB - 1,731,000
- Freehold Terrace property
W2 2SB - 1,607,000
- Freehold Mid terrace house
W2 2SB - 2,297,000
- Freehold Terraced
W2 2SB - 1,172,000
- Leasehold Flat/Maisonette
W2 2SB - 2,019,000
- Leasehold Mid terrace house
W2 2SB - 2,645,000
- Freehold Terrace property
W2 2SB - 2,287,000
- Freehold Terrace property
W2 2SB - 3,331,000
- Mid terrace house
W2 2SB - 0
- Leasehold Flat/Maisonette
W2 2SB - 1,008,000
- Leasehold Purpose built flat
W2 2SB - 2,500,000
- Leasehold Terraced