SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LN6 9NZ' order by fulladdress
LN6 9NZ - 444,000
- Freehold Detached house
LN6 9NZ - 484,000
- Freehold Detached house
LN6 9NZ - 271,000
- Freehold Semi-detached house
LN6 9NZ - 452,000
- Freehold Detached house
LN6 9NZ - 377,000
- Freehold Detached house
LN6 9NZ - 283,000
- Freehold Semi-detached house
LN6 9NZ - 297,000
- Freehold Semi-detached house
LN6 9NZ - 280,000
- Freehold Semi-detached house
LN6 9NZ - 293,000
- Freehold Semi-detached house
LN6 9NZ - 229,000
- Freehold Semi-detached house
LN6 9NZ - 688,000
- Freehold Detached house
LN6 9NZ - 285,000
- Freehold Semi-detached house
LN6 9NZ - 243,000
- Freehold Semi-detached house
LN6 9NZ - 257,000
- Freehold Semi-detached house
LN6 9NZ - 231,000
- Freehold Semi-detached house
LN6 9NZ - 238,000
- Freehold Semi-detached property
LN6 9NZ - 237,000
- Freehold Semi-detached house
LN6 9NZ - 227,000
- Freehold Semi-detached house
LN6 9NZ - 373,000
- Freehold Detached house
LN6 9NZ - 353,000
- Freehold Detached house
LN6 9NZ - 298,000
- Freehold Semi-detached house
LN6 9NZ - 326,000
- Freehold Detached house
LN6 9NZ - 218,000
- Freehold Semi-detached house
LN6 9NZ - 296,000
- Freehold Semi-detached house
LN6 9NZ - 226,000
- Freehold Semi-detached house
LN6 9NZ - 401,000
- Freehold Detached property
LN6 9NZ - 285,000
- Freehold Semi-detached house
LN6 9NZ - 403,000
- Freehold Detached house
LN6 9NZ - 251,000
- Freehold Semi-detached house
LN6 9NZ - 283,000
- Freehold Semi-detached house
LN6 9NZ - 429,000
- Freehold Detached house
LN6 9NZ - 292,000
- Freehold Semi-detached house
LN6 9NZ - 382,000
- Freehold Detached house
LN6 9NZ - 433,000
- Freehold Detached property
LN6 9NZ - 438,000
- Freehold Detached house
LN6 9NZ - 403,000
- Freehold Detached property
LN6 9NZ - 296,000
- Freehold Semi-detached house
LN6 9NZ - 301,000
- Freehold Semi-detached house
LN6 9NZ - 314,000
- Freehold Detached property
LN6 9NZ - 394,000
- Freehold Detached house
LN6 9NZ - 397,000
- Freehold Detached house
LN6 9NZ - 392,000
- Freehold Detached house
LN6 9NZ - 383,000
- Freehold Detached house
LN6 9NZ - 439,000
- Freehold Detached house
LN6 9NZ - 311,000
- Freehold Detached house
LN6 9NZ - 553,000
- Freehold Detached house
LN6 9NZ - 567,000
- Freehold Detached property
LN6 9NZ - 307,000
- Freehold Semi-detached house
LN6 9NZ - 495,000
- Freehold Detached house
LN6 9NZ - 525,000
- Freehold Detached house
LN6 9NZ - 323,000
- Freehold Detached house
LN6 9NZ - 278,000
- Freehold Semi-detached house
LN6 9NZ - 288,000
- Freehold Detached house