SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BS4 3AR' order by fulladdress
BS4 3AR - 514,000
- Leasehold Mid terrace house
BS4 3AR - 544,000
- Leasehold Mid terrace house
BS4 3AR - 520,000
- Freehold Mid terrace house
BS4 3AR - 502,000
- Leasehold Mid terrace house
BS4 3AR - 513,000
- Leasehold Mid terrace house
BS4 3AR - 339,000
- Leasehold Flat/Maisonette
BS4 3AR - 343,000
- Leasehold Flat/Maisonette
BS4 3AR - 329,000
- Leasehold Purpose built flat
BS4 3AR - 345,000
- Leasehold Purpose built flat
BS4 3AR - 346,000
- Leasehold Purpose built flat
BS4 3AR - 350,000
- Leasehold Flat/Maisonette
BS4 3AR - 330,000
- Leasehold Purpose built flat
BS4 3AR - 534,000
- Leasehold End terrace house
BS4 3AR - 553,000
- Leasehold Mid terrace house
BS4 3AR - 539,000
- Leasehold Mid terrace house
BS4 3AR - 455,000
- Leasehold Mid terrace house
BS4 3AR - 548,000
- Leasehold Mid terrace house
BS4 3AR - 537,000
- Leasehold Mid terrace house
BS4 3AR - 344,000
- Leasehold Purpose built flat
BS4 3AR - 288,000
- Leasehold Flat/Maisonette
BS4 3AR - 343,000
- Leasehold Purpose built flat
BS4 3AR - 287,000
- Leasehold Flat/Maisonette
BS4 3AR - 260,000
- Leasehold Flat/Maisonette
BS4 3AR - 310,000
- Leasehold Purpose built flat
BS4 3AR - 376,000
- Leasehold Purpose built flat
BS4 3AR - 291,000
- Leasehold Flat/Maisonette
BS4 3AR - 297,000
- Leasehold Flat/Maisonette
BS4 3AR - 368,000
- Leasehold Flat/Maisonette
BS4 3AR - 367,000
- Leasehold Purpose built flat
BS4 3AR - 295,000
- Leasehold Flat/Maisonette
BS4 3AR - 293,000
- Leasehold Flat/Maisonette
BS4 3AR - 334,000
- Leasehold Flat/Maisonette
BS4 3AR - 338,000
- Leasehold Flat/Maisonette
BS4 3AR - 256,000
- Leasehold Flat/Maisonette
BS4 3AR - 293,000
- Leasehold Purpose built flat
BS4 3AR - 355,000
- Leasehold Purpose built flat
BS4 3AR - 417,000
- Leasehold Flat/Maisonette
BS4 3AR - 266,000
- Leasehold Purpose built flat
BS4 3AR - 445,000
- Leasehold Flat/Maisonette
BS4 3AR - 490,000
- Leasehold Mid terrace house
BS4 3AR - 493,000
- Leasehold Terrace property
BS4 3AR - 534,000
- Leasehold Mid terrace house
BS4 3AR - 544,000
- Leasehold Mid terrace house
BS4 3AR - 541,000
- Leasehold Mid terrace house
BS4 3AR - 476,000
- Leasehold Purpose built flat
BS4 3AR - 493,000
- Leasehold End terrace house
BS4 3AR - 432,000
- Leasehold Purpose built flat
BS4 3AR - 428,000
- Leasehold Purpose built flat
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 462,000
- Feudal End terrace house
BS4 3AR - 444,000
- Leasehold Mid terrace house
BS4 3AR - 369,000
- Leasehold Mid terrace house
BS4 3AR - 438,000
- Leasehold Mid terrace house
BS4 3AR - 548,000
- Leasehold Mid terrace house
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette
BS4 3AR - 0
- Leasehold Flat/Maisonette