SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CH3 8DR' order by fulladdress
CH3 8DR - 528,000
- Leasehold Detached house
CH3 8DR - 291,000
- Freehold Semi-detached house
CH3 8DR - 318,000
- Leasehold Semi-detached house
CH3 8DR - 331,000
- Leasehold Semi-detached house
CH3 8DR - 232,000
- Semi-detached house
CH3 8DR - 395,000
- Leasehold Detached house
CH3 8DR - 236,000
- Semi-detached house
CH3 8DR - 347,000
- Leasehold Semi-detached house
CH3 8DR - 316,000
- Leasehold Semi-detached house
CH3 8DR - 201,000
- Freehold Semi-detached house
CH3 8DR - 317,000
- Freehold Semi-detached house
CH3 8DR - 209,000
- Semi-detached house
CH3 8DR - 535,000
- Freehold Detached house
CH3 8DR - 219,000
- Leasehold Semi-detached house
CH3 8DR - 440,000
- Freehold Detached house
CH3 8DR - 202,000
- Leasehold Semi-detached property
CH3 8DR - 321,000
- Leasehold Semi-detached house
CH3 8DR - 211,000
- Feudal Semi-detached house
CH3 8DR - 311,000
- Leasehold Semi-detached house
CH3 8DR - 203,000
- Leasehold Semi-detached house
CH3 8DR - 313,000
- Leasehold Semi-detached house
CH3 8DR - 276,000
- Freehold Semi-detached house
CH3 8DR - 281,000
- Leasehold Semi-detached house
CH3 8DR - 288,000
- Leasehold Semi-detached house
CH3 8DR - 287,000
- Freehold Semi-detached house
CH3 8DR - 267,000
- Leasehold Semi-detached house
CH3 8DR - 338,000
- Leasehold Semi-detached house
CH3 8DR - 341,000
- Leasehold Semi-detached house
CH3 8DR - 331,000
- Freehold Semi-detached house
CH3 8DR - 589,000
- Leasehold Detached house
CH3 8DR - 539,000
- Freehold Detached house
CH3 8DR - 214,000
- Leasehold Mid terrace house
CH3 8DR - 596,000
- Freehold Detached house
CH3 8DR - 591,000
- Leasehold Detached house
CH3 8DR - 627,000
- Freehold Detached house
CH3 8DR - 577,000
- Freehold Detached house
CH3 8DR - 203,000
- Freehold Mid terrace house
CH3 8DR - 511,000
- Leasehold Detached house
CH3 8DR - 464,000
- Leasehold Detached house
CH3 8DR - 457,000
- Leasehold Detached house
CH3 8DR - 267,000
- Semi-detached house
CH3 8DR - 493,000
- Freehold Detached house
CH3 8DR - 268,000
- Semi-detached house
CH3 8DR - 466,000
- Leasehold Detached house
CH3 8DR - 274,000
- Leasehold Semi-detached house
CH3 8DR - 267,000
- Freehold Semi-detached house
CH3 8DR - 498,000
- Freehold Detached house
