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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1552953600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 3/24/2019
ID: 10819
Name: G-lee
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
31st and Woodland. She is very friendly.
Des Moines - East
Found: 3/24/2019
ID: 10817
Name:
Type: Dog
Color: white and orange
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
he is microchipped but not registered, found on east side of des moines by the fair grounds, he’s a very sweet and smart boy, gets along with my dogs well.
Des Moines - East
Lost: 3/24/2019
ID: 10816
Name: Chiquito
Type: Dog
Color: Red and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He is older now then his picture and may be very dirty has dug many holes in our yard
Des Moines - South
Found: 3/24/2019
Animal ID: 80402
West Des Moines
Found: 3/23/2019
ID: 10815
Name:
Type: Dog
Color: cream and tan
Breed: Collie Rough
Gender: Male
Fixed: Neutered
Age: Adult
Found at Normandy Terrace Apartments in West Des Moines
Urbandale
Lost: 3/23/2019
ID: 10812
Name: Cadet
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen as we were unloading the car and bringing stuff into the house. Cadet is an indoor cat and does not usually go outside, therefore has not been chipped. He has all his claws and is normally a very friendly and affectionate cat.
Ankeny
Lost: 3/23/2019
ID: 10811
Name: Bellr
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is a boy, named Belle. Needs prescription cat food. Very sweet and kind. Call Karrie @ 515-238-3200.
Des Moines - East
Found: 3/23/2019
ID: 10808
Name: Ink
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
I have the cat and will have scanned for a chip asap.
Des Moines - East
Found: 3/23/2019
Animal ID: 169936
Indianola
Lost: 3/23/2019
ID: 10807
Name: Tippy
Type: Cat
Color: White and orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last see. Around East 15th St and East 16th St in Indianola. He is deaf.
Des Moines - North
Found: 3/23/2019
Animal ID: 169912
Des Moines - Central
Found: 3/23/2019
Animal ID: 169935
Des Moines - Central
Found: 3/23/2019
Animal ID: 169916
Des Moines - Central
Found: 3/23/2019
Animal ID: 169920
Des Moines - Central
Found: 3/23/2019
Animal ID: 169919
Des Moines - Central
Found: 3/23/2019
Animal ID: 169915
Cumming
Lost: 3/23/2019
ID: 10805
Name: Luna
Type: Dog
Color: White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Young
Last seen west of the interstate in Cummings. She is a five month old Border Collie/Blue Heeler mix. She answers to Luna or Luna Bear.
Des Moines - South
Lost: 3/23/2019
ID: 10804
Name: Simon
Type: Dog
Color: Brown and white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
He went missing in the Easter lake area this morning and escaped again after finding him.
Woodward
Found: 3/23/2019
ID: 10803
Name:
Type: Dog
Color: Brown and white
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Young
Found on the High Trestle trail near the High Trestle bridge.
Des Moines - North
Found: 3/23/2019
Animal ID: 169938
Des Moines - South
Lost: 3/23/2019
ID: 10801
Name: Simon
Type: Dog
Color: Brown
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
He was last seen around the Easter lake houses
West Des Moines
Found: 3/23/2019
ID: 10800
Name: Dante
Type: Dog
Color: Black and white
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Dante broke off of his collar and escaped from our backyard.
West Des Moines
Found: 3/23/2019
ID: 10799
Name: Dante
Type: Dog
Color: Black/white
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - East
Lost: 3/22/2019
ID: 10814
Name: Lola
Type: Cat
Color: Grey mixed tan
Breed: Rat Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Last seem in my backyard at 10pm
Des Moines - Central
Lost: 3/22/2019
ID: 10810
Name: Sesi (Seh-See)
Type: Dog
Color: Black, White, brown
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
She is shy of humans but super sweet, loves treats.