SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BB2 7EX' order by fulladdress
BB2 7EX - 470,000
- Leasehold Detached house
BB2 7EX - 227,000
- Freehold Terrace property
BB2 7EX - 566,000
- Freehold Detached property
BB2 7EX - 238,000
- Freehold Mid terrace house
BB2 7EX - 253,000
- Freehold Mid terrace house
BB2 7EX - 243,000
- Freehold Mid terrace house
BB2 7EX - 268,000
- Freehold Semi-detached house
BB2 7EX - 260,000
- Freehold Mid terrace house
BB2 7EX - 1,133,000
- Leasehold Detached house
BB2 7EX - 250,000
- Freehold Terrace property
BB2 7EX - 253,000
- Freehold Mid terrace house
BB2 7EX - 862,000
- Freehold Detached house
BB2 7EX - 248,000
- Freehold Mid terrace house
BB2 7EX - 764,000
- Leasehold Detached house
BB2 7EX - 245,000
- Freehold Mid terrace house
BB2 7EX - 721,000
- Leasehold Detached house
BB2 7EX - 242,000
- Freehold Mid terrace house
BB2 7EX - 735,000
- Leasehold Detached house
BB2 7EX - 242,000
- Freehold Mid terrace house
BB2 7EX - 695,000
- Leasehold Detached property
BB2 7EX - 236,000
- Freehold Mid terrace house
BB2 7EX - 243,000
- Freehold Mid terrace house
BB2 7EX - 254,000
- Freehold Mid terrace house
BB2 7EX - 475,000
- Leasehold Bungalow property
BB2 7EX - 255,000
- Freehold End terrace house
BB2 7EX - 426,000
- Leasehold Detached house
BB2 7EX - 515,000
- Freehold Detached house
BB2 7EX - 707,000
- Freehold Detached house
BB2 7EX - 479,000
- Freehold Detached house
BB2 7EX - 260,000
- Freehold Mid terrace house
BB2 7EX - 396,000
- Freehold Detached house
BB2 7EX - 521,000
- Freehold Detached house
BB2 7EX - 613,000
- Freehold Detached house
BB2 7EX - 265,000
- Freehold End terrace house
BB2 7EX - 656,000
- Freehold Detached property
BB2 7EX - 333,000
- Freehold Bungalow property
BB2 7EX - 455,000
- Leasehold Detached house
BB2 7EX - 451,000
- Freehold Detached bungalow
BB2 7EX - 450,000
- Freehold Detached house
BB2 7EX - 511,000
- Freehold Detached bungalow
BB2 7EX - 621,000
- Freehold Detached property
BB2 7EX - 254,000
- Freehold End terrace house
BB2 7EX - 771,000
- Mid terrace property
BB2 7EX - 658,000
- Freehold Detached house
BB2 7EX - 293,000
- Semi-detached house
BB2 7EX - 373,000
- Freehold Detached house
BB2 7EX - 416,000
- Freehold Semi-detached house
BB2 7EX - 606,000
- Leasehold Detached house
BB2 7EX - 315,000
- Freehold Terrace property
BB2 7EX - 1,418,000
- Freehold Detached house
BB2 7EX - 481,000
- Freehold Detached bungalow
BB2 7EX - 721,000
- Freehold Detached house
