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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Found: 12/10/2018
Animal ID: 167264
West Des Moines
Found: 12/10/2018
ID: 10235
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Found on the first floor of 2140 Grand Ave.
Des Moines - East
Found: 12/10/2018
ID: 10230
Name: Unknown
Type: Dog
Color: Brown/black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Found on east broadway
West Des Moines
Found: 12/10/2018
ID: 10228
Name:
Type: Dog
Color: White, Brown & Black
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Found: 12/10/2018
Animal ID: 167245
Des Moines - Central
Found: 12/10/2018
Animal ID: 167233
Runnells
Found: 12/10/2018
Animal ID: 167238
Ankeny
Found: 12/10/2018
Animal ID: 33831
Des Moines - Central
Found: 12/9/2018
Animal ID: 167240
Urbandale
Found: 12/9/2018
ID: 10225
Name:
Type: Dog
Color: White
Breed: American Eskimo Dog
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Found: 12/9/2018
Animal ID: 167230
Iowa City
Found: 12/9/2018
ID: 10215
Name: Unknown
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Friendly cat found at Hawks Ridge Apartment complex. It came up to me and wanted pet. It followed me around for a bit. Does not seem afraid of people, so it makes me think it is someone’s pet.
Liscomb
Found: 12/9/2018
ID: 10214
Name:
Type: Dog
Color: White, black,tan
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Well behaved. Fixed, currently at my residence.
Des Moines - North
Found: 12/8/2018
Animal ID: 167220
Des Moines - Central
Found: 12/8/2018
Animal ID: 167197
Des Moines - Central
Found: 12/8/2018
Animal ID: 167215
Des Moines - Central
Found: 12/8/2018
Animal ID: 167210
Des Moines - Central
Found: 12/8/2018
Animal ID: 167201
Des Moines - Central
Found: 12/8/2018
Animal ID: 167202
Ankeny
Found: 12/8/2018
Animal ID: 167196
Clive
Found: 12/7/2018
ID: 10197
Name:
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
We will be taking this cat to the West Des Moines animal rescue league.
Des Moines - East
Found: 12/7/2018
ID: 10193
Name:
Type: Dog
Color: Brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
I found this guy walking down e 38th st. Near Grandview ball field. He did have collar and leash still attached. I took to main arl.
Des Moines - East
Found: 12/5/2018
ID: 10200
Name:
Type: Dog
Color: golden tan
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Found running along Colfax by Sargent Park. The intersection of Euclid and Colfax.
Lu Verne
Found: 12/5/2018
ID: 10174
Name:
Type: Dog
Color: Black
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Found: 12/4/2018
ID: 10172
Name: Na
Type: Cat
Color: Black n white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
845pm nice black n white cat was eating outside our home. Fyi e23rd n Thompson or Guthrie