select * from PRODUCTDETAIL where upper(CategoryName) like '%PREMIUM RANGE%' and upper(SubCategoryName) like '%DOOR KNOBS%' and upper(SSCategoryName) like '%TRADITIONAL DOOR KNOBS%'
Company Profile
Group Accreditation Achievements
Products Catalogue
Packaging
Special Promotional Offers
News & Events
Window Fashions
Product Care Instructions
Selecting your furniture
Finishes Key
International Distribution and
Sales Agencies Partnerships
Query Form / Online Query
Download Catalogue
Request for Catalogue
Director’s Desk
Contact us
Enter Ref. Code or Product Name
Your Name
Your Email
Traditional Door Knobs
Page
[1]
Georgian Mortice Knob
Ref.
10-1009
Enlarge
Victorian Mortice Knob
Ref.
10-1017
Enlarge
Queen Anne Knob
Ref.
10-1032
Enlarge
Regency Mortice Knob
Ref.
10-1040
Enlarge
Enlarge
