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' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1614643200')) ORDER BY pm1.meta_value DESC, post_date DESC
Oskaloosa
Lost: 9/5/2020
ID: 14899
Name: Turbo
Type: Cat
Color: Mixed
Breed:
Gender: Male
Fixed: Neutered
Age: Young
Stopped at Oskaloosa, at the Murphy USA gas station. 2201 A Ave W. He has a bite mark that is healing on his front right leg.
Norwalk
Lost: 9/5/2020
ID: 14898
Name: Unknown
Type: Dog
Color: Multi
Breed:
Gender: Male
Fixed: Unknown
Age: Senior
Playing on G14 Highway close to Orilla Rd with a black dog. Black dog took off. We put him in our yard and he isn't running off.
Urbandale
Lost: 9/4/2020
ID: 14896
Name: Gino
Type: Cat
Color: Gray tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
10:00 pm on 9/4/2020
Des Moines - North
Lost: 9/4/2020
ID: 14894
Name: Creed
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in the 31 and pleasant area
Atlantic
Lost: 9/3/2020
ID: 14920
Name: Abe
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Waterloo
Lost: 9/3/2020
ID: 14897
Name: Greybush
Type: Cat
Color: Grey
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Senior
She got out during the night on 9/3. She doesn’t have a collar. Please help me find my baby
Des Moines - North
Lost: 9/3/2020
ID: 14882
Name: Emma
Type: Cat
Color: Grey black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Perfect equal markings. Looks like a Bengal. Strips around legs and tall. She looks like she has a mask on her eyes Leopard like dots all over body. White chest.
Berwick
Lost: 9/3/2020
ID: 14878
Name: Unknown
Type: Dog
Color: Tan and white
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Newton
Lost: 9/2/2020
ID: 14883
Name: Stinky
Type: Cat
Color: Gray with tabby marking
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
My Mom's cat has gone missing. Was last seen in back bedroom of second story apartment at Hunters Run apartments. She may have gotten out through the window. and may be injured since the rear window screen was found on the ground. Possibly wearing a red collar, still has claws and can be quite fiesty at times. Looks like a russian blue, but with tabby markings. Has a temptations treat addiction too.
Des Moines - North
Lost: 9/2/2020
ID: 14872
Name: Jack
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
In our back yard. He has one eye. He's a little larger than the photo now and has white markings on his chest.
Pleasant Hill
Lost: 9/2/2020
ID: 13668
Name: Junior
Type: Cat
Color: Brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last known location was in the tall grasses near the cul de sac at the end of Lakeview Drive and Copper Creek hole 14 tee boxes. Somewhat skittish around strangers, but may come to “here kitty kitty”. Slender build and approximately 10.5-11 lbs. Wider black stripe on lower back. Underside of legs is black. Young adult, almost 1.5 years old. Microchip #981020029446068. Was wearing a blue collar with GPS, which was found in location noted.
Madrid
Lost: 9/1/2020
ID: 14875
Name: Batman
Type: Cat
Color: black and grey with stripes
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly and meows alot
West Des Moines
Lost: 9/1/2020
ID: 14868
Name: Gus
Type: Cat
Color: Flea Collar
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Lost: 8/31/2020
ID: 14900
Name: Niles
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the Glenstone neighborhood in Grimes/Johnston’s. Niles has bright green eyes, has not been declawed and has had his teeth removed. Very friendly but can be cautious.
Columbus Junction
Lost: 8/31/2020
ID: 14888
Name: Nova, Apollo
Type: Dog
Color: Blue, Tan
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Applicable
Age: Young
Last seen in Cairo, IA
Columbus Junction
Lost: 8/31/2020
ID: 14887
Name: Nova and Apollo
Type: Dog
Color: One is grey female One is tan male
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Young
Des Moines - Central
Lost: 8/31/2020
ID: 14861
Name: P Kitty
Type: Cat
Color: Orange/White
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen at 6 am in the Union Park area. Our front door was blown open and she got out.
Urbandale
Lost: 8/31/2020
ID: 14860
Name: Josie
Type: Cat
Color: Grey stripe with some orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She got out sometime early this morning. We are staying in Urbandale temporarily so she is not familiar with the area. She is very fat and well loved by my 3 kids. She is not declawed but is very friendly and loves to be scratched on the head. Last seen on Buena Vista Ct. close to Lake Halice in Urbandale. Answers to the name of Josie.
Des Moines - East
Lost: 8/30/2020
ID: 14885
Name: Grey
Type: Cat
Color: grey white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
If found please call last seen on capitol an e 16th
Des Moines - East
Lost: 8/30/2020
ID: 14866
Name: Cooper
Type: Cat
Color: All Dark grey with Green eyes Medium Long Hair
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Found! Safe and Hungry.
Windsor Heights
Lost: 8/30/2020
ID: 14850
Name: Reece
Type: Cat
Color: Black with Gold and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen off of 46th Street and Kingman, she’s feisty and probably won’t let you hold her easily but if there’s any sighting of her please help. She means the absolute world to me.
Ames
Lost: 8/29/2020
ID: 14863
Name: Sophia
Type: Cat
Color: Gray, white/tanish spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen 1311 mayfield dr. Ames, IA Very nice, scared easily, entice with food. Does gave both sets of claws. White/tanish patch on chest.
Des Moines - South
Lost: 8/29/2020
ID: 14851
Name: Fiona
Type: Cat
Color: Grey with 1 tan strip across back
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at Elmcrest Apartments right next to the post office. Usually comes when you call her BABY GRRR! We have had her since she was born please help find her!! Thank you.
Afton
Lost: 8/29/2020
ID: 14847
Name: Sherman
Type: Cat
Color: Dark grey, light grey, white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
3 AM morning of the 30th
Johnston
Lost: 8/29/2020
ID: 14839
Name: Diablo
Type: Cat
Color: Brown striped, especially on legs, with blue eyes
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Ran out of garage near Village at Johnston Station townhomes on NW 55th Ave, skittish around strangers, long legged and lean, loves his canned catfood