SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LE7 4YF' order by fulladdress
LE7 4YF - 720,000
- Freehold Detached house
LE7 4YF - 351,000
- Freehold Bungalow property
LE7 4YF - 543,000
- Freehold Detached property
LE7 4YF - 550,000
- Freehold Detached bungalow
LE7 4YF - 717,000
- Freehold Detached house
LE7 4YF - 425,000
- Freehold Detached bungalow
LE7 4YF - 679,000
- Freehold Detached house
LE7 4YF - 456,000
- Freehold Detached bungalow
LE7 4YF - 498,000
- Freehold Detached property
LE7 4YF - 491,000
- Freehold Detached bungalow
LE7 4YF - 500,000
- Freehold Detached house
LE7 4YF - 541,000
- Freehold Detached bungalow
LE7 4YF - 447,000
- Freehold Detached bungalow
LE7 4YF - 567,000
- Freehold Detached bungalow
LE7 4YF - 385,000
- Freehold Bungalow property
LE7 4YF - 431,000
- Freehold Detached bungalow
LE7 4YF - 429,000
- Freehold Detached bungalow
LE7 4YF - 1,031,000
- Freehold Detached house
LE7 4YF - 403,000
- Freehold Detached bungalow
LE7 4YF - 444,000
- Freehold Detached property
