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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1594252800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 3/8/2020
ID: 13526
Name:
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
Stuart
Found: 3/8/2020
ID: 13524
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 3/8/2020
ID: 13522
Name: Unknown
Type: Bird
Color: Blue and grey
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Baby
We caught the bird in a box, we called animal control because we weren't sure what else to do
Des Moines - Central
Found: 3/8/2020
ID: 13520
Name:
Type: Dog
Color: Brown and camel
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
44th and Hickman in Beaverdale
Des Moines - South
Found: 3/7/2020
ID: 13543
Name:
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Unknown
Fixed: Unknown
Age: Adult
Came to our door at 1:00 am and wanted in. Very friendly. Kading properties Bloomfield.
West Des Moines
Found: 3/7/2020
ID: 13509
Name:
Type: Dog
Color: White
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Adult
5400 Block of Coachlight Drive
Des Moines - East
Found: 3/6/2020
ID: 13578
Name: Unknown
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Baby
S.E. 14th and Glenwood
Des Moines - South
Found: 3/6/2020
ID: 13577
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Not Neutered
Age: Baby
S.E. 14th and Glenwood
Des Moines - East
Found: 3/6/2020
ID: 13505
Name: Unknown
Type: Dog
Color: Blonde
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Senior
Found on E 27TH and Boyd
Des Moines - South
Found: 3/6/2020
ID: 13503
Name:
Type: Dog
Color: brown/black with white chest
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found near Morris Elementary School on SW 14th St. Very sweet dog!!
Des Moines - South
Found: 3/6/2020
ID: 13502
Name:
Type: Dog
Color: brown/black with white chest
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Last seen at Morris Elementary school. Currently going to see if she has a microchip. Very sweet dog!
Urbandale
Found: 3/6/2020
ID: 13498
Name:
Type: Dog
Color: brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
7100 block of Beechwood in Urbandale
West Des Moines
Found: 3/4/2020
ID: 13491
Name:
Type: Cat
Color: Grey Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found at Jordan Creek Apartments
West Des Moines
Found: 3/4/2020
ID: 13490
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4000 block of Woodland Ave
Dumont
Found: 3/4/2020
ID: 13489
Name:
Type: Cat
Color: Yellow and white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Has a half tail. Black collar was way too tight so this kitty may have been out for a long while. No tags. I have him.
Afton
Found: 3/3/2020
ID: 13486
Name:
Type: Dog
Color: black with white front
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
This dog showed up at our house 3 miles east of Afton. Very friendly. Hasn't been lost long not thin. Has a collar but no tags.
Ankeny
Found: 3/2/2020
ID: 13480
Name: TY
Type: Dog
Color: Brown black white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
We live NE Falstaff Lane no Chipped..no collar 712 830 0306 neutered IS MICROCHIPPED
Ankeny
Found: 3/2/2020
ID: 13479
Name: TY
Type: Dog
Color: Brown black white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
We live NE Falstaff Lane Call 712 830 0306...loves other dogs..neutered IS MICROCHIPPED
Des Moines - Central
Found: 3/1/2020
ID: 13474
Name:
Type: Dog
Color: Red
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 3/1/2020
ID: 13473
Name: Unknown
Type: Dog
Color: Mixed brown and tan
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
Found at 35th and Cottage Grove Ave, very sweet and timid.
Des Moines - Central
Found: 2/27/2020
ID: 13465
Name: Charlie
Type: Cat
Color: Yellow Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Tag says Hello my name is Charlie. My contact info is on the back. He's very friendly but skittish at first. Gold eyes. Last seen Gray's Lake neighborhood Des Moines north of Lincoln HS and west of SW 9th.
Urbandale
Found: 2/25/2020
ID: 13448
Name:
Type: Dog
Color: Tan and White
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Senior
7600 block of Roseland Avenue
Urbandale
Found: 2/25/2020
ID: 13447
Name:
Type: Dog
Color: Black and Tan
Breed: Yorkie Poo
Gender: Unknown
Fixed: Unknown
Age: Adult
7600 Block of Roseland Avenue
Des Moines - North
Found: 2/25/2020
ID: 13443
Name: Ivy
Type: Dog
Color: Black/tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
Lake Mills
Found: 2/24/2020
ID: 13440
Name: NeedHome
Type: Cat
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
5 or 6 months old, TINY, stray, took him to the vet for shots and neutered. Needs a home! I can't keep him, we have too many already, please!