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>='1606262400')) ORDER BY pm1.meta_value DESC, post_date DESC
Norwalk
Found: 4/10/2020
ID: 13752
Name: Unknown
Type: Cat
Color: Grey
Breed:
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Found: 4/8/2020
ID: 13741
Name: Maddie
Type: Cat
Color: Tuxedo
Breed:
Gender: Female
Fixed: Unknown
Age: Young
Johnston
Found: 4/8/2020
ID: 13739
Name: unknown
Type: Dog
Color: white
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Baby
This dog has a chip but the owner has not registered it. Please call the Johnston Public Works department if this is your dog. 515-278-0822
Newton
Found: 4/7/2020
ID: 13735
Name:
Type: Dog
Color: Brown
Breed: Pomeranian Toy
Gender: Female
Fixed: Unknown
Age: Adult
S 13th Ave E
Newton
Found: 4/7/2020
ID: 13734
Name:
Type: Dog
Color: Brown
Breed: Pomeranian Toy
Gender: Female
Fixed: Unknown
Age: Adult
Norwalk
Found: 4/6/2020
ID: 13729
Name: Robyn
Type: Cat
Color: Brown
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
She is really small and fast. She is almost 1.
Norwalk
Found: 4/6/2020
ID: 13722
Name:
Type: Dog
Color: Fawn/Briwn
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Adult
HWY 28 south of Norwalk between Gear and 50th St.
Des Moines - East
Found: 4/4/2020
ID: 13718
Name: NA
Type: Dog
Color: White and brown
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
I found him on University Ave corner with E 37th street across from Now or Later Italian Restaurant close to the fairgrounds
Des Moines - North
Found: 4/4/2020
ID: 13698
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Found this very loving little guy on my patio sitting in my chair. He seemed happy to have some food/water. Brought him inside since it's a bit chilly out.
Solon
Found: 4/3/2020
ID: 13749
Name:
Type: Dog
Color: White/Black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - South
Found: 4/3/2020
ID: 13697
Name:
Type: Dog
Color: Black white chest
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
2 puppies found near sw 9th and porter ave
Corning
Found: 4/2/2020
ID: 13692
Name: Lincoln
Type: Dog
Color: Multi
Breed: Saint Bernard
Gender: Male
Fixed: Neutered
Age: Young
We let the dogs out before dinner and they haven’t returned.
Corning
Found: 4/2/2020
ID: 13691
Name: Carter
Type: Dog
Color: Blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
We let the dogs out before dinner and they have not returned.
Clive
Found: 3/31/2020
ID: 13678
Name:
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Ladora
Found: 3/31/2020
ID: 13676
Name: Ava
Type: Dog
Color: Black white gray
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Adult
Reb collar with a bell Last seen a mile from Lake Iowa
Urbandale
Found: 3/30/2020
ID: 13667
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
16800 Block of Madison Circle
West Des Moines
Found: 3/30/2020
ID: 13663
Name:
Type: Dog
Color: Tan
Breed: Cocker Spaniel
Gender: Unknown
Fixed: Unknown
Age: Adult
4700 Block of Westwood Drive
Clive
Found: 3/30/2020
ID: 13660
Name:
Type: Dog
Color: Black
Breed: Retriever, Labrador
Gender: Female
Fixed: Unknown
Age: Adult
9400 Block of Lincoln
Altoona
Found: 3/30/2020
ID: 13659
Name:
Type: Dog
Color: White w/ brown
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
By HyVee on 1st Ave SW
Clive
Found: 3/29/2020
ID: 13682
Name:
Type: Dog
Color: Brown and White
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Clive
Clive
Found: 3/29/2020
ID: 13681
Name:
Type: Dog
Color: Brown and White
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Clive
West Des Moines
Found: 3/29/2020
ID: 13658
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - North
Found: 3/29/2020
ID: 13656
Name: Unknown
Type: Dog
Color: Grayish
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
He’s staying with me till we find his family. He is neutered. Super friendly.
Des Moines - Central
Found: 3/29/2020
ID: 13653
Name:
Type: Dog
Color: Black and white
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Found near Moulton Elementary
Marion
Found: 3/26/2020
ID: 13633
Name:
Type: Cat
Color: Gray tabby
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
At MercyCare Marion clinic. Extremely friendly and comfortable with people and riding in the car. Looks like she has recently weaned kittens.