SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.originalprice, thumb FROM artlist WHERE Discontinued is null AND (medium = 'Paintings - Acrylic') AND (catagory = 'Fantasy') AND ((search LIKE '%' + 'atlantis' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Fantasy/AtlantisMeeting of the MindsBrothers HildebrandtPaintings - Acrylic$4000
Fantasy/AtlantisEkedadhimBrothers HildebrandtPaintings - Acrylic$5000
Fantasy/AtlantisNaran & Kaleaha QuestBrothers HildebrandtPaintings - Acrylic$5000
Fantasy/AtlantisKaleaha - UNUSEDBrothers HildebrandtPaintings - Acrylic$6000
Fantasy/AtlantisAtlantisGreg HildebrandtPaintings - Acrylic$12000
Fantasy/AtlantisBattle with the Red Sea BeastBrothers HildebrandtPaintings - Acrylic$15000
Fantasy/Atlantis   Nivick and the FairiesBrothers HildebrandtPaintings - Acrylic$3500
Fantasy/Atlantis   The MammothsBrothers HildebrandtPaintings - Acrylic$3500
Fantasy/Atlantis   Black Beast and NaranBrothers HildebrandtPaintings - Acrylic$5000
Fantasy/Atlantis   NivickGreg HildebrandtPaintings - Acrylic$5000
Fantasy/Atlantis   Aerial of SolanBrothers HildebrandtPaintings - Acrylic$6000
Fantasy/Atlantis   Atlantis City LightsBrothers HildebrandtPaintings - Acrylic$6000
Fantasy/Atlantis   Kaleaha & the HeadaBrothers HildebrandtPaintings - Acrylic$6000
Fantasy/Atlantis   Atlantis coverBrothers HildebrandtPaintings - Acrylic$8000
Fantasy/AtlantisAtlantis VolcanoBrothers HildebrandtPaintings - Acrylic$3000
Fantasy/AtlantisFire Over the ValleyBrothers HildebrandtPaintings - Acrylic$3500
Fantasy/AtlantisDanger in the SkyBrothers HildebrandtPaintings - Acrylic$6000