CALL US: 8 08535 32142
   Welcome Mr. Smith! Home    Account Info    Your Cart
Search here:

GO
Advanced Search
   Your location: HOME » Specials
  RUSSIAN
   
Exclusive Collectable Dolls
Traditional (5 pieces) Dolls
Traditional (7 pieces) Dolls
Custom Dolls
  TOPEDNEWS3
  TOPEDNEWS3
  TOPEDNEWS3
  RUSSIAN LAQUER BOXES
  RUSSIAN SANTAS
  EASTER EGGS
  CARVED WOODEN TOYS
  LAQUER SOUVENIRS
  PAINTINGS
  GIFT CERTIFICATES
  NODDING DOLLS
 
 
Russian Folk Tale of Hen the Ryaba5 of 5 Stars!

...

All Reviews...
  
 
History and Origin of the Tradition of Easter Egg
The glorious holiday of Easter is rich with meaning, history and traditions. One of the attributes of every Easter celebration, both Orthodox and Catholic, is Easter Egg. Egg played a v...
  
 
• Click Here To Order!
• GiftCertificates FAQ
Gift Certificates will make the gift giving even more rewording.

  
 
Visa
Master Card
 
 

Downloadable PDF catalogue

  
 
Download Our Macromedia Flash Presentation for FREE!
 
Features included:
+ Russian Tales in MP3 (9)
+ Slideshow
+ Online/Offline Catalogue
+ Online Login Form
+ Online/Offline Shopping Cart
+ Online/Offline Request a
   Quote Form
+ Online/Offline Contact Us
   Form, Fax Form
 
  Click here to see our new products  
  Click here to see our toady’s specials  
   search: avdanced search      
     tell a friend abot us:
      
      Get our free newsletter! 
ORDER CUSTOM
DOLL DESIGN:		    SEASONAL CELEBRATIONS
   • First Communion Gifts
   • Confirmation Gifts
   • Mother's Day Gifts
   • Easter (Orthodox Easter)		    SPECIAL OCCASIONS
   • New Baby Gifts
   • Wedding Gifts
   • Anniversary Gifts
   • Birthday Gifts
   • Graduation Gifts		    FAMILY AND FRIENDS
   • Gifts for Babies
   • Gifts for Kids
   • Gifts for Him
   • Gifts for Her
   • Gifts for Grandparents
 You are here: HOME » Specials
Get Them While They're Hot!
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-9, 9' at line 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

[TEP STOP]