SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG24 9TX' order by fulladdress
RG24 9TX - 192,000
- Leasehold Purpose built flat
RG24 9TX - 213,000
- Leasehold Purpose built flat
RG24 9TX - 201,000
- Leasehold Purpose built flat
RG24 9TX - 167,000
- Leasehold Purpose built flat
RG24 9TX - 200,000
- Leasehold Purpose built flat
RG24 9TX - 196,000
- Leasehold Purpose built flat
RG24 9TX - 176,000
- Leasehold Purpose built flat
RG24 9TX - 419,000
- Freehold Terrace property
RG24 9TX - 202,000
- Leasehold Purpose built flat
RG24 9TX - 397,000
- Freehold Mid terrace house
RG24 9TX - 159,000
- Leasehold Flat/Maisonette
RG24 9TX - 156,000
- Leasehold Purpose built flat
RG24 9TX - 390,000
- Freehold Terrace property
RG24 9TX - 207,000
- Leasehold Purpose built flat
RG24 9TX - 385,000
- Freehold Mid terrace house
RG24 9TX - 199,000
- Leasehold Flat/Maisonette
RG24 9TX - 375,000
- Freehold Mid terrace house
RG24 9TX - 207,000
- Leasehold Purpose built flat
RG24 9TX - 417,000
- Freehold End terrace house
RG24 9TX - 206,000
- Leasehold Purpose built flat
RG24 9TX - 393,000
- Freehold End terrace house
RG24 9TX - 204,000
- Leasehold Purpose built flat
RG24 9TX - 140,000
- Leasehold Purpose built flat
RG24 9TX - 168,000
- Leasehold Purpose built flat
RG24 9TX - 387,000
- Freehold Mid terrace house
RG24 9TX - 132,000
- Leasehold Flat/Maisonette
RG24 9TX - 376,000
- Freehold Mid terrace house
RG24 9TX - 195,000
- Leasehold Purpose built flat
RG24 9TX - 378,000
- Freehold Mid terrace house
RG24 9TX - 138,000
- Leasehold Purpose built flat
RG24 9TX - 381,000
- Freehold Mid terrace house
RG24 9TX - 198,000
- Leasehold Purpose built flat
RG24 9TX - 386,000
- Freehold Mid terrace house
RG24 9TX - 385,000
- Freehold End terrace house
RG24 9TX - 376,000
- Freehold Terrace property
RG24 9TX - 384,000
- Freehold End terrace house
RG24 9TX - 383,000
- Freehold Mid terrace house
RG24 9TX - 377,000
- Freehold Terrace property
RG24 9TX - 203,000
- Leasehold Flat/Maisonette
RG24 9TX - 365,000
- Freehold Mid terrace house
RG24 9TX - 330,000
- Freehold Mid terrace house
RG24 9TX - 366,000
- Freehold Mid terrace house
RG24 9TX - 329,000
- Freehold Terrace property
RG24 9TX - 372,000
- Freehold Terrace property
RG24 9TX - 329,000
- Freehold Terrace property
RG24 9TX - 377,000
- Freehold End terrace house
RG24 9TX - 466,000
- Freehold Detached house
RG24 9TX - 204,000
- Leasehold Purpose built flat
RG24 9TX - 385,000
- Freehold Terrace property
RG24 9TX - 377,000
- Freehold Mid terrace house
RG24 9TX - 385,000
- Freehold End terrace house
RG24 9TX - 389,000
- Freehold End terrace house
RG24 9TX - 382,000
- Freehold Mid terrace house
RG24 9TX - 198,000
- Leasehold Purpose built flat
RG24 9TX - 378,000
- Freehold Mid terrace house
RG24 9TX - 400,000
- Freehold Semi-detached house
RG24 9TX - 462,000
- Freehold Detached house
RG24 9TX - 452,000
- Freehold Detached house
RG24 9TX - 437,000
- Freehold Detached house
RG24 9TX - 202,000
- Leasehold Purpose built flat
RG24 9TX - 462,000
- Freehold Detached house
RG24 9TX - 199,000
- Leasehold Purpose built flat