SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W4 5NQ' order by fulladdress
W4 5NQ - 581,000
- Leasehold Converted flat
W4 5NQ - 494,000
- Leasehold Converted flat
W4 5NQ - 992,000
- Freehold Mid terrace house
W4 5NQ - 1,297,000
- Freehold End terrace house
W4 5NQ - 976,000
- Freehold Mid terrace house
W4 5NQ - 1,147,000
- Freehold End terrace house
W4 5NQ - 1,197,000
- Freehold Mid terrace house
W4 5NQ - 1,115,000
- Freehold Semi-detached house
W4 5NQ - 1,152,000
- Freehold Mid terrace house
W4 5NQ - 1,215,000
- Freehold Mid terrace house
W4 5NQ - 1,287,000
- Freehold Semi-detached property
W4 5NQ - 1,313,000
- Freehold Mid terrace property
W4 5NQ - 1,274,000
- Freehold Mid terrace house
W4 5NQ - 1,360,000
- Mid terrace house
W4 5NQ - 1,377,000
- Freehold Mid terrace house
W4 5NQ - 466,000
- Freehold Flat/Maisonette
W4 5NQ - 1,419,000
- Freehold Semi-detached house
W4 5NQ - 1,362,000
- Freehold Mid terrace house
W4 5NQ - 1,261,000
- Freehold Mid terrace house
W4 5NQ - 1,184,000
- Freehold Mid terrace house
W4 5NQ - 1,180,000
- Freehold Terraced bungalow
W4 5NQ - 1,572,000
- Mid terrace house
W4 5NQ - 1,164,000
- Freehold Detached house
W4 5NQ - 1,468,000
- Freehold Mid terrace house
W4 5NQ - 1,345,000
- Freehold Mid terrace house
W4 5NQ - 1,603,000
- Freehold Semi-detached house
W4 5NQ - 1,479,000
- Freehold Semi-detached house
