SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LS19 7JL' order by fulladdress
LS19 7JL - 258,000
- Freehold Semi-detached house
LS19 7JL - 276,000
- Freehold Semi-detached house
LS19 7JL - 259,000
- Freehold Semi-detached house
LS19 7JL - 255,000
- Freehold Semi-detached house
LS19 7JL - 298,000
- Freehold Semi-detached house
LS19 7JL - 262,000
- Freehold Semi-detached house
LS19 7JL - 310,000
- Freehold Semi-detached house
LS19 7JL - 429,000
- Freehold Detached house
LS19 7JL - 272,000
- Freehold Semi-detached house
LS19 7JL - 428,000
- Freehold Detached house
LS19 7JL - 458,000
- Freehold Detached house
LS19 7JL - 424,000
- Freehold Detached house
LS19 7JL - 545,000
- Freehold Detached house
LS19 7JL - 425,000
- Freehold Semi-detached house
LS19 7JL - 537,000
- Freehold Detached house
LS19 7JL - 437,000
- Freehold Detached house
LS19 7JL - 609,000
- Freehold Detached house
LS19 7JL - 275,000
- Freehold Semi-detached house
LS19 7JL - 339,000
- Freehold Detached house
LS19 7JL - 576,000
- Freehold Detached house
LS19 7JL - 501,000
- Freehold Detached house
LS19 7JL - 596,000
- Freehold Detached house
LS19 7JL - 507,000
- Freehold Detached house
LS19 7JL - 597,000
- Freehold Detached house
LS19 7JL - 497,000
- Freehold Detached house
LS19 7JL - 567,000
- Freehold Detached house
LS19 7JL - 338,000
- Freehold End terrace house
LS19 7JL - 541,000
- Freehold Detached house
LS19 7JL - 299,000
- Freehold Semi-detached house
LS19 7JL - 265,000
- Freehold Semi-detached house
LS19 7JL - 359,000
- Freehold Detached house
LS19 7JL - 419,000
- Freehold Detached house
LS19 7JL - 432,000
- Freehold Detached house
LS19 7JL - 282,000
- Freehold Mid terrace house
LS19 7JL - 505,000
- Freehold Detached house
LS19 7JL - 428,000
- Freehold Detached house
LS19 7JL - 427,000
- Freehold Detached house
LS19 7JL - 434,000
- Freehold Detached house
LS19 7JL - 270,000
- Freehold Semi-detached property
LS19 7JL - 282,000
- Freehold Semi-detached house
LS19 7JL - 276,000
- Freehold Semi-detached house