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>='1632268800')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Found: 3/4/2021
ID: 16133
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
2240 NW 81st st
Urbandale
Found: 3/4/2021
ID: 16123
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
9123 Aurora Ave
West Des Moines
Found: 3/4/2021
ID: 16122
Name:
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
500 block Grand Ave
West Des Moines
Found: 3/4/2021
ID: 16119
Name:
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/3/2021
ID: 16112
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 3/2/2021
ID: 16108
Name:
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Handsome lovey little man showed up on my porch in the Val Vista trailer court (Lower half). Last seen around 830pm, hiding under my husband's vehicle. Looks well fed and loved. Very vocal and a little purr machine. Just hope he makes it home.
Riverside
Found: 3/2/2021
ID: 16104
Name:
Type: Cat
Color: black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
found outside of riverside casino
Waterloo
Found: 3/1/2021
ID: 16124
Name: Unknown
Type: Cat
Color: Black/white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Hangs around in our backyard and neighbors
Polk City
Found: 2/28/2021
ID: 16120
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Friendly cat that has visited us and some of our neighbors. Is comfortable with people petting her.
West Des Moines
Found: 2/28/2021
ID: 16094
Name: Sarah
Type: Cat
Color: Grey and orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 2/28/2021
ID: 16093
Name:
Type: Dog
Color: black and white
Breed: Retriever, Labrador
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 2/26/2021
ID: 16080
Name: Unknown
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Running around campus of Grand View University 2/26 11:00 pm. DMPD called and dog picked up. Wearing a pink collar with no tags and “Mamas Boy” shirt. CALL ANIMAL CONTROL OR DMPD FOR INFORMATION.
Pleasantville
Found: 2/25/2021
ID: 16075
Name: Hoppy
Type: Cat
Color: Grey and black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Kitten has been found!
West Des Moines
Found: 2/25/2021
ID: 16074
Name:
Type: Dog
Color: tan
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
2900 blck Giles St
West Des Moines
Found: 2/25/2021
ID: 16071
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
6925 Mills Civic
West Des Moines
Found: 2/23/2021
ID: 16063
Name:
Type: Cat
Color: Black and White Tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Polk City
Found: 2/22/2021
ID: 16159
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Adult
This cat has been in our neighborhood for a couple weeks now. He is sweet, cuddly and friendly. We are feeding him. He is very gentle and nice. We took him to the vet to see if he was chipped, but unfortunately he is not.
Davis City
Found: 2/22/2021
ID: 16060
Name: Unknown
Type: Dog
Color: Red/White
Breed: Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
I found him on Dale Miller Rd right across from the Post office. Nearby neighbor said he'd been hanging out last couple of days
Des Moines - South
Found: 2/21/2021
ID: 16054
Name:
Type: Dog
Color: Tri
Breed: Cattle Dog
Gender: Female
Fixed: Unknown
Age: Adult
Near Easter Lake area
Des Moines - South
Found: 2/21/2021
ID: 16053
Name:
Type: Dog
Color: Tri
Breed: Cattle Dog
Gender: Unknown
Fixed: Unknown
Age: Adult
Near Easter Lake area in DSM
Johnston
Found: 2/19/2021
ID: 16046
Name: Kitty
Type: Cat
Color: Grey, tan brown and white
Breed: Cattle Dog
Gender: Female
Fixed: Unknown
Age: Young
Last seen lately morning. Have no idea how or when she got out. She is a strictly indoor cat. New to the area. Generally not friendly with strangers.
Des Moines - East
Found: 2/15/2021
ID: 16036
Name: Tiger
Type: Dog
Color: Reverse brindle
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
E 29th and University Ave
Des Moines - East
Found: 2/13/2021
ID: 16026
Name: Unknown
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Was found on Winegardner road. Rabies collar # 307756. Call Jenna #515-689-3287
Waukee
Found: 2/9/2021
ID: 16018
Name:
Type: Cat
Color: Brown and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Found near 1st St and Northview Dr approx 3am, no collar
Ankeny
Found: 2/8/2021
ID: 16015
Name: unknown
Type: Cat
Color: black with white paws; partial white face; white blaze on face.
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
live trapped him this am. was at the White Birch homes near Oralabor RD & 415/State St. SW Ankeny. He has been around this area at least 2 weeks. Contact Jim @ 515-505-4147. He is at the main ARL loc on 22nd Ave DSM/Ankeny