SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG1 6BJ' order by fulladdress
RG1 6BJ - 450,000
- Leasehold Purpose built flat
RG1 6BJ - 432,000
- Leasehold Flat/Maisonette
RG1 6BJ - 411,000
- Leasehold Flat/Maisonette
RG1 6BJ - 399,000
- Leasehold Flat/Maisonette
RG1 6BJ - 333,000
- Leasehold Flat/Maisonette
RG1 6BJ - 399,000
- Leasehold Purpose built flat
RG1 6BJ - 485,000
- Leasehold Flat/Maisonette
RG1 6BJ - 428,000
- Leasehold Purpose built flat
RG1 6BJ - 454,000
- Leasehold Flat/Maisonette
RG1 6BJ - 396,000
- Leasehold Mid terrace house
RG1 6BJ - 469,000
- Leasehold Flat/Maisonette
RG1 6BJ - 372,000
- Leasehold Flat/Maisonette
RG1 6BJ - 392,000
- Leasehold Purpose built flat
RG1 6BJ - 407,000
- Leasehold Flat/Maisonette
RG1 6BJ - 471,000
- Leasehold Flat/Maisonette
RG1 6BJ - 481,000
- Leasehold Purpose built flat
RG1 6BJ - 413,000
- Leasehold Flat/Maisonette
RG1 6BJ - 498,000
- Leasehold Flat/Maisonette
RG1 6BJ - 380,000
- Leasehold Purpose built flat
RG1 6BJ - 365,000
- Leasehold Flat/Maisonette
RG1 6BJ - 320,000
- Share of freehold Flat/Maisonette
RG1 6BJ - 449,000
- Leasehold Flat/Maisonette
RG1 6BJ - 488,000
- Leasehold Purpose built flat
RG1 6BJ - 487,000
- Leasehold Purpose built flat
RG1 6BJ - 366,000
- Leasehold Flat/Maisonette
RG1 6BJ - 426,000
- Leasehold Flat/Maisonette
RG1 6BJ - 402,000
- Leasehold Purpose built flat
