SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RH1 1TD' order by fulladdress
RH1 1TD - 391,000
- Freehold Mid terrace house
RH1 1TD - 546,000
- Freehold Mid terrace house
RH1 1TD - 293,000
- Leasehold Flat/Maisonette
RH1 1TD - 535,000
- Freehold Mid terrace house
RH1 1TD - 729,000
- Freehold Semi-detached house
RH1 1TD - 482,000
- Freehold End terrace house
RH1 1TD - 630,000
- Freehold Mid terrace house
RH1 1TD - 659,000
- Freehold End terrace house
RH1 1TD - 649,000
- Freehold Mid terrace house
RH1 1TD - 574,000
- Freehold Mid terrace house
RH1 1TD - 649,000
- Freehold Terrace property
RH1 1TD - 617,000
- Freehold Terrace property
RH1 1TD - 629,000
- Freehold Mid terrace house
RH1 1TD - 623,000
- Freehold Mid terrace house
RH1 1TD - 633,000
- Freehold Mid terrace house
RH1 1TD - 559,000
- Freehold Mid terrace house
RH1 1TD - 520,000
- Freehold End terrace house
RH1 1TD - 577,000
- Freehold Mid terrace house
RH1 1TD - 692,000
- Freehold End terrace house
RH1 1TD - 611,000
- Freehold Terrace property
RH1 1TD - 620,000
- Freehold Mid terrace house
RH1 1TD - 320,000
- Leasehold Purpose built flat
RH1 1TD - 631,000
- Freehold Terrace property
RH1 1TD - 629,000
- Freehold Detached house
RH1 1TD - 636,000
- Freehold Mid terrace house
RH1 1TD - 638,000
- Freehold Mid terrace house
RH1 1TD - 469,000
- Freehold Mid terrace house
RH1 1TD - 647,000
- Freehold Terrace property
RH1 1TD - 609,000
- Freehold Semi-detached property
RH1 1TD - 726,000
- Freehold Semi-detached property
RH1 1TD - 617,000
- Freehold Semi-detached house
RH1 1TD - 605,000
- Freehold Semi-detached house
RH1 1TD - 483,000
- Freehold End terrace house
RH1 1TD - 553,000
- Freehold Terrace property
RH1 1TD - 597,000
- Freehold Semi-detached house
RH1 1TD - 272,000
- Leasehold Purpose built flat
RH1 1TD - 300,000
- Leasehold Flat/Maisonette
RH1 1TD - 234,000
- Leasehold Purpose built flat
RH1 1TD - 287,000
- Leasehold Purpose built flat
RH1 1TD - 276,000
- Leasehold Flat/Maisonette
RH1 1TD - 230,000
- Leasehold Purpose built flat
RH1 1TD - 272,000
- Leasehold Purpose built flat
RH1 1TD - 240,000
- Leasehold Flat/Maisonette
RH1 1TD - 286,000
- Leasehold Purpose built flat
RH1 1TD - 283,000
- Leasehold Purpose built flat
RH1 1TD - 274,000
- Leasehold Purpose built flat
RH1 1TD - 277,000
- Leasehold Flat/Maisonette
RH1 1TD - 273,000
- Leasehold Purpose built flat
RH1 1TD - 255,000
- Leasehold Purpose built flat
RH1 1TD - 282,000
- Leasehold Flat/Maisonette
RH1 1TD - 284,000
- Leasehold Purpose built flat
RH1 1TD - 263,000
- Leasehold Flat/Maisonette
RH1 1TD - 272,000
- Leasehold Purpose built flat
RH1 1TD - 297,000
- Leasehold Purpose built flat
RH1 1TD - 277,000
- Leasehold Purpose built flat
RH1 1TD - 251,000
- Leasehold Purpose built flat
RH1 1TD - 237,000
- Leasehold Flat/Maisonette
RH1 1TD - 269,000
- Leasehold Purpose built flat
RH1 1TD - 272,000
- Leasehold Purpose built flat
RH1 1TD - 219,000
- Leasehold Flat/Maisonette
RH1 1TD - 259,000
- Leasehold Purpose built flat
RH1 1TD - 243,000
- Leasehold Flat/Maisonette
RH1 1TD - 282,000
- Leasehold Purpose built flat