SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG12 7WR' order by fulladdress
RG12 7WR - 419,000
- Freehold End terrace house
RG12 7WR - 491,000
- Freehold Terrace property
RG12 7WR - 326,000
- Freehold Mid terrace bungalow
RG12 7WR - 497,000
- Freehold Terrace property
RG12 7WR - 349,000
- Freehold Detached bungalow
RG12 7WR - 448,000
- Freehold Terrace property
RG12 7WR - 315,000
- Freehold Mid terrace bungalow
RG12 7WR - 522,000
- Freehold End terrace house
RG12 7WR - 422,000
- Freehold Mid terrace house
RG12 7WR - 324,000
- Leasehold Mid terrace bungalow
RG12 7WR - 452,000
- Freehold Mid terrace house
RG12 7WR - 377,000
- Leasehold Terrace property
RG12 7WR - 419,000
- Leasehold Mid terrace house
RG12 7WR - 426,000
- Freehold Terrace property
RG12 7WR - 421,000
- Leasehold Mid terrace house
RG12 7WR - 458,000
- Leasehold End terrace house
RG12 7WR - 460,000
- Freehold End terrace house
RG12 7WR - 415,000
- Freehold End terrace house
RG12 7WR - 422,000
- Freehold Mid terrace house
RG12 7WR - 327,000
- Freehold Bungalow property
RG12 7WR - 473,000
- Freehold Terrace property
RG12 7WR - 463,000
- Freehold Mid terrace house
RG12 7WR - 433,000
- Freehold Mid terrace house
RG12 7WR - 409,000
- Freehold Mid terrace house
RG12 7WR - 414,000
- Freehold Mid terrace house
RG12 7WR - 401,000
- Freehold Terrace property
RG12 7WR - 639,000
- Freehold Detached house
RG12 7WR - 588,000
- Freehold Detached house
RG12 7WR - 200,000
- Share of freehold Flat/Maisonette
RG12 7WR - 652,000
- Freehold Detached house
RG12 7WR - 633,000
- Freehold Detached house
RG12 7WR - 508,000
- Freehold End terrace house
RG12 7WR - 205,000
- Leasehold Purpose built flat
RG12 7WR - 205,000
- Leasehold Purpose built flat
RG12 7WR - 223,000
- Share of freehold Purpose built flat
RG12 7WR - 201,000
- Leasehold Flat/Maisonette
RG12 7WR - 207,000
- Leasehold Purpose built flat
RG12 7WR - 443,000
- Freehold Mid terrace house
RG12 7WR - 200,000
- Leasehold Purpose built flat
RG12 7WR - 422,000
- Freehold Mid terrace house
RG12 7WR - 422,000
- Freehold Mid terrace house
RG12 7WR - 213,000
- Leasehold Purpose built flat
RG12 7WR - 209,000
- Leasehold Flat/Maisonette
RG12 7WR - 205,000
- Leasehold Converted flat
RG12 7WR - 218,000
- Share of freehold Purpose built flat
RG12 7WR - 204,000
- Leasehold Flat/Maisonette
RG12 7WR - 208,000
- Leasehold Flat/Maisonette
RG12 7WR - 200,000
- Leasehold Purpose built flat
RG12 7WR - 193,000
- Leasehold Purpose built flat
RG12 7WR - 199,000
- Leasehold Purpose built flat
RG12 7WR - 201,000
- Leasehold Purpose built flat