SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG21 3BY' order by fulladdress
RG21 3BY - 367,000
- Freehold End terrace house
RG21 3BY - 220,000
- Leasehold Flat/Maisonette
RG21 3BY - 80,000
- Leasehold Purpose built flat
RG21 3BY - 133,000
- Leasehold Purpose built flat
RG21 3BY - 93,000
- Leasehold Purpose built flat
RG21 3BY - 149,000
- Leasehold Purpose built flat
RG21 3BY - 181,000
- Leasehold Purpose built flat
RG21 3BY - 99,000
- Feudal Purpose built flat
RG21 3BY - 157,000
- Leasehold Purpose built flat
RG21 3BY - 115,000
- Leasehold Purpose built flat
RG21 3BY - 83,000
- Leasehold Flat/Maisonette
RG21 3BY - 367,000
- Freehold Terrace property
RG21 3BY - 86,000
- Leasehold Purpose built flat
RG21 3BY - 189,000
- Leasehold Purpose built flat
RG21 3BY - 143,000
- Leasehold Purpose built flat
RG21 3BY - 191,000
- Leasehold Purpose built flat
RG21 3BY - 161,000
- Leasehold Flat/Maisonette
RG21 3BY - 365,000
- Freehold Mid terrace house
RG21 3BY - 174,000
- Leasehold Purpose built flat
RG21 3BY - 220,000
- Leasehold Purpose built flat
RG21 3BY - 120,000
- Leasehold Flat/Maisonette
RG21 3BY - 197,000
- Leasehold Purpose built flat
RG21 3BY - 88,000
- Leasehold Flat/Maisonette
RG21 3BY - 112,000
- Leasehold Purpose built flat
RG21 3BY - 378,000
- Freehold End terrace house
RG21 3BY - 140,000
- Leasehold Purpose built flat
RG21 3BY - 103,000
- Leasehold Purpose built flat
RG21 3BY - 362,000
- Freehold Semi-detached house
RG21 3BY - 349,000
- Freehold Semi-detached house
RG21 3BY - 392,000
- Freehold End terrace property
RG21 3BY - 372,000
- Freehold End terrace house
RG21 3BY - 386,000
- Freehold Mid terrace house
RG21 3BY - 377,000
- Freehold Mid terrace house
RG21 3BY - 383,000
- Freehold End terrace house
RG21 3BY - 344,000
- Leasehold Flat/Maisonette
RG21 3BY - 164,000
- Leasehold Flat/Maisonette
RG21 3BY - 232,000
- Leasehold Purpose built flat
RG21 3BY - 173,000
- Leasehold Purpose built flat
RG21 3BY - 240,000
- Leasehold Flat/Maisonette
RG21 3BY - 161,000
- Leasehold Flat/Maisonette
RG21 3BY - 164,000
- Leasehold Purpose built flat
RG21 3BY - 366,000
- Freehold Mid terrace house
RG21 3BY - 169,000
- Leasehold Flat/Maisonette
RG21 3BY - 183,000
- Leasehold Flat/Maisonette
RG21 3BY - 165,000
- Leasehold Flat/Maisonette
RG21 3BY - 167,000
- Leasehold Purpose built flat
RG21 3BY - 391,000
- Freehold Mid terrace house
RG21 3BY - 396,000
- Freehold Mid terrace house
RG21 3BY - 390,000
- Freehold Mid terrace house
RG21 3BY - 375,000
- Freehold Mid terrace house
RG21 3BY - 406,000
- Freehold Mid terrace house
RG21 3BY - 367,000
- Freehold Terrace property
RG21 3BY - 400,000
- Freehold Mid terrace house
RG21 3BY - 193,000
- Leasehold Flat/Maisonette
RG21 3BY - 206,000
- Leasehold Flat/Maisonette
RG21 3BY - 206,000
- Leasehold Purpose built flat
RG21 3BY - 202,000
- Leasehold Purpose built flat
RG21 3BY - 318,000
- Freehold Semi-detached house
RG21 3BY - 368,000
- Freehold End terrace house
RG21 3BY - 327,000
- Feudal Purpose built flat
RG21 3BY - 207,000
- Leasehold Purpose built flat
RG21 3BY - 204,000
- Leasehold Purpose built flat
RG21 3BY - 197,000
- Leasehold Purpose built flat
RG21 3BY - 220,000
- Leasehold Purpose built flat