SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W12 9RJ' order by fulladdress
W12 9RJ - 2,252,000
- Freehold Semi-detached house
W12 9RJ - 2,117,000
- Freehold Semi-detached house
W12 9RJ - 1,984,000
- Freehold Semi-detached house
W12 9RJ - 2,302,000
- Freehold Detached house
W12 9RJ - 1,904,000
- Freehold Terraced
W12 9RJ - 2,011,000
- Freehold Semi-detached house
W12 9RJ - 1,886,000
- Freehold Semi-detached house
W12 9RJ - 751,000
- Leasehold Converted flat
W12 9RJ - 1,913,000
- Freehold Semi-detached house
W12 9RJ - 720,000
- Leasehold Converted flat
W12 9RJ - 670,000
- Share of freehold Flat/Maisonette
W12 9RJ - 2,215,000
- Freehold Semi-detached house
W12 9RJ - 2,018,000
- Freehold Semi-detached house
W12 9RJ - 2,065,000
- Freehold Semi-detached house
W12 9RJ - 1,737,000
- Freehold Semi-detached house
W12 9RJ - 2,195,000
- Freehold Semi-detached house
W12 9RJ - 1,775,000
- Freehold Semi-detached house
W12 9RJ - 1,934,000
- End terrace property
W12 9RJ - 2,190,000
- Freehold Semi-detached house
W12 9RJ - 2,066,000
- Freehold End terrace house
W12 9RJ - 1,888,000
- Freehold Mid terrace house
W12 9RJ - 2,215,000
- Freehold Mid terrace house
W12 9RJ - 2,054,000
- Freehold Detached house
W12 9RJ - 2,589,000
- Freehold Semi-detached house
W12 9RJ - 2,104,000
- Freehold Semi-detached house
W12 9RJ - 2,139,000
- Freehold Semi-detached house
W12 9RJ - 2,032,000
- Freehold Semi-detached house
W12 9RJ - 1,182,000
- Freehold Semi-detached house
