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>='1600473600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Found: 4/14/2020
ID: 13786
Name: Alex
Type: Cat
Color: Black/White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Front Declawed
Clear Lake
Found: 4/14/2020
ID: 13784
Name: Unknown
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Has been showing up every morning for food and water. Very friendly cat. Wants to come into our house. Located in the Pine Tree Park area of Clear Lake, north of the state park.
Davenport
Found: 4/14/2020
ID: 13779
Name: Unknown
Type: Dog
Color: Golden
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Altoona
Found: 4/14/2020
ID: 13769
Name:
Type: Dog
Color: Black with white paws
Breed: Alaskan Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Found walking along the bike trail near 5th Ave SW in Altoona, where the railroad track crosses. She is dragging a tie out chain that is in a knot.
Des Moines - East
Found: 4/11/2020
ID: 13758
Name:
Type: Small or Furry
Color: Dark brown/white
Breed: Ferret
Gender: Male
Fixed: Neutered
Age: Adult
Found on E madison
Urbandale
Found: 4/11/2020
ID: 13757
Name:
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - West
Found: 4/10/2020
ID: 13756
Name:
Type: Cat
Color: White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Norwalk
Found: 4/10/2020
ID: 13752
Name: Unknown
Type: Cat
Color: Grey
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Found: 4/8/2020
ID: 13741
Name: Maddie
Type: Cat
Color: Tuxedo
Breed: Unknown
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