SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB4 2YQ' order by fulladdress
CB4 2YQ - 493,000
- Freehold End terrace house
CB4 2YQ - 486,000
- Freehold Mid terrace house
CB4 2YQ - 490,000
- Freehold Mid terrace house
CB4 2YQ - 542,000
- Freehold Detached property
CB4 2YQ - 219,000
- Feudal Purpose built flat
CB4 2YQ - 237,000
- Leasehold Purpose built flat
CB4 2YQ - 484,000
- Freehold Mid terrace house
CB4 2YQ - 206,000
- Leasehold Purpose built flat
CB4 2YQ - 230,000
- Leasehold Flat/Maisonette
CB4 2YQ - 272,000
- Leasehold Purpose built flat
CB4 2YQ - 303,000
- Leasehold Purpose built flat
CB4 2YQ - 217,000
- Leasehold Purpose built flat
CB4 2YQ - 495,000
- Freehold End terrace house
CB4 2YQ - 473,000
- Freehold Mid terrace house
CB4 2YQ - 579,000
- Freehold Terrace property
CB4 2YQ - 591,000
- Freehold Mid terrace house
CB4 2YQ - 608,000
- Freehold Mid terrace house
CB4 2YQ - 567,000
- Freehold Mid terrace house
CB4 2YQ - 507,000
- Freehold End terrace house
CB4 2YQ - 551,000
- Freehold End terrace house
CB4 2YQ - 553,000
- Freehold Mid terrace house
CB4 2YQ - 562,000
- Freehold Detached property
CB4 2YQ - 554,000
- Freehold Mid terrace house
CB4 2YQ - 535,000
- Freehold Mid terrace house
CB4 2YQ - 483,000
- Freehold End terrace property
CB4 2YQ - 529,000
- Freehold End terrace house
CB4 2YQ - 530,000
- Freehold Semi-detached house
CB4 2YQ - 516,000
- Freehold Mid terrace house
CB4 2YQ - 513,000
- Freehold Mid terrace house
CB4 2YQ - 509,000
- Freehold Terrace property
CB4 2YQ - 513,000
- Freehold End terrace house
CB4 2YQ - 453,000
- Freehold Mid terrace house
CB4 2YQ - 469,000
- Freehold Terrace property
CB4 2YQ - 504,000
- Freehold End terrace property
CB4 2YQ - 491,000
- Freehold End terrace house
