SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SY1 2PS' order by fulladdress
SY1 2PS - 547,000
- Freehold Detached house
SY1 2PS - 327,000
- Leasehold Semi-detached house
SY1 2PS - 520,000
- Freehold Detached house
SY1 2PS - 205,000
- Leasehold Semi-detached house
SY1 2PS - 530,000
- Freehold Detached house
SY1 2PS - 521,000
- Freehold Detached house
SY1 2PS - 482,000
- Freehold Detached house
SY1 2PS - 502,000
- Freehold Detached property
SY1 2PS - 512,000
- Freehold Detached house
SY1 2PS - 529,000
- Freehold Detached property
SY1 2PS - 237,000
- Semi-detached house
SY1 2PS - 536,000
- Freehold Detached house
SY1 2PS - 240,000
- Semi-detached house
SY1 2PS - 538,000
- Freehold Detached house
SY1 2PS - 335,000
- Semi-detached house
SY1 2PS - 531,000
- Freehold Detached house
SY1 2PS - 335,000
- Semi-detached house
SY1 2PS - 539,000
- Freehold Detached house
SY1 2PS - 527,000
- Freehold Detached house
SY1 2PS - 490,000
- Freehold Detached house
SY1 2PS - 539,000
- Freehold Detached house
SY1 2PS - 477,000
- Freehold Detached house
SY1 2PS - 478,000
- Freehold Detached house
SY1 2PS - 522,000
- Freehold Detached house
SY1 2PS - 513,000
- Freehold Detached house
SY1 2PS - 562,000
- Freehold Detached house
SY1 2PS - 547,000
- Freehold Detached house
SY1 2PS - 542,000
- Freehold Detached house
SY1 2PS - 535,000
- Freehold Detached house
SY1 2PS - 508,000
- Freehold Detached house
SY1 2PS - 495,000
- Freehold Detached property
SY1 2PS - 525,000
- Freehold Detached house
