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 9ZD' order by fulladdress
LN6 9ZD - 374,000
- Freehold Detached house
LN6 9ZD - 383,000
- Freehold Detached house
LN6 9ZD - 313,000
- Freehold Mid terrace house
LN6 9ZD - 412,000
- Freehold Detached house
LN6 9ZD - 437,000
- Freehold Detached house
LN6 9ZD - 215,000
- Freehold End terrace house
LN6 9ZD - 445,000
- Freehold Detached house
LN6 9ZD - 208,000
- Freehold Terrace property
LN6 9ZD - 382,000
- Freehold Detached house
LN6 9ZD - 211,000
- Freehold Terrace property
LN6 9ZD - 422,000
- Freehold Detached house
LN6 9ZD - 399,000
- Freehold Detached house
LN6 9ZD - 375,000
- Freehold Detached house
LN6 9ZD - 411,000
- Freehold Detached house
LN6 9ZD - 304,000
- Freehold Semi-detached house
LN6 9ZD - 388,000
- Freehold Detached house
LN6 9ZD - 300,000
- Freehold Semi-detached house
LN6 9ZD - 413,000
- Freehold Detached house
LN6 9ZD - 309,000
- Freehold Detached house
LN6 9ZD - 382,000
- Freehold Detached house
LN6 9ZD - 296,000
- Freehold Detached house
LN6 9ZD - 348,000
- Freehold Detached house
LN6 9ZD - 461,000
- Freehold Detached house
LN6 9ZD - 291,000
- Freehold Semi-detached house
LN6 9ZD - 415,000
- Freehold Detached house
LN6 9ZD - 296,000
- Freehold Semi-detached house
LN6 9ZD - 491,000
- Freehold Detached house
LN6 9ZD - 291,000
- Freehold Semi-detached house
LN6 9ZD - 490,000
- Freehold Detached house
LN6 9ZD - 295,000
- Freehold Semi-detached house
LN6 9ZD - 493,000
- Freehold Detached house
LN6 9ZD - 384,000
- Freehold Detached house
LN6 9ZD - 394,000
- Freehold Detached property
LN6 9ZD - 457,000
- Freehold Detached house
LN6 9ZD - 292,000
- Freehold Detached house
LN6 9ZD - 422,000
- Freehold Detached house
LN6 9ZD - 376,000
- Freehold Detached house
LN6 9ZD - 460,000
- Freehold Detached house
LN6 9ZD - 233,000
- Freehold Semi-detached house
LN6 9ZD - 366,000
- Freehold Detached house
LN6 9ZD - 231,000
- Freehold Semi-detached house
LN6 9ZD - 305,000
- Freehold Semi-detached house
LN6 9ZD - 290,000
- End terrace property
LN6 9ZD - 301,000
- Freehold Semi-detached house
LN6 9ZD - 280,000
- Freehold Detached house
LN6 9ZD - 377,000
- Freehold Detached house
LN6 9ZD - 384,000
- Freehold Detached house
LN6 9ZD - 280,000
- Freehold Detached house
LN6 9ZD - 410,000
- Freehold Detached house
LN6 9ZD - 346,000
- Freehold Detached house
LN6 9ZD - 289,000
- Freehold Semi-detached house
LN6 9ZD - 287,000
- Freehold Semi-detached house
LN6 9ZD - 289,000
- Freehold Detached house
LN6 9ZD - 386,000
- Freehold Detached house
LN6 9ZD - 301,000
- Freehold Detached house