"Pleasant, efficient. All in all a great experience." Mr SM, Livingston |
  |
||||||||||||||||||||||
|
||||||||||||||||||||||
Since formation in 1997, Letting Solutions
has grown rapidly to become by far the largest residential letting
and property management agency in West Lothian. This has happened
because we put our clients, both tenants and landlords/investors
first. We have wide and longstanding experience of the rental market throughout West Lothian, including the major centres of Livingston, Bathgate and Linlithgow and the smaller communities of West Calder, East Calder, Mid Calder, Whitburn and Armadale. The houses and flats for rent include those in urban areas, as well as in traditional rural communities. We have a particularly large selection of flats for rent in Livingston. We have wide and longstanding experience of the rental market throughout West Lothian, including the major centres of Livingston, Bathgate and Linlithgow and the smaller communities of West Calder, East Calder, Mid Calder, Whitburn and Armadale. The houses and flats for rent include those in urban areas, as well as in traditional rural communities. We have a particularly large selection of flats for rent in Livingston. Letting Solutions was the first dedicated letting agency in West Lothian. Established in 1997, we have grown to be the biggest and most experienced letting agency in the area, although we now cover some other areas of Scotland too. If you're a tenant we offer: • special deals If you're a landlord we offer: • unmatched property care to maximise your investment and minimise risk For clients from Poland we provide free translation services and a drop-in "surgery" staffed by our expert Polish staff. As a client of Letting Solutions – whether tenant or landlord/investor - you don't pay us a penny in fees until we have delivered the service requested. There are no up front fees. For the convenience and security of our tenants and landlords we offer a 7 day manned emergency service, together with extensive normal business hours. Evening, Saturday and Sunday viewing of property is available routinely. Our custom designed business premises in Livingston Village have plenty free parking. We have wide and longstanding experience of the rental market throughout West Lothian, including the major centres of Livingston, Bathgate and Linlithgow and the smaller communities of Broxburn, West Calder, East Calder, Mid Calder, Whitburn and Armadale. One of our clients recently said "From start to finish excellent service". We believe this sums up what we aim to achieve.
|
| - Latest News
- |
<% 'sqlquery = "Select top 5, * FROM xfile.txt " 'sqlquery = "SELECT top 50, * FROM xfile.txt " ' SQL query had to be amended because the top 5 properties have to have thumbs 'sqlquery = "SELECT * FROM xfile.txt WHERE PropertyID = 'P2380' OR PropertyID = 'P2524' OR PropertyID = 'UIRP3293' OR PropertyID = 'UIRP3288' OR PropertyID = 'UIRP3286' OR PropertyID = 'P3001' OR PropertyID = 'P2429' OR PropertyID = 'UIRP3326' OR PropertyID = 'P3260'"' used when there are certain properties which need to be displayed. 'sqlquery = "SELECT * FROM xfile.txt WHERE PropertyID = 'UIRP3550' OR PropertyID = 'UIRP3614' OR PropertyID = 'UIRP3595' OR PropertyID = 'UIRP3431' OR PropertyID = 'P2807' OR PropertyID = 'UIRP3404' OR PropertyID = 'P3180' OR PropertyID = 'UIRP3282' OR PropertyID = 'UIRP3474' OR PropertyID = 'P2264' OR PropertyID = 'P1332' OR PropertyID = 'UIRP3532' OR PropertyID = 'P3222' OR PropertyID = 'P2112' OR PropertyID = 'UIRP3596' OR PropertyID = 'P1203' OR PropertyID = 'UIRP3512' OR PropertyID = 'P1755' OR PropertyID = 'UIRP3318' OR PropertyID = 'P2645' OR PropertyID = 'UIRP3604' OR PropertyID = 'UIRP3661' OR PropertyID = 'P2112' OR PropertyID = 'P3532' OR PropertyID = 'P1199' OR PropertyID = 'P2970' OR PropertyID = 'P1593' OR PropertyID = 'P2811' OR PropertyID = 'P2361' OR PropertyID = 'P3226' OR PropertyID = 'P2664'" ' used when there are certain properties which need to be displayed. 'new property list started on 2nd September 2009 sqlquery = "SELECT * FROM xfile.txt WHERE PropertyID = 'P2999' OR PropertyID = 'P3108' OR PropertyID = 'P2543' OR PropertyID = 'P1315' OR PropertyID = 'UIRP3850' OR PropertyID = 'P2540' " 'Set MyFSO = CreateObject("Scripting.FileSystemObject") 'if MyFSO.FileExists("D:\cproot\cp_public\clients\lettingsol\winman\xfile.txt")=true then ' Set MyFile = MyFSO.OpenTextFile("D:\cproot\cp_public\clients\lettingsol\winman\xfile.txt", 1) ' xfiletxt = MyFile.ReadAll ' Set MyFSO = Nothing ' MyFile.Close ' Set MyFile = Nothing 'else ' xfiletxt = "Empty" Set oRSp = Server.CreateObject("ADODB.recordset") oRSp.CursorLocation = 3 CONN_STRING = "DSN=letsol;UID=;Password=;" oRSp.open sqlquery,CONN_STRING fred = oRSp.RecordCount if fred > 0 then oRSp.MoveFirst %>
|
|||
<%
imageFound = 0 'counter used for displaying featured properties which has thumbnails
Do While Not oRSp.EOF
'only display 5 featured properties if they have thumbnails
if ImageExists("tLIVING_"& oRSp.Fields("propertyid")& ".jpg") AND imageFound < 7 then
imageFound = imageFound + 1
tempPrice = oRSp.Fields("price")
' the following adds commas into the price to make it readable upto 7 digits ie. 1,000 to 1,000,000
if len(tempPrice) < 4 then
formattedPrice = tempPrice
end if
if len(tempPrice) = 4 then
formattedPrice = Left(tempPrice,1) & "," & Right(tempPrice,3)
end if
if len(tempPrice) = 5 then
formattedPrice = Left(tempPrice,2) & "," & Right(tempPrice,3)
end if
if len(tempPrice) = 6 then
formattedPrice = Left(tempPrice,3) & "," & Right(tempPrice,3)
end if
if len(tempPrice) = 7 then
formattedPrice = Left(tempPrice,1) & "," & Mid(tempPrice,2,3) & "," & Right(tempPrice,3)
end if
'response.write(ImageExists("tBRANCH_"& oRSp.Fields("propertyid")& ".jpg"))
%>
|
| View Borthwick Close eTour |
