SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BR3 6PY' order by fulladdress
BR3 6PY - 1,307,000
- Freehold Detached house
BR3 6PY - 851,000
- Freehold Semi-detached house
BR3 6PY - 866,000
- Freehold Semi-detached house
BR3 6PY - 828,000
- Freehold Semi-detached house
BR3 6PY - 1,238,000
- Freehold Flat/Maisonette
BR3 6PY - 1,357,000
- Freehold Detached house
BR3 6PY - 569,000
- Leasehold Converted flat
BR3 6PY - 437,000
- Leasehold Converted flat
BR3 6PY - 542,000
- Leasehold Converted flat
BR3 6PY - 532,000
- Leasehold Flat/Maisonette
BR3 6PY - 544,000
- Leasehold Converted flat
BR3 6PY - 537,000
- Freehold Converted flat
BR3 6PY - 984,000
- Freehold End terrace house
BR3 6PY - 992,000
- Freehold End terrace house
BR3 6PY - 991,000
- Freehold Mid terrace house
BR3 6PY - 990,000
- Freehold Mid terrace house
BR3 6PY - 999,000
- Freehold End terrace house
BR3 6PY - 520,000
- Leasehold Flat/Maisonette
BR3 6PY - 1,096,000
- Freehold Semi-detached house
BR3 6PY - 1,020,000
- Freehold Semi-detached house
BR3 6PY - 1,178,000
- Freehold Semi-detached house
BR3 6PY - 858,000
- Freehold Semi-detached house
BR3 6PY - 825,000
- Semi-detached house
BR3 6PY - 1,087,000
- Freehold Semi-detached house
BR3 6PY - 870,000
- Freehold Semi-detached house
BR3 6PY - 670,000
- Freehold Mid terrace house
BR3 6PY - 690,000
- Freehold End terrace house
BR3 6PY - 704,000
- Freehold Mid terrace house
BR3 6PY - 1,223,000
- Freehold Detached house
BR3 6PY - 704,000
- Freehold End terrace house
BR3 6PY - 629,000
- Freehold Mid terrace house
BR3 6PY - 597,000
- Freehold Mid terrace house
BR3 6PY - 657,000
- Freehold End terrace house
BR3 6PY - 1,397,000
- Freehold Detached property
BR3 6PY - 1,300,000
- Freehold Detached house
BR3 6PY - 1,734,000
- Freehold Detached house
BR3 6PY - 1,120,000
- Freehold Detached house
BR3 6PY - 1,494,000
- Freehold Detached house
BR3 6PY - 1,462,000
- Freehold Detached house
BR3 6PY - 312,000
- Leasehold Flat/Maisonette
BR3 6PY - 549,000
- Leasehold Purpose built flat
BR3 6PY - 382,000
- Leasehold Purpose built flat
BR3 6PY - 292,000
- Leasehold Flat/Maisonette
BR3 6PY - 312,000
- Leasehold Purpose built flat
BR3 6PY - 310,000
- Leasehold Flat/Maisonette
BR3 6PY - 590,000
- Leasehold Flat/Maisonette
BR3 6PY - 308,000
- Leasehold Purpose built flat
BR3 6PY - 705,000
- Leasehold Flat/Maisonette
BR3 6PY - 299,000
- Leasehold Purpose built flat
BR3 6PY - 568,000
- Leasehold Flat/Maisonette
BR3 6PY - 370,000
- Leasehold Flat/Maisonette
BR3 6PY - 290,000
- Leasehold Purpose built flat
BR3 6PY - 305,000
- Leasehold Purpose built flat
BR3 6PY - 295,000
- Leasehold Flat/Maisonette
