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>='1594080000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 5/13/2020
ID: 13989
Name:
Type: Dog
Color:
Breed: Shiba Inu
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Found: 5/13/2020
ID: 13983
Name:
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
51st Bel Aire Road North of Aurora Ave
Clive
Found: 5/13/2020
ID: 13981
Name:
Type: Dog
Color: Grey and Yellow
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 5/12/2020
ID: 14223
Name:
Type: Cat
Color: Orange/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 5/12/2020
ID: 13982
Name:
Type: Cat
Color: Grey & White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
9200 Block of Nine Iron Drive in WDM
Urbandale
Found: 5/12/2020
ID: 13975
Name:
Type: Dog
Color: Tan and Black
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
7500 block of Canterbury Road
Des Moines - East
Found: 5/9/2020
ID: 13955
Name:
Type: Cat
Color: Calico long hair
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Front declawed
Des Moines - East
Found: 5/9/2020
ID: 13946
Name: Unknown
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Very skittish and won’t let me touch him. Been hanging around my house for a couple of days
Ames
Found: 5/8/2020
ID: 13995
Name: Mia
Type: Cat
Color: Calico but a lot of white; part Siamese
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
If she sneaks out, she often goes back to our old home just a mile away in Spring Valley, Ames, IA. She is very friendly. Has some Siamese in her so has a very thin build.
Urbandale
Found: 5/7/2020
ID: 13936
Name: Penelope
Type: Cat
Color: Orange and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale
West Des Moines
Found: 5/7/2020
ID: 13933
Name:
Type: Dog
Color: Grey/Brindle
Breed: Mastiff
Gender: Male
Fixed: Unknown
Age: Young
Raccoon River Dr/ Grand Ave
Des Moines - South
Found: 5/6/2020
ID: 13925
Name: Zoey
Type: Cat
Color: Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Johnston
Found: 5/5/2020
ID: 13914
Name: Ace
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
last seen around 1 am 5/4/20 in green meadows johnston iowa. large black and white cat. friendly but just scared, can pick him up even if he’s shy. comes to the name Ace. will do anything to bring him home, can offer 50$ to a finder.
Des Moines - Central
Found: 5/3/2020
ID: 13898
Name: Unknown
Type: Dog
Color: Golden
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Found her around Grandview running, very friendly, looks like she recently had puppies
Urbandale
Found: 5/2/2020
ID: 13891
Name:
Type: Dog
Color: Orange & white
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Dubuque
Found: 5/2/2020
ID: 13887
Name: Carlton
Type: Cat
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Baby
West Des Moines
Found: 5/1/2020
ID: 13893
Name: Unknown
Type: Dog
Color: Black/Tan
Breed: Chihuahua
Gender: Unknown
Fixed: Unknown
Age: Adult
2 dogs found in WDM! Have been reported to Animal Control but told them we were happy to have them stay with us until owner is found.
Oakland
Found: 5/1/2020
ID: 13888
Name: Billie
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen by Eckels Memorial Library and Oakland park.
Des Moines - East
Found: 4/29/2020
ID: 13865
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Senior
Sweet and friendly, front declawed, quite thin. We think this is an elderly cat, but I am not a vet.
Des Moines - East
Found: 4/28/2020
ID: 13859
Name: Unknown
Type: Dog
Color: Brown/black
Breed: Pinscher-Miniature
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 4/28/2020
ID: 13858
Name: Unknown
Type: Dog
Color: Brown/black
Breed: Pinscher-Miniature
Gender: Male
Fixed: Unknown
Age: Adult
He is safe and healthy.,
Des Moines - East
Found: 4/28/2020
ID: 13856
Name: Unknown
Type: Cat
Color: Grey and cream
Breed: Tortoiseshell
Gender: Unknown
Fixed: Unknown
Age: Young
VERY VOCAL! Sweet little cat that is clearly comfortable with humans.
Des Moines - North
Found: 4/28/2020
ID: 13855
Name:
Type: Dog
Color:
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Adult
Just picked this little buddy up crossing Hickman and MLK pkwy
Des Moines - East
Found: 4/26/2020
ID: 13853
Name: Kitten 3-4 months old
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Very young cat, 3 to 4 months old, (guessing). Found on Capitol by Fairgrounds. Seems very well taken care of. I did have it checked for a microchip and there isn't one.
De Witt
Found: 4/25/2020
ID: 14105
Name:
Type: Dog
Color: Gray/white
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Dog hit by train found in remote area