<% Dim Counter Dim oRS1 Set oRS1 = Server.CreateObject("ADODB.Recordset") oRS1.cursorLocation = 3 Dim oRS2 Set oRS2 = Server.CreateObject("ADODB.Recordset") oRS2.cursorLocation = 3 Dim strSQL1 Dim strSQL2 strSQL1 = "SELECT *" strSQL1 = strSQL1 & " FROM qsel_Awards ;" 'strSQL2 = "SELECT *" 'strSQL2 = strSQL2 & " FROM qsel_WebHomePageHeadline ;" ' Response.Write(strSQL1) & "
" 'response.write "
" oRS1.Open strSQL1, "dsn=lrg_awards" 'oRS2.Open strSQL1, "dsn=lrg_awards" %>
LRG Sound and Vision  | Belfast 171/175 Albertbridge Road Belfast BT5 4PS T: 028 9045 1381 E: lrgsoundandvision

Telephone
028 9045 1381
028 9073 2452

Email info@lrgsoundandvision.com


Opening Hours
Mon - Sat
9:30 - 5:00

Find Us

AWARD WINNERS
SEE THE BEST @
LRG SOUND & VISION

Many of the components and systems we stock have been accredited by recieving awards from a range of organisations which highlight outstanding quality and value. Some of theses are listed eblow and throughout the site.

<% Response.write "" Do While NOT oRS1.EOF Response.write "" If oRS1("Logo_FileName") = "lrg-award.jpg" then If IsNull(oRS1("award_NameDescription")) then Response.write "" Else Response.write "" End If Else Response.write "" End If Response.Write "" Response.Write "" oRS1.MoveNext Loop Response.write "
" & oRS1("award_ModelNo") & "
" & oRS1("award_ModelName") & "
" & oRS1("award_NameDescription") & "" & oRS1("award_NameDescription") & "
" & oRS1("award_Text") & "
" & oRS1("PublicationTitle") &", " & oRS1("award_Date-AsDisplayed") & "
" %>

AT LRG Sound & Vision we offer full installation and service for all our products.




Now with AirPlay Technology


Multiroom

Models currently
on show from
BOSE & Yamaha

BOSE Lifestyle 18 II
BOSE Lifestyle 18 II
BOSE Lifestyle 38
BOSE Lifestyle 38
Yamaha MusicCAST systems
Yamaha MusicCAST

Multi-Room, Home Cinema, HI-FI and Service Centre
© Copyright LRG 2009 - 2018 Home | Site Map Web Hosting & Design by truska.com