SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LN1 1EB' order by fulladdress
LN1 1EB - 453,000
- Freehold Detached house
LN1 1EB - 460,000
- Freehold Detached house
LN1 1EB - 345,000
- Freehold Detached house
LN1 1EB - 318,000
- Freehold Detached property
LN1 1EB - 342,000
- Freehold Detached house
LN1 1EB - 300,000
- Freehold Detached property
LN1 1EB - 325,000
- Freehold Detached house
LN1 1EB - 325,000
- Freehold Bungalow property
LN1 1EB - 352,000
- Freehold Detached house
LN1 1EB - 292,000
- Freehold Detached bungalow
LN1 1EB - 336,000
- Freehold Detached bungalow
LN1 1EB - 467,000
- Freehold Detached property
LN1 1EB - 415,000
- Freehold Detached house
LN1 1EB - 340,000
- Freehold Detached bungalow
LN1 1EB - 324,000
- Freehold Detached property
LN1 1EB - 311,000
- Freehold Detached bungalow
LN1 1EB - 464,000
- Freehold Detached house
LN1 1EB - 396,000
- Freehold Detached bungalow
LN1 1EB - 333,000
- Freehold Detached bungalow
LN1 1EB - 400,000
- Freehold Detached house
LN1 1EB - 428,000
- Freehold Detached bungalow
LN1 1EB - 299,000
- Freehold Detached bungalow
LN1 1EB - 451,000
- Freehold Detached property
LN1 1EB - 504,000
- Freehold Detached property
LN1 1EB - 452,000
- Freehold Detached property
LN1 1EB - 392,000
- Freehold Bungalow property
LN1 1EB - 451,000
- Freehold Detached bungalow
LN1 1EB - 518,000
- Freehold Detached house
LN1 1EB - 545,000
- Freehold Detached house
LN1 1EB - 597,000
- Freehold Detached house
LN1 1EB - 459,000
- Freehold Detached house
LN1 1EB - 477,000
- Freehold Detached property
LN1 1EB - 591,000
- Freehold Detached house
LN1 1EB - 524,000
- Freehold Detached property
LN1 1EB - 522,000
- Freehold Detached house
LN1 1EB - 447,000
- Freehold Detached house
LN1 1EB - 342,000
- Freehold Detached property
LN1 1EB - 545,000
- Freehold Detached house
LN1 1EB - 599,000
- Freehold Detached house
