SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BR1 3HP' order by fulladdress
BR1 3HP - 850,000
- Freehold Converted flat
BR1 3HP - 338,000
- Leasehold Converted flat
BR1 3HP - 328,000
- Leasehold Converted flat
BR1 3HP - 642,000
- Freehold Semi-detached house
BR1 3HP - 574,000
- Freehold Semi-detached house
BR1 3HP - 624,000
- Semi-detached house
BR1 3HP - 614,000
- Freehold Terrace property
BR1 3HP - 591,000
- Freehold Mid terrace house
BR1 3HP - 731,000
- Leasehold Converted flat
BR1 3HP - 306,000
- Leasehold Converted flat
BR1 3HP - 475,000
- Leasehold Converted flat
BR1 3HP - 1,328,000
- Freehold Semi-detached house
BR1 3HP - 573,000
- Freehold Semi-detached house
BR1 3HP - 939,000
- Freehold Semi-detached house
BR1 3HP - 408,000
- Leasehold Converted flat
BR1 3HP - 324,000
- Leasehold Converted flat
BR1 3HP - 859,000
- Freehold End terrace house
BR1 3HP - 495,000
- Freehold Flat/Maisonette
BR1 3HP - 883,000
- Freehold Mid terrace house
BR1 3HP - 806,000
- Freehold Mid terrace house
BR1 3HP - 869,000
- Freehold Mid terrace house
BR1 3HP - 856,000
- Freehold Mid terrace house
BR1 3HP - 907,000
- Freehold Terrace property
BR1 3HP - 390,000
- Share of freehold Converted flat
BR1 3HP - 837,000
- Freehold Mid terrace house
BR1 3HP - 854,000
- Freehold End terrace house
BR1 3HP - 305,000
- Leasehold Flat/Maisonette
BR1 3HP - 321,000
- Leasehold Converted flat
BR1 3HP - 297,000
- Leasehold Flat/Maisonette
BR1 3HP - 335,000
- Leasehold Converted flat
BR1 3HP - 497,000
- Freehold Converted flat
BR1 3HP - 352,000
- Leasehold Purpose built flat
BR1 3HP - 1,025,000
- Freehold Semi-detached house
BR1 3HP - 851,000
- Freehold Terrace property
BR1 3HP - 497,000
- Leasehold Converted flat
BR1 3HP - 338,000
- Leasehold Flat/Maisonette
BR1 3HP - 381,000
- Leasehold Converted flat
BR1 3HP - 452,000
- Leasehold Converted flat
BR1 3HP - 922,000
- Freehold Semi-detached house
BR1 3HP - 842,000
- Freehold Terrace property
BR1 3HP - 466,000
- Leasehold Converted flat
BR1 3HP - 323,000
- Leasehold Converted flat
BR1 3HP - 876,000
- Freehold Semi-detached house
BR1 3HP - 452,000
- Leasehold Purpose built flat
BR1 3HP - 305,000
- Leasehold Converted flat
BR1 3HP - 307,000
- Leasehold Converted flat
BR1 3HP - 311,000
- Leasehold Flat/Maisonette
BR1 3HP - 413,000
- Leasehold Flat/Maisonette
BR1 3HP - 307,000
- Leasehold Converted flat
BR1 3HP - 325,000
- Leasehold Converted flat
BR1 3HP - 410,000
- Leasehold Converted flat
BR1 3HP - 321,000
- Leasehold Converted flat
BR1 3HP - 321,000
- Leasehold Converted flat
BR1 3HP - 401,000
- Leasehold Converted flat
BR1 3HP - 330,000
- Leasehold Converted flat
BR1 3HP - 346,000
- Leasehold Converted flat
BR1 3HP - 334,000
- Leasehold Converted flat
BR1 3HP - 316,000
- Leasehold Converted flat
BR1 3HP - 414,000
- Leasehold Purpose built flat
BR1 3HP - 429,000
- Leasehold Converted flat
BR1 3HP - 344,000
- Leasehold Flat/Maisonette
BR1 3HP - 336,000
- Leasehold Converted flat
BR1 3HP - 341,000
- Leasehold Flat/Maisonette
BR1 3HP - 311,000
- Leasehold Converted flat
BR1 3HP - 296,000
- Leasehold Converted flat
BR1 3HP - 332,000
- Leasehold Converted flat
BR1 3HP - 444,000
- Feudal Converted flat
