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
Grimes
Lost: 5/9/2018
ID: 8517
Name:
Type: Dog
Color: White with brown spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen running near Cuttys campground
Clive
Lost: 5/9/2018
ID: 8499
Name: Hope
Type: Dog
Color: Brown, black and white
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Adel
Lost: 5/8/2018
ID: 8603
Name: Kaine
Type: Cat
Color: Black
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Baby
Went missing last week near Adel Sheriff Station
Des Moines - East
Lost: 5/8/2018
ID: 8586
Name: Piper
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the area of E30th and Kinsey
Des Moines - East
Lost: 5/8/2018
ID: 8508
Name: Piper
Type: Cat
Color: Black, Brown an caramel
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
She’s very friendly with people and loves to cuddle not too good around other animals though
Adel
Lost: 5/8/2018
ID: 8505
Name: Kaine
Type: Cat
Color: Black /white chest
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Shy fella. Went missing near Sheriff station and courthouse. Long whiskers. Green eyes. Contact: 515-443-1960 Brad
Adel
Lost: 5/8/2018
ID: 8504
Name: Kaine
Type: Cat
Color: Black /white chest
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Lives near Sheriff station and courthouse
Norwalk
Lost: 5/8/2018
ID: 8493
Name: Eva
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near Norwood dr and cherry in norwalk
Des Moines - South
Lost: 5/8/2018
ID: 8490
Name: Chloe
Type: Dog
Color: Brown
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Young
South side by easter lake.. 4107 se 23rd st
Des Moines - South
Lost: 5/7/2018
ID: 8495
Name: Bubu
Type: Cat
Color: Gray/Black strip tiger short hair
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Senior
E Creston Ave was where he last was. He is 12 yrs old and is a real friendly cat. Will come to you if you call his name. He is neutered.
Des Moines - North
Lost: 5/7/2018
ID: 8487
Name: Sam
Type: Dog
Color: Black/silver
Breed: Schnauzer Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
He was home when i went to get my kids from school. When we got back home he was gone. E12th & Jefferson
Des Moines - South
Lost: 5/6/2018
ID: 8574
Name: Tai
Type: Dog
Color: Tan
Breed: French Bulldog
Gender: Male
Fixed: Not Neutered
Age: Baby
117 e Philip st dm please someone found him give me a call thank
Des Moines - South
Lost: 5/6/2018
ID: 8573
Name: Ivy
Type: Dog
Color: Black
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
117 e Philip st dm please someone found her give me a call
Des Moines - East
Lost: 5/6/2018
ID: 8500
Name: Lil bit
Type: Cat
Color: Black White Gray Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
600 block of se 28th ct south of the fairgrounds
Ankeny
Lost: 5/6/2018
ID: 8481
Name: Autumn
Type: Cat
Color: Black, Grey hint of brown
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
She does not like dogs she has not met before and will possibly throw some claws. She is a loving kitty and her family misses her.
Des Moines - South
Lost: 5/6/2018
ID: 8478
Name: Ivy the black, tai is the tan
Type: Dog
Color: Black-tan
Breed: French Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
117 e Philip st Des Moines southside
Des Moines - South
Lost: 5/6/2018
ID: 8476
Name: Ivy-tai
Type: Dog
Color: One black, one tan
Breed: French Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
At 117 e Philip st Des Moines southside
Ankeny
Lost: 5/6/2018
ID: 8475
Name: Sherman
Type: Cat
Color: Peach
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the 2800 block of Glennbrooke court ankeny ia. Very friendly will answer to sherman or shermmy.. This is an older picture he looks the same in the face but bigger (lean) and long
Des Moines - South
Lost: 5/6/2018
ID: 8473
Name: Coco
Type: Dog
Color: Black
Breed: Pomeranian Toy
Gender: Female
Fixed: Unknown
Age: Adult
Grimes
Lost: 5/6/2018
ID: 8472
Name: Ginger
Type: Cat
Color: Orange
Breed: Oriental Short Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
Meadowlark South, Grimes
Pleasant Hill
Lost: 5/6/2018
ID: 8469
Name: Caine
Type: Dog
Color: Brown
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 5/6/2018
ID: 8468
Name:
Type: Dog
Color:
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 5/5/2018
ID: 8502
Name: Fritz
Type: Cat
Color: Gray Striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the 1600 Block of Dean ave in Des Moines
Urbandale
Lost: 5/5/2018
ID: 8467
Name: Archer
Type: Cat
Color: Grey/brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Douglas and 70th in urbandale around 4 PM on May 5th.
West Des Moines
Lost: 5/5/2018
ID: 8454
Name: Zoey
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Adult
Zoey is very shy.