SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LA23 3JG' order by fulladdress
LA23 3JG - 3,956,000
- Freehold Detached house
LA23 3JG - 4,257,000
- Freehold Detached house
LA23 3JG - 491,000
- Leasehold Flat/Maisonette
LA23 3JG - 411,000
- Leasehold Converted flat
LA23 3JG - 349,000
- Leasehold Converted flat
LA23 3JG - 426,000
- Leasehold Flat/Maisonette
LA23 3JG - 327,000
- Leasehold Flat/Maisonette
LA23 3JG - 483,000
- Leasehold Flat/Maisonette
LA23 3JG - 348,000
- Leasehold Flat/Maisonette
LA23 3JG - 468,000
- Leasehold Flat/Maisonette
LA23 3JG - 298,000
- Leasehold Flat/Maisonette
LA23 3JG - 321,000
- Leasehold Converted flat
LA23 3JG - 417,000
- Leasehold Converted flat
LA23 3JG - 366,000
- Leasehold Flat/Maisonette
LA23 3JG - 364,000
- Leasehold Flat/Maisonette
LA23 3JG - 3,364,000
- Freehold Detached property
LA23 3JG - 1,050,000
- Freehold Detached house
LA23 3JG - 2,265,000
- Freehold Detached house
LA23 3JG - 3,174,000
- Freehold Detached property
LA23 3JG - 2,435,000
- Freehold Detached property
