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 ((search LIKE '%' + 'Collectibles' +'%') OR (search LIKE '%' + 'DynamicForces' +'%') OR (search LIKE '%' + 'Lithographs' +'%') OR (search LIKE '%' + 'Prints' +'%') OR (search LIKE '%' + 'figurines' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Kid Stuff/PhotorealismUncle Sam - Carnival Prize 1942Greg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup ArtJenniferGreg HildebrandtPaintings - Acrylic$10000
Pinup Art/Pinup ArtOverheatedGreg HildebrandtPaintings - Acrylic$15000
Pinup Art/Pinup ArtMoonlight SerenadeGreg HildebrandtPaintings - Acrylic$18000
Pinup Art/Pinup ArtEye CandyGreg HildebrandtPaintings - Acrylic$20000
Pinup Art/Pinup ArtKeep em FlyingGreg HildebrandtPaintings - Acrylic$20000
Pinup Art/Pinup ArtLove at First Sight - Shelby CobraGreg HildebrandtPaintings - Acrylic$25000
Pinup Art/Pinup ArtLa Dolce VitaGreg HildebrandtPaintings - Acrylic$28000
Pinup Art/Pinup ArtStardust MemoriesGreg HildebrandtPaintings - Acrylic$35000
Tolkien/Commissioned Art   The Ring of GaladrielGreg HildebrandtPaintings - Acrylic$10000
Fantasy/Fantasy   ConfrontationGreg HildebrandtPaintings - Acrylic$1200
Fantasy/Fantasy   Black DeathGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Arabian NightsGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Back Seat BabyGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Ebony and IvoryGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Going My Way?Greg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Rosie the RiveterGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Summer BreezeGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   Time OutGreg HildebrandtPaintings - Acrylic$5000
Pinup Art/Pinup Art   American BombshellGreg HildebrandtPaintings - Acrylic$6000
Pinup Art/Pinup Art   Blonde, White, and BlueGreg HildebrandtPaintings - Acrylic$6500
Pinup Art/Pinup Art   Blue MoonGreg HildebrandtPaintings - Acrylic$8000
Pinup Art/Pinup Art   Science Gone WildGreg HildebrandtPaintings - Acrylic$8000
Pinup Art/Pinup Art   Things Go Better With...Greg HildebrandtPaintings - Acrylic$8000
Pinup Art/Pinup Art   Marilyn Monroe Dream DateGreg HildebrandtPaintings - Acrylic$8500
Pinup Art/Pinup Art   After HoursGreg HildebrandtPaintings - Acrylic$10000
Pinup Art/Pinup Art   Lucky LotusGreg HildebrandtPaintings - Acrylic$10000
Tolkien/Lord of the Rings   Gandalf Visits Bilbo - 2018 CommissionGreg HildebrandtPaintings - Acrylic$10000
Pinup Art/Pinup Art   Give a Lady a Lift?Greg HildebrandtPaintings - Acrylic$15000
Pinup Art/Pinup Art   License to KillGreg HildebrandtPaintings - Acrylic$15000
Pinup Art/Pinup Art   Naked FannyGreg HildebrandtPaintings - Acrylic$15000
Pinup Art/Pinup Art   Shave and a HaircutGreg HildebrandtPaintings - Acrylic$15000
Entertainment/Poster Art   Lake Hopatcong Then and NowGreg HildebrandtPaintings - Acrylic$16500
Pinup Art/Pinup Art   Fill Her UpGreg HildebrandtPaintings - Acrylic$17500
Pinup Art/Pinup Art   Victoria d'EleganceGreg HildebrandtPaintings - Acrylic$18000
Pinup Art/Commissioned Art   You Light Up My LifeGreg HildebrandtPaintings - Acrylic$20000
Pinup Art/Pinup Art   Mad ScienceGreg HildebrandtPaintings - Acrylic$20000
Pinup Art/Pinup Art   Saturday Night SpecialGreg HildebrandtPaintings - Acrylic$20000
Pinup Art/Pinup Art   Keys to Your HeartGreg HildebrandtPaintings - Acrylic$22000
Pinup Art/Pinup Art   Round 15Greg HildebrandtPaintings - Acrylic$25000
Pinup Art/Pinup Art   La Patrona - WWII Tiger Cat Nose ConeGreg HildebrandtPaintings - Acrylic$28000
Kid Stuff/Photorealism   Bedtime StoryGreg HildebrandtPaintings - Acrylic$35000
Pinup Art/Pinup Art   Dangerous Slopes Greg HildebrandtPaintings - Acrylic$35000
Pinup Art/Pinup Art   Whisper #2Greg HildebrandtPaintings - Acrylic$35000
Kid Stuff/Photorealism   Said the Spider to the FlyGreg HildebrandtPaintings - Acrylic$40000
Kid Stuff/PhotorealismThe Doody BrothersGreg HildebrandtPaintings - Acrylic$40000