SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LE6 0AA' order by fulladdress
LE6 0AA - 676,000
- Freehold Detached property
LE6 0AA - 769,000
- Freehold Detached property
LE6 0AA - 654,000
- Freehold Detached house
LE6 0AA - 576,000
- Freehold Detached property
LE6 0AA - 667,000
- Freehold Detached house
LE6 0AA - 588,000
- Freehold Detached bungalow
LE6 0AA - 628,000
- Freehold Detached bungalow
LE6 0AA - 703,000
- Freehold Detached bungalow
LE6 0AA - 710,000
- Freehold Detached property
LE6 0AA - 666,000
- Freehold Detached bungalow
LE6 0AA - 676,000
- Freehold Detached house
LE6 0AA - 628,000
- Freehold Detached house
LE6 0AA - 808,000
- Freehold Detached house
LE6 0AA - 366,000
- Freehold Semi-detached house
LE6 0AA - 766,000
- Freehold Detached bungalow
LE6 0AA - 752,000
- Freehold Detached house
LE6 0AA - 371,000
- Semi-detached house
LE6 0AA - 417,000
- Freehold Semi-detached house
LE6 0AA - 367,000
- Freehold Semi-detached house
LE6 0AA - 393,000
- Freehold Semi-detached house
LE6 0AA - 373,000
- Semi-detached house
LE6 0AA - 383,000
- Freehold Semi-detached house
LE6 0AA - 388,000
- Semi-detached house
LE6 0AA - 460,000
- Freehold Semi-detached house
LE6 0AA - 542,000
- Freehold Detached bungalow
LE6 0AA - 432,000
- Freehold Semi-detached house
LE6 0AA - 420,000
- Freehold Semi-detached house
LE6 0AA - 461,000
- Freehold Semi-detached house
LE6 0AA - 541,000
- Freehold Detached bungalow
LE6 0AA - 670,000
- Freehold Detached house
LE6 0AA - 594,000
- Freehold Detached house
LE6 0AA - 906,000
- Freehold Detached house
LE6 0AA - 790,000
- Freehold Detached bungalow
LE6 0AA - 359,000
- Freehold Detached house
LE6 0AA - 678,000
- Freehold Detached house
LE6 0AA - 931,000
- Freehold Detached property