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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 9/27/2020
ID: 15072
Name:
Type: Cat
Color: White and Buff
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Adult
1300 block S Lakeview Drive
Des Moines - North
Found: 9/26/2020
ID: 15071
Name:
Type: Bird
Color: Lime Green / Yellow
Breed: Budgie/Budgerigar
Gender: Unknown
Fixed: Unknown
Age: Adult
Hanging around at our bird feeder
West Des Moines
Found: 9/26/2020
ID: 15050
Name:
Type: Dog
Color: white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
3000 block of university ave
West Des Moines
Found: 9/26/2020
ID: 15049
Name:
Type: Dog
Color: white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
3000 block of university ave
Clive
Found: 9/26/2020
ID: 15048
Name:
Type: Cat
Color: brown tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
800 block Harbach Blvd
Urbandale
Found: 9/25/2020
ID: 15047
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
5100 block of 69th street
Clive
Found: 9/25/2020
ID: 15044
Name:
Type: Bird
Color: red
Breed: Chicken
Gender: Unknown
Fixed: Unknown
Age: Adult
800 block Franklin Ave
Urbandale
Found: 9/25/2020
ID: 15043
Name:
Type: Cat
Color: grey and brown
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
500 block 69th street
Adel
Found: 9/25/2020
ID: 15042
Name:
Type: Other
Color: Brown
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
Found baby goat outside of our goat pen in Adel. Have provided food and shelter while we search for owner.
Urbandale
Found: 9/24/2020
ID: 15045
Name:
Type: Cat
Color: grey and White
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Adult
1000 block Sutton Drive
West Des Moines
Found: 9/23/2020
ID: 15028
Name:
Type: Dog
Color: Blue/grey and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
5th street and Vine
West Des Moines
Found: 9/23/2020
ID: 15025
Name:
Type: Cat
Color: White and Brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Urbandale
Found: 9/23/2020
ID: 15021
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Johnston
Found: 9/22/2020
ID: 15020
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
He comes right up to the door and meows but won’t let us get too close. He came back this morning. Seems like he needs help.
Johnston
Found: 9/22/2020
ID: 15019
Name:
Type: Cat
Color: orange and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
First saw him the evening of the 22. He comes up to the door and meows but is timid and doesn’t want us to get too close. Came back this morning still meowing at the door.
Williamson
Found: 9/22/2020
ID: 15016
Name:
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
This sweet girl showed up at our place mid- morning.
Williamson
Found: 9/22/2020
ID: 15015
Name:
Type: Dog
Color:
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
This sweet girl showed up at our place mid- morning.
West Des Moines
Found: 9/21/2020
ID: 15010
Name: Sajha
Type: Dog
Color: white/yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Hidden Valley Soccer Field
Waterloo
Found: 9/21/2020
ID: 15009
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Picked up near Laporte Rd/Clark gas station
Des Moines - East
Found: 9/20/2020
ID: 15002
Name:
Type: Dog
Color:
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - West
Found: 9/19/2020
ID: 14996
Name:
Type: Cat
Color: Black & White
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Young
Very friendly cat, came right up to me meowing non-stop. She’s very skinny and her paws are calloused so I think she’s been a while. She came into my apt and ate 2 bowls of food, drank a lot of water and napped. That makes me believe she’s someone’s lost pet. She was taken to the ARL in Des Moines 9/19/20.
Urbandale
Found: 9/19/2020
ID: 14994
Name: Thor
Type: Dog
Color: Black and White
Breed: Retriever, Labrador
Gender: Male
Fixed: Neutered
Age: Adult
6900 block Douglas
West Des Moines
Found: 9/18/2020
ID: 14989
Name:
Type: Small or Furry
Color: black and white
Breed: Ferret
Gender: Unknown
Fixed: Unknown
Age: Baby
2200 block EP True Pkwy
Urbandale
Found: 9/18/2020
ID: 14987
Name:
Type: Cat
Color: Orange and white Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
10200 block Hickory lane
Urbandale
Found: 9/18/2020
ID: 14986
Name:
Type: Dog
Color: White and Rust
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Adult
Aurora and 70th