SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 7NA' order by fulladdress
W8 7NA - 1,354,000
- Flat/Maisonette
W8 7NA - 7,240,000
- Freehold Mid terrace house
W8 7NA - 6,123,000
- Freehold Terrace property
W8 7NA - 6,937,000
- Mid terrace house
W8 7NA - 5,682,000
- Freehold Mid terrace house
W8 7NA - 6,559,000
- Freehold Mid terrace house
W8 7NA - 5,928,000
- Freehold Mid terrace house
W8 7NA - 6,777,000
- Freehold Mid terrace house
W8 7NA - 6,241,000
- Freehold Mid terrace house
W8 7NA - 6,441,000
- Freehold Mid terrace house
W8 7NA - 6,138,000
- Freehold Terrace property
W8 7NA - 6,523,000
- Freehold Mid terrace house
W8 7NA - 6,685,000
- Freehold Mid terrace house
W8 7NA - 6,302,000
- Freehold Mid terrace house
W8 7NA - 6,267,000
- Freehold End terrace house
W8 7NA - 5,928,000
- Freehold Terraced
W8 7NA - 6,174,000
- Freehold Terraced
W8 7NA - 6,294,000
- Freehold Mid terrace house
W8 7NA - 5,588,000
- Freehold End terrace house
W8 7NA - 18,525,000
- Freehold Detached house
W8 7NA - 5,159,000
- Freehold Mid terrace house
W8 7NA - 8,116,000
- Freehold Terraced
W8 7NA - 982,000
- Leasehold Converted flat
W8 7NA - 1,050,000
- Flat/Maisonette