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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Humboldt
Lost: 5/27/2021
ID: 16818
Name: Poppy
Type: Cat
Color: grey mackerel tabby & white
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen near 11th St. N & 3rd Ave. N in Humboldt. She is shy & has never been outside. She will likely run but may come to the sound of food or similar sound.
West Des Moines
Lost: 5/27/2021
ID: 16811
Name: Dante
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Behind Legion Park in Valley Junction. Skittish, may come to someone with food. Not a jumper, so underneath porches/plants more likely.
Des Moines - South
Lost: 5/26/2021
ID: 16905
Name: Captain
Type: Cat
Color: Grey
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Young
Last seen SW 9th and Olinda
Des Moines - North
Lost: 5/26/2021
ID: 16800
Name:
Type: Dog
Color: Black and white
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
Hillcrest Drive Des Moines off of Lower Beaver
Des Moines - Central
Lost: 5/26/2021
ID: 16794
Name: Binx
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
I last seen her 820 at my house at 704 Buchanan St
Holstein
Lost: 5/25/2021
ID: 16970
Name: Oden
Type: Dog
Color: Black/silver with white markings
Breed: Anatolian Shepherd
Gender: Male
Fixed: Not Applicable
Age: Adult
Most likely with cream female. Anatolian cross
Holstein
Lost: 5/25/2021
ID: 16969
Name: Freya
Type: Dog
Color: Cream with black markings on face
Breed: Anatolian Shepherd
Gender: Male
Fixed: Not Applicable
Age: Adult
Mason City
Lost: 5/25/2021
ID: 16799
Name: Scrappy
Type: Dog
Color: cream
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
1003 Elm Dr mason city iowa 50401
Des Moines - West
Lost: 5/25/2021
ID: 16780
Name: Benji
Type: Dog
Color: Buff
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 5/24/2021
ID: 16900
Name: Sonny
Type: Cat
Color: Orange and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Had a bow tie on at home but took it off Sonny for the night. He slipped out of house and didn’t come back :/ Visiting dog at the house prob scared him. Please help find our friend!! He may have been starting to get a cold at the time :(
Des Moines - North
Lost: 5/24/2021
ID: 16899
Name: Sonny
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He slipped out of the house and never came back. Might have been starting to have a cold (respiratory problem). We had an extra dog at the house and it must have scared him. I just got him a collar with his name printed on it but it wasn’t on. Had a bow tie on but I had taken it off for the night before
Urbandale
Lost: 5/24/2021
ID: 16785
Name: Toby
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
On 150th st
Urbandale
Lost: 5/24/2021
ID: 16784
Name: Toby
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 150th Street im Urbandale. white on right side of his face.
Des Moines - South
Lost: 5/24/2021
ID: 16779
Name: Mo
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Southridge mall area.
Swisher
Lost: 5/23/2021
ID: 16795
Name: EMMY
Type: Dog
Color: Tan Black Grey
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
At her property Amana Rd Nw
Iowa City
Lost: 5/23/2021
ID: 16791
Name: Emmie
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
Last seen on the Amana Road in Iowa/Johnson County area
West Des Moines
Lost: 5/23/2021
ID: 16777
Name: Moon Pie
Type: Cat
Color: Black with white markings on her chest and tummy
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Adult
She escaped from our apartment Sun Prairie Apartments the evening of 5/23.
Des Moines - East
Lost: 5/23/2021
ID: 16769
Name: Simba
Type: Cat
Color: Yellow
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
At the corner of Guthrie Ave and Union. Yellow. Overweight. In the middle of a trim. Three bald spots on back. Very skittish, but friendly after he gets to know you.
Des Moines - South
Lost: 5/22/2021
ID: 16776
Name: Peanut
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
Seen just North of DM Airport. Foster Dog, scared, he is not healthy. Not aggressive.
Waukee
Lost: 5/22/2021
ID: 16761
Name: Finley
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Baby
Very friendly. Last seen on woodcreek drive in Waukee in the middle of the night.
Burlington
Lost: 5/22/2021
ID: 16760
Name: Brick
Type: Dog
Color: Black with a white chest
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
North 8th and iowa
Grimes
Lost: 5/21/2021
ID: 16773
Name: Nash
Type: Cat
Color: White, Black, Tan
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Nash is an avid hunter. He has bright green eyes and is very friendly. However he will ignore you and talk back if he is hunting. He will turn his head if you call his name.
Ankeny
Lost: 5/21/2021
ID: 16765
Name: Grizzley
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Been missing since yesterday. Last seen NW 2nd street in Ankeny. Very friendly, will be scared, approach slowly but do not chase, please call Megan at +1 (515) 954-5754, please help us find him, he has 3 little boys at home waiting for him!
Des Moines - South
Lost: 5/21/2021
ID: 16763
Name: Peanut
Type: Dog
Color: orange/black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
peanut is a rescue/ foster dog visiting from chicago. He is very timid, but very friendly. He ran away friday night not had any shots, has Mange but not contagious. He has been treated already, has heartworm and is taking antibiotics. I have only been fostering him 1 week so he is afraid of everything.
Ames
Lost: 5/21/2021
ID: 16762
Name: Yuan Yuan
Type: Cat
Color: orange, white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is an orange cat, but the color is more like the mix of coffee and milk. His belly is white and his tail is orange.