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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Found: 5/28/2021
ID: 16813
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
1573 NW 104th St, 50325
Urbandale
Found: 5/27/2021
ID: 16805
Name:
Type: Bird
Color: red
Breed: Chicken
Gender: Unknown
Fixed: Unknown
Age: Adult
3414 Ashwood Dr, 50322
Waterloo
Found: 5/26/2021
ID: 16803
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Clive
Found: 5/26/2021
ID: 16792
Name:
Type: Cat
Color: Buff
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
8355 North Franklin Avenue
Des Moines - Central
Found: 5/25/2021
ID: 16787
Name: Unsure
Type: Cat
Color: Gray
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We have fed him and I believe he will sleep on the porch this evening. He has been sleeping in the neighbors treehouse two houses down. Not sure for how long. The owner does not live at that house. You can email for more pictures.
Des Moines - Central
Found: 5/25/2021
ID: 16786
Name: Unsure
Type: Cat
Color: Gray
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We have fed him and I believe he will sleep on the porch this evening. He has been sleeping in the neighbors treehouse two houses down. Not sure for how long. The owner does not live at that house. You can email for more pictures.
Des Moines - South
Found: 5/25/2021
ID: 16783
Name:
Type: Cat
Color: Black with white on stomach
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Baby
**UPDATE: owner has been found via microchip** Found McKinley & SW 16th. Small notch in right ear. Has claws
West Des Moines
Found: 5/24/2021
ID: 16778
Name:
Type: Dog
Color: Grey and White
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
EP True Parkway and 60th St
West Des Moines
Found: 5/24/2021
ID: 16774
Name:
Type: Dog
Color: Brown, black, and white
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Clive
Found: 5/22/2021
ID: 16768
Name:
Type: Rabbit
Color: White with black markings.
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Young
This rabbit was found in the Greenbelt Park. On 5/23/2021 another rabbit with similar markings was also found and is being held at Furry Friends Rescue.
Urbandale
Found: 5/22/2021
ID: 16764
Name:
Type: Bird
Color: blue
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 5/22/2021
ID: 16758
Name: Smudge
Type: Cat
Color: Tortoise shell
Breed: Parakeet
Gender: Female
Fixed: Neutered
Age: Young
She's not got out in the wooded area behind our house off 23rd and hickman.(up the hill from hickman flats apartments)
West Des Moines
Found: 5/22/2021
ID: 16757
Name: Bennie
Type: Dog
Color: tan and white
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
500 45th St, 50265 West Des Moines
Mitchellville
Found: 5/21/2021
ID: 16802
Name: Samso
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
West Des Moines
Found: 5/21/2021
ID: 16756
Name:
Type: Dog
Color: black
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
5909 Brookview Dr, West Des Moines
Des Moines - Central
Found: 5/21/2021
ID: 16749
Name: Sonny Russo
Type: Dog
Color: Brindle
Breed: French Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Forest Ave and 34th St.
Ames
Found: 5/20/2021
ID: 16746
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 5/20/2021
ID: 16743
Name: Bella
Type: Dog
Color: white
Breed: Eskimo Dog
Gender: Female
Fixed: Unknown
Age: Adult
Coachlight Circle
West Des Moines
Found: 5/20/2021
ID: 16736
Name: Akina
Type: Dog
Color: Black, little bit of white
Breed: Eskimo Dog
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 5/19/2021
ID: 16735
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
3001 Hawthorne
Urbandale
Found: 5/19/2021
ID: 16734
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
7701 Dennis Dr
West Des Moines
Found: 5/19/2021
ID: 16731
Name:
Type: Dog
Color: Brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Pleasant Hill
Found: 5/18/2021
ID: 16726
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Found running in the road on SE 68th street near Four Mile Elementary. Has a collar, but no tags.
Des Moines - East
Found: 5/16/2021
ID: 16710
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Going to be taken to ARL
West Des Moines
Found: 5/14/2021
ID: 16697
Name:
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult