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 0EW' order by fulladdress
LE6 0EW - 445,000
- Freehold Detached house
LE6 0EW - 553,000
- Freehold Detached house
LE6 0EW - 462,000
- Freehold Detached house
LE6 0EW - 512,000
- Freehold Detached house
LE6 0EW - 394,000
- Freehold Detached property
LE6 0EW - 491,000
- Freehold Detached house
LE6 0EW - 543,000
- Freehold Detached property
LE6 0EW - 438,000
- Freehold Detached house
LE6 0EW - 395,000
- Freehold Detached bungalow
LE6 0EW - 461,000
- Freehold Detached property
LE6 0EW - 407,000
- Freehold Detached house
LE6 0EW - 309,000
- Freehold Detached property
LE6 0EW - 423,000
- Freehold Detached house
LE6 0EW - 362,000
- Freehold Detached property
LE6 0EW - 571,000
- Freehold Detached house
LE6 0EW - 341,000
- Freehold Detached house
LE6 0EW - 335,000
- Freehold Detached house
LE6 0EW - 313,000
- Freehold Detached bungalow
LE6 0EW - 419,000
- Freehold Detached property
LE6 0EW - 302,000
- Freehold Detached bungalow
LE6 0EW - 303,000
- Freehold Semi-detached property
LE6 0EW - 369,000
- Freehold Detached bungalow
LE6 0EW - 382,000
- Freehold Detached house
LE6 0EW - 324,000
- Freehold Detached property
LE6 0EW - 337,000
- Freehold Detached house
LE6 0EW - 456,000
- Freehold Detached house
LE6 0EW - 359,000
- Freehold Detached bungalow
LE6 0EW - 552,000
- Freehold Detached property
LE6 0EW - 377,000
- Freehold Detached house
LE6 0EW - 339,000
- Freehold Detached bungalow
LE6 0EW - 317,000
- Freehold Detached bungalow
LE6 0EW - 369,000
- Freehold Detached bungalow
LE6 0EW - 343,000
- Freehold Detached bungalow
LE6 0EW - 319,000
- Freehold Detached bungalow
LE6 0EW - 368,000
- Freehold Detached house
LE6 0EW - 296,000
- Freehold Semi-detached bungalow
LE6 0EW - 309,000
- Freehold Detached bungalow
LE6 0EW - 528,000
- Freehold Detached bungalow