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 3NA' order by fulladdress
RH1 3NA - 663,000
- Freehold Semi-detached house
RH1 3NA - 576,000
- Freehold Detached house
RH1 3NA - 633,000
- Freehold Detached property
RH1 3NA - 495,000
- Freehold Semi-detached house
RH1 3NA - 593,000
- Freehold Detached house
RH1 3NA - 539,000
- Freehold Semi-detached house
RH1 3NA - 498,000
- Freehold Semi-detached house
RH1 3NA - 490,000
- Freehold Semi-detached house
RH1 3NA - 510,000
- Freehold Semi-detached house
RH1 3NA - 491,000
- Semi-detached house
RH1 3NA - 494,000
- Freehold Semi-detached house
RH1 3NA - 492,000
- Freehold Semi-detached house
RH1 3NA - 503,000
- Freehold Semi-detached house
RH1 3NA - 490,000
- Freehold Semi-detached house
RH1 3NA - 547,000
- Freehold Detached house
RH1 3NA - 652,000
- Freehold Detached house
RH1 3NA - 502,000
- Freehold Semi-detached house
RH1 3NA - 514,000
- Freehold Semi-detached house
RH1 3NA - 485,000
- Semi-detached house
RH1 3NA - 516,000
- Freehold Semi-detached house
RH1 3NA - 498,000
- Freehold Semi-detached house
RH1 3NA - 490,000
- Freehold Semi-detached house
RH1 3NA - 333,000
- Leasehold Purpose built flat
RH1 3NA - 500,000
- Freehold Semi-detached house
RH1 3NA - 302,000
- Leasehold Converted flat
RH1 3NA - 506,000
- Freehold Semi-detached house
RH1 3NA - 612,000
- Freehold Detached property
RH1 3NA - 592,000
- Freehold Detached house
RH1 3NA - 509,000
- Freehold Semi-detached house
RH1 3NA - 488,000
- Freehold Semi-detached house
RH1 3NA - 334,000
- Leasehold Purpose built flat
RH1 3NA - 637,000
- Freehold Detached house
RH1 3NA - 596,000
- Freehold Semi-detached house
RH1 3NA - 493,000
- Freehold Semi-detached property
RH1 3NA - 311,000
- Leasehold Purpose built flat
RH1 3NA - 484,000
- Freehold Semi-detached house
