SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SY5 6JH' order by fulladdress
SY5 6JH - 236,000
- Freehold End terrace house
SY5 6JH - 208,000
- Freehold Mid terrace house
SY5 6JH - 204,000
- Freehold End terrace house
SY5 6JH - 186,000
- Freehold Semi-detached house
SY5 6JH - 314,000
- Freehold End terrace house
SY5 6JH - 240,000
- Freehold End terrace house
SY5 6JH - 295,000
- Freehold Terrace property
SY5 6JH - 231,000
- Freehold Mid terrace house
SY5 6JH - 281,000
- Freehold Mid terrace house
SY5 6JH - 252,000
- Freehold End terrace house
SY5 6JH - 253,000
- Freehold End terrace house
SY5 6JH - 302,000
- Freehold Mid terrace house
SY5 6JH - 249,000
- Freehold Semi-detached house
SY5 6JH - 296,000
- Freehold Mid terrace house
SY5 6JH - 230,000
- Freehold Mid terrace house
SY5 6JH - 313,000
- Freehold Mid terrace house
SY5 6JH - 250,000
- Freehold End terrace house
SY5 6JH - 302,000
- Freehold Terrace property
SY5 6JH - 541,000
- Freehold Detached house
SY5 6JH - 285,000
- Freehold Mid terrace house
SY5 6JH - 484,000
- Freehold Detached house
SY5 6JH - 206,000
- Freehold Mid terrace house
SY5 6JH - 288,000
- Freehold Mid terrace house
SY5 6JH - 389,000
- Freehold Detached house
SY5 6JH - 308,000
- Freehold End terrace house
SY5 6JH - 314,000
- Freehold End terrace house
SY5 6JH - 535,000
- Freehold Detached house
SY5 6JH - 466,000
- Freehold Detached house
SY5 6JH - 286,000
- Freehold Mid terrace house
SY5 6JH - 383,000
- Freehold Detached house
SY5 6JH - 254,000
- Freehold Mid terrace house
SY5 6JH - 308,000
- Freehold Semi-detached house
SY5 6JH - 473,000
- Freehold Detached house
SY5 6JH - 322,000
- Freehold End terrace house
SY5 6JH - 458,000
- Freehold Detached house
SY5 6JH - 276,000
- Freehold Terrace property
SY5 6JH - 377,000
- Freehold Detached house
SY5 6JH - 311,000
- Freehold Semi-detached house
SY5 6JH - 526,000
- Freehold Detached house
SY5 6JH - 304,000
- Freehold Mid terrace house
SY5 6JH - 371,000
- Freehold Detached house
SY5 6JH - 297,000
- Freehold Mid terrace house
SY5 6JH - 382,000
- Freehold Detached house
SY5 6JH - 300,000
- Freehold Mid terrace house
SY5 6JH - 439,000
- Freehold Detached house
SY5 6JH - 336,000
- Freehold Semi-detached house
SY5 6JH - 542,000
- Freehold Detached house
SY5 6JH - 300,000
- Freehold Mid terrace house
SY5 6JH - 470,000
- Freehold Detached house
SY5 6JH - 293,000
- Freehold Mid terrace house
SY5 6JH - 373,000
- Freehold Detached house
SY5 6JH - 240,000
- Freehold End terrace house
SY5 6JH - 303,000
- Freehold Mid terrace house
SY5 6JH - 471,000
- Freehold Detached house
SY5 6JH - 290,000
- Freehold Mid terrace house
SY5 6JH - 539,000
- Freehold Detached house
SY5 6JH - 335,000
- Freehold Semi-detached house
SY5 6JH - 337,000
- Freehold End terrace house
SY5 6JH - 288,000
- Freehold Terrace property
SY5 6JH - 215,000
- Freehold Mid terrace house
SY5 6JH - 281,000
- Freehold Mid terrace house
SY5 6JH - 276,000
- Freehold End terrace house
SY5 6JH - 333,000
- Freehold Detached property
SY5 6JH - 203,000
- Freehold Mid terrace house
