SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SG4 8YJ' order by fulladdress
SG4 8YJ - 354,000
- Freehold End terrace house
SG4 8YJ - 296,000
- Freehold End terrace house
SG4 8YJ - 335,000
- Freehold Terrace property
SG4 8YJ - 296,000
- Freehold Terrace property
SG4 8YJ - 293,000
- Freehold End terrace house
SG4 8YJ - 375,000
- Freehold End terrace house
SG4 8YJ - 503,000
- Freehold Mid terrace house
SG4 8YJ - 368,000
- Freehold End terrace house
SG4 8YJ - 330,000
- Freehold Mid terrace house
SG4 8YJ - 412,000
- Freehold Semi-detached house
SG4 8YJ - 369,000
- Freehold End terrace house
SG4 8YJ - 367,000
- Freehold End terrace house
SG4 8YJ - 385,000
- Freehold End terrace house
SG4 8YJ - 376,000
- Freehold End terrace house
SG4 8YJ - 443,000
- Freehold Terrace property
SG4 8YJ - 586,000
- Freehold Mid terrace house
SG4 8YJ - 995,000
- Freehold Detached house
SG4 8YJ - 795,000
- Freehold Detached house
SG4 8YJ - 366,000
- Freehold Mid terrace house
SG4 8YJ - 925,000
- Freehold Detached property
SG4 8YJ - 813,000
- Freehold Semi-detached house
SG4 8YJ - 738,000
- Freehold Terrace property
SG4 8YJ - 778,000
- Freehold Detached house
SG4 8YJ - 433,000
- Freehold End terrace house
SG4 8YJ - 373,000
- Freehold Mid terrace house
SG4 8YJ - 364,000
- Freehold Terrace property
SG4 8YJ - 361,000
- Freehold Mid terrace house
SG4 8YJ - 427,000
- Freehold Terrace property
SG4 8YJ - 393,000
- Freehold End terrace house
SG4 8YJ - 442,000
- Freehold End terrace house
SG4 8YJ - 460,000
- Freehold Semi-detached house
SG4 8YJ - 455,000
- Semi-detached house
SG4 8YJ - 397,000
- Freehold Mid terrace house
SG4 8YJ - 394,000
- Freehold Mid terrace house
SG4 8YJ - 451,000
- Freehold End terrace house
SG4 8YJ - 359,000
- Freehold End terrace house
SG4 8YJ - 391,000
- Freehold Mid terrace house
SG4 8YJ - 512,000
- Freehold Semi-detached property
SG4 8YJ - 344,000
- Freehold Mid terrace house
SG4 8YJ - 337,000
- Freehold Terrace property