Filter By
     
SELECT * FROM ipa_wp_posts LEFT JOIN ipa_wp_postmeta AS pm ON( ipa_wp_posts.ID = pm.post_id AND pm.meta_key = 'pet_listings_listing_type' ) LEFT JOIN ipa_wp_postmeta AS pm1 ON( ipa_wp_posts.ID = pm1.post_id AND pm1.meta_key = 'pet_listings_date_lost_found' ) LEFT JOIN ipa_wp_postmeta AS pm2 ON( ipa_wp_posts.ID = pm2.post_id AND pm2.meta_key = 'pet_listings_listing_status' ) LEFT JOIN ipa_wp_postmeta AS pm3 ON( ipa_wp_posts.ID = pm3.post_id AND pm3.meta_key = 'pet_listings_shelterid' ) WHERE ipa_wp_posts.post_status = 'publish' AND ipa_wp_posts.post_type = 'pet_listings' AND pm.meta_value = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Lost: 4/14/2015
ID: 331
Name: Unknown
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
He was found roaming around my backyard, I live in Gilbert and i asked around my neighborhood but no one had seen the cat before! it is so so sweet and i hope it finds its home.
Des Moines - West
Lost: 4/14/2015
ID: 330
Name: Bentley
Type: Dog
Color: White with light tan
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
He was in our fenced yard. He went missing between 3:00 and 3:15 in the afternoon. He is very energetic and friendly.
Ankeny
Lost: 4/14/2015
ID: 329
Name: Batman
Type: Dog
Color: Tan
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young
last seen at the Ankeny dog park, was told he was taken by a couple and they were going to see if he had a chip..... he does not.... He is a Morkie (Maltese and Yorkie Mix), His hair is a bit longer now, than in this picture.
Cambridge
Lost: 4/14/2015
ID: 319
Name: Sammie
Type: Dog
Color: black
Breed: Maltese
Gender: Female
Fixed: Unknown
Age: Adult
4 am Cambridge she was in my home. Came home work she's gone
Des Moines - South
Lost: 4/12/2015
ID: 325
Name: No
Type: Cat
Color: orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
He is orange with white paws, white chest and white chin
Des Moines - South
Lost: 4/12/2015
ID: 321
Name: No
Type: Cat
Color: orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
He is orange with white paws, white chest and white chin
Des Moines - East
Lost: 4/12/2015
ID: 309
Name: Molly
Type: Dog
Color: blonde
Breed: Poodle
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen at 1909 E Walnut Des Moines Iowa
Bondurant
Lost: 4/12/2015
ID: 301
Name:
Type: Dog
Color:
Breed: Pekingese
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 4/11/2015
ID: 306
Name: Roxy
Type: Dog
Color: Grey, white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
If she is found please contact me on my cell phone. I miss her and want to bring her home. She was microchipped by the ARL but I am not sure if it has current information. She is very friendly and loves attention.
Fairfax
Lost: 4/11/2015
ID: 300
Name: Rocky
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Senior
Des Moines - South
Lost: 4/11/2015
ID: 297
Name: Dyna
Type: Dog
Color: dark brendell
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines south side just south of the airport, Fleur and Army Post my kids and I live at 7306 Sw 17th Street south of Army Post, she wondered off while we were grilling out and playing she's a sweet dog, doesn't bite, loves kids, loves to fetch sticks and will come to her name Dyna especially for a stick or treat, please contact Joe at 515 770-1433 my kids are so sad right now please help.
Des Moines - South
Lost: 4/11/2015
ID: 296
Name: Dyna
Type: Dog
Color: dark brendell
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines south side just south of the airport, Fleur and Army Post my kids and I live at 7306 Sw 17th Street south of Army Post, she wondered off while we were grilling out and playing she's a sweet dog, doesn't bite, loves kids, loves to fetch sticks and will come to her name Dyna especially for a stick or treat, please contact Joe at 515 770-1433 my kids are so sad right now please help.
Des Moines - Central
Lost: 4/10/2015
ID: 336
Name: Hermione
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Got out near corner of Beaver and Forest. She may be micro-chipped, but registration not updated. Hermione is strictly an indoor cat and very shy. She has green eyes and is missing a lower canine tooth. Please call if seen 515-423-7523. Heartbroken at the thought of losing her!
Des Moines - North
Lost: 4/9/2015
ID: 286
Name: Diesel
Type: Dog
Color: brown
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
He will jump fences but is the. Please leash if caught
Pleasant Hill
Lost: 4/9/2015
ID: 280
Name:
Type: Dog
Color: Brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found in pleasant hill by Southeast Polk High School
Pleasant Hill
Lost: 4/9/2015
ID: 279
Name:
Type: Dog
Color: Brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found in pleasant hill by Southeast Polk High School
Des Moines - East
Lost: 4/9/2015
ID: 271
Name: Chey
Type: Dog
Color: White coat with brown mask
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Shes been missing seens april 1st. Shes a sweet lovable playful dog. Her name is chey its pronouced shy but she also respones to baby. She was ran away and my cousin got her but escaped again around noon. She usually run down stewart to M.L.K park. She is missed so much.
Des Moines - South
Lost: 4/6/2015
ID: 312
Name: Zeus
Type: Cat
Color: tabby mostly white underneath up to nose, legs, belly. yellowish eyes, darker fur with grayish brown mixture but mainly gray
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
missing from southridge estates down by county line rd. Near Skate South. Probably more scared than anything but pretty friendly and playful. Has never been outside since i got him at 6 weeks. Almost 1 year old at beginning of june. Thin shorthair. Loves to rub up against leg and turn around and do it again. Will post pic soon
Des Moines - South
Lost: 4/6/2015
ID: 255
Name: Hannibal
Type: Cat
Color: white with dark legs and face
Breed: Himalayan
Gender: Male
Fixed: Neutered
Age: Young
He was last seen in my yard. He isn't supposed to be outside but he got out now I can't find him. If anyone finds him call 5154027441 we can discuss rewards I just want to find my cat.
Des Moines - Central
Lost: 4/6/2015
ID: 247
Name: nipper
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - West
Lost: 4/6/2015
ID: 241
Name: Clover
Type: Cat
Color: Tiger stripped with gold markings
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is declawed in the front and is food motivated and love's to play.
Des Moines - South
Lost: 4/5/2015
ID: 346
Name: Eddie
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Eddie ran out the back door of Iowa Veterinary Services and staff is unable to locate. If found please contact me at 770-4388. *Reward*
Cedar Rapids
Lost: 4/5/2015
ID: 273
Name: Sonny
Type: Dog
Color: White with black ears and eyes
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
O ave and 8th st NW CR. He has a severe anxiety disorder so do not approach him. Let him come to you or contact animal control immediately. He will run very quickly if he does not know you and you try to pick him up.
Des Moines - Central
Lost: 4/4/2015
ID: 292
Name: gorgey
Type: Cat
Color: Orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
West side of drake near the Beaverdale area. Our home is the newest around other than the Fraternities. We have looked high and low. My son is so attached to him. There is food out for him. I would do about anything to get him back. 515-279-0892 if found.
Des Moines - Central
Lost: 4/3/2015
ID: 277
Name: Dog Gone Good Award
Type: Dog
Color: Black
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
30th Street, Des Moines, Iowa