SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB3 1BG' order by fulladdress
CB3 1BG - 590,000
- Leasehold Flat/Maisonette
CB3 1BG - 405,000
- Leasehold Flat/Maisonette
CB3 1BG - 700,000
- Leasehold Flat/Maisonette
CB3 1BG - 709,000
- Leasehold Flat/Maisonette
CB3 1BG - 409,000
- Leasehold Flat/Maisonette
CB3 1BG - 543,000
- Leasehold Flat/Maisonette
CB3 1BG - 401,000
- Leasehold Purpose built flat
CB3 1BG - 491,000
- Leasehold Purpose built flat
CB3 1BG - 502,000
- Leasehold Flat/Maisonette
CB3 1BG - 531,000
- Leasehold Purpose built flat
CB3 1BG - 407,000
- Leasehold Flat/Maisonette
CB3 1BG - 535,000
- Leasehold Purpose built flat
CB3 1BG - 394,000
- Leasehold Flat/Maisonette
CB3 1BG - 674,000
- Leasehold Purpose built flat
CB3 1BG - 404,000
- Leasehold Flat/Maisonette
CB3 1BG - 541,000
- Leasehold Flat/Maisonette
CB3 1BG - 400,000
- Leasehold Purpose built flat
CB3 1BG - 689,000
- Leasehold Flat/Maisonette
CB3 1BG - 403,000
- Leasehold Purpose built flat
CB3 1BG - 413,000
- Leasehold Flat/Maisonette
CB3 1BG - 552,000
- Leasehold Flat/Maisonette
CB3 1BG - 400,000
- Leasehold Flat/Maisonette
CB3 1BG - 488,000
- Leasehold Flat/Maisonette