SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='S65 4RE' order by fulladdress
S65 4RE - 164,000
- Freehold End terrace house
S65 4RE - 115,000
- Leasehold Purpose built flat
S65 4RE - 121,000
- Leasehold Purpose built flat
S65 4RE - 121,000
- Leasehold Flat/Maisonette
S65 4RE - 184,000
- Freehold Mid terrace house
S65 4RE - 146,000
- Leasehold Flat/Maisonette
S65 4RE - 170,000
- Freehold Mid terrace house
S65 4RE - 131,000
- Leasehold Purpose built flat
S65 4RE - 167,000
- Freehold Mid terrace house
S65 4RE - 119,000
- Leasehold Flat/Maisonette
S65 4RE - 122,000
- Leasehold Flat/Maisonette
S65 4RE - 183,000
- Freehold End terrace house
S65 4RE - 349,000
- Freehold Detached bungalow
S65 4RE - 353,000
- Freehold Detached bungalow
S65 4RE - 338,000
- Freehold Detached bungalow
S65 4RE - 335,000
- Freehold Detached house
S65 4RE - 378,000
- Freehold Detached property
S65 4RE - 328,000
- Freehold Detached house
S65 4RE - 161,000
- Freehold Terrace property
S65 4RE - 387,000
- Freehold Detached property
S65 4RE - 401,000
- Freehold Detached house
S65 4RE - 412,000
- Freehold Detached property
S65 4RE - 393,000
- Freehold Detached property
S65 4RE - 374,000
- Freehold Detached property
S65 4RE - 386,000
- Freehold Detached house
S65 4RE - 377,000
- Freehold Detached property
S65 4RE - 315,000
- Freehold Detached house
S65 4RE - 349,000
- Freehold Detached house
S65 4RE - 379,000
- Freehold Detached property
S65 4RE - 119,000
- Leasehold Flat/Maisonette
S65 4RE - 389,000
- Freehold Detached house
S65 4RE - 375,000
- Freehold Detached house
S65 4RE - 347,000
- Freehold Detached house
S65 4RE - 359,000
- Freehold Detached house
S65 4RE - 360,000
- Freehold Detached house
S65 4RE - 368,000
- Freehold Detached property
S65 4RE - 158,000
- Freehold Mid terrace house
S65 4RE - 379,000
- Freehold Detached house
S65 4RE - 377,000
- Freehold Detached house
S65 4RE - 362,000
- Freehold Detached house
S65 4RE - 361,000
- Freehold Detached house
S65 4RE - 123,000
- Leasehold Flat/Maisonette
S65 4RE - 118,000
- Leasehold Purpose built flat
S65 4RE - 186,000
- Freehold End terrace house