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>='1599868800')) ORDER BY pm1.meta_value DESC, post_date DESC
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!
Des Moines - Central
Found: 2/23/2020
ID: 13436
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
Oskaloosa
Found: 2/23/2020
ID: 13434
Name: Unknown
Type: Dog
Color: White, brown, black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Found on road near Edmundson Park. Very friendly.
Adel
Found: 2/23/2020
ID: 13430
Name:
Type: Dog
Color: Brindle
Breed: Akbash
Gender: Male
Fixed: Unknown
Age: Young
Rural Adel /350th St - would not come
West Des Moines
Found: 2/23/2020
ID: 13429
Name:
Type: Dog
Color: Grey
Breed: Schnauzer Miniature
Gender: Unknown
Fixed: Unknown
Age: Adult
60th and University Avenue
West Des Moines
Found: 2/23/2020
ID: 13428
Name:
Type: Dog
Color: Grey and White
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
60th & University Avenue
Des Moines - East
Found: 2/22/2020
ID: 13424
Name: Andre
Type: Dog
Color: Brindle
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Young
Last seen around E. 14th around grandveiw area. He is very shy and will most likely run. But has never hurt anyone
Des Moines - East
Found: 2/22/2020
ID: 13423
Name: Shadow wado
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around E.14th around Grandveiw college
Urbandale
Found: 2/22/2020
ID: 13420
Name:
Type: Cat
Color: Grey
Breed: Siberian Husky
Gender: Unknown
Fixed: Unknown
Age: Young
Hanging out by my neighbors shed. He goes into the groundhog den underneath anytime I get close.
Urbandale
Found: 2/21/2020
ID: 13412
Name:
Type: Cat
Color: Black and Orange Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Adult
Bristol Ridge Apartments
Urbandale
Found: 2/21/2020
ID: 13411
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Bristol Ridge Apartments
West Des Moines
Found: 2/21/2020
ID: 13410
Name:
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 2/20/2020
ID: 13426
Name:
Type: Dog
Color: White and Black
Breed: Siberian Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Found running near Ashworth Rd WDM/Waukee area
Urbandale
Found: 2/17/2020
ID: 13407
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found at 62nd Street and Sheridan in Urbandale
Des Moines - North
Found: 2/16/2020
ID: 13404
Name: Callie
Type: Cat
Color: White and grey/calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Young
Ankeny
Found: 2/16/2020
ID: 13401
Name:
Type: Cat
Color: Tiger Stripe
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Baby
I have her at my place
Urbandale
Found: 2/12/2020
ID: 13387
Name:
Type: Dog
Color: Brindle & White
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Ankeny
Found: 2/11/2020
ID: 13383
Name:
Type: Dog
Color: Blue and white
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Adult
Please contact Ankeny Animal Health Clinic if you are her owners. 515-965-0452