SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB1 7TY' order by fulladdress
CB1 7TY - 1,467,000
- Freehold End terrace house
CB1 7TY - 719,000
- Freehold Terrace property
CB1 7TY - 704,000
- Freehold Terrace property
CB1 7TY - 725,000
- Freehold Terrace property
CB1 7TY - 742,000
- Share of freehold Terrace property
CB1 7TY - 725,000
- Freehold Mid terrace house
CB1 7TY - 842,000
- Freehold End terrace house
CB1 7TY - 749,000
- Freehold Semi-detached house
CB1 7TY - 728,000
- Freehold End terrace house
CB1 7TY - 783,000
- Freehold Mid terrace house
CB1 7TY - 648,000
- Freehold Mid terrace house
CB1 7TY - 838,000
- Freehold Detached house
CB1 7TY - 741,000
- Freehold Terrace property
CB1 7TY - 979,000
- Freehold End terrace house
CB1 7TY - 703,000
- Freehold Semi-detached house
CB1 7TY - 723,000
- Freehold End terrace house
CB1 7TY - 717,000
- Freehold Semi-detached house
CB1 7TY - 732,000
- Freehold Mid terrace house
CB1 7TY - 796,000
- Freehold Terrace property
CB1 7TY - 717,000
- Freehold Mid terrace house
CB1 7TY - 786,000
- Freehold Mid terrace house
CB1 7TY - 637,000
- Freehold End terrace house
CB1 7TY - 706,000
- Freehold Mid terrace house
CB1 7TY - 636,000
- Freehold Semi-detached house
CB1 7TY - 685,000
- Freehold Terrace property
CB1 7TY - 740,000
- Freehold Mid terrace house
CB1 7TY - 769,000
- Freehold Terrace property
CB1 7TY - 718,000
- Freehold Terrace property
CB1 7TY - 694,000
- Freehold Terrace property
CB1 7TY - 769,000
- Freehold Detached house
CB1 7TY - 795,000
- Freehold Terrace property
CB1 7TY - 685,000
- Share of freehold End terrace house
CB1 7TY - 709,000
- Freehold Terrace property
CB1 7TY - 825,000
- Freehold Terrace property
CB1 7TY - 636,000
- Freehold Mid terrace house
CB1 7TY - 705,000
- Freehold Mid terrace house
CB1 7TY - 818,000
- Freehold Semi-detached house
CB1 7TY - 686,000
- Freehold Mid terrace house
CB1 7TY - 677,000
- Freehold Terrace property
CB1 7TY - 708,000
- Freehold Mid terrace house
CB1 7TY - 780,000
- Freehold Mid terrace house
CB1 7TY - 632,000
- Freehold Terrace property
CB1 7TY - 744,000
- Freehold Terrace property
CB1 7TY - 377,000
- Freehold Flat/Maisonette
CB1 7TY - 704,000
- Freehold Terrace property
CB1 7TY - 857,000
- Freehold End terrace house
CB1 7TY - 781,000
- Semi-detached house
CB1 7TY - 783,000
- Freehold Mid terrace house
CB1 7TY - 737,000
- Freehold Semi-detached property