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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Allison
Lost: 8/15/2018
ID: 9396
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Cute little kitty roaming on HWY 3 in country not near a home. Between Allison & Dumont. No colllar.
Des Moines - Central
Lost: 8/14/2018
ID: 9956
Name: Rosco y primo
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Hi they left from my yard and they were rescued and the animal rescue asked for 400$ for vaccines es when they did have vaccinated until 2019 instead or help ppl they are ripping ppl off and my daughter is suffering she doesn't want to go to school she is mad a me etc.so pleae I beg you if you see them location or the new temporary owner call me at 917-284-5336 so we can come to some aggreement.thank you Alberto
West Liberty
Lost: 8/14/2018
ID: 9393
Name: Monk
Type: Cat
Color: Black with a white spot on front of neck
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Last seen at 7AM on August 14. 9-10 years old and about 8 lbs. Monk has a thyroid disorder (that's why he's pretty small right now) and needs his medicine! He has a small notch on the tip of his right ear from an injury when he was a kitten. Extremely friendly (so, he may have willingly gone off with someone!).
Des Moines - North
Lost: 8/14/2018
ID: 9388
Name: Oreo
Type: Dog
Color: Black white, little brown on face
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
By park fair mall.
Pleasant Hill
Lost: 8/13/2018
ID: 9414
Name: Oakley
Type: Dog
Color: Black
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Young
Pleasant Hill
Lost: 8/13/2018
ID: 9413
Name: Oakley
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Urbandale
Lost: 8/13/2018
ID: 9392
Name: Juicy
Type: Cat
Color: Grey, white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly, likes to be outside.
Clive
Lost: 8/13/2018
ID: 9382
Name: Unknown
Type: Cat
Color: Charcoal Gray with White Socks
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
At Boston Parkway and NW 164th Street, Clive.
Ankeny
Lost: 8/13/2018
ID: 9370
Name: Max
Type: Dog
Color: Tan and Black
Breed: Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
In Ankeny near Georgetown Blvd and Ankeny Blvd. He is friendly and has the energy of a 6 month old pup.
Des Moines - East
Lost: 8/12/2018
ID: 9427
Name: Arya
Type: Cat
Color: Grey tortie
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Last seen at 19th st and Capitol Avenue. I let the dogs out at 3am and she bolted. Normally she hangs around and comes back so far I have not found her. She hates to be held but very loving cat. Will rub up on you. Has a fat roll underneath. She's an inside cat and just recently started trying to escape all the time. She will be 2 in September and her twin is very sad without her. 515-494-8852
Audubon
Lost: 8/12/2018
ID: 9410
Name: Phoenix “Callie” Phantom Phyllis
Type: Dog
Color: Black & Tan/Brown Phantom Color
Breed: Poodle Toy
Gender: Female
Fixed: Unknown
Age: Young
Last seen near Chicago St, Audubon, IA. Last appearance with unfinished haircut, no collar. About 7lbs, 8inches tall from head to toe. She survived the fire with us so she really haa a sentimental value for my family. I can't sleep good thinking about her and I am so worried about her... Please help us find her. I am willing to give a reward to anyone who can find and bring her back to us safe and sound... Thank you so much...
Ogden
Lost: 8/12/2018
ID: 9400
Name: Sammy
Type: Cat
Color: White/striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's a very large cat. Hes probably scared but when he's comfortable he's super friendly. He was lost at 214 E Walnut St in Ogden.
Ankeny
Lost: 8/12/2018
ID: 9373
Name: Storm
Type: Cat
Color: Multi
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen last night around bricktown apartments. He is super friendly and also responds to bubbas.
Des Moines - North
Lost: 8/12/2018
ID: 9372
Name: Chloe
Type: Dog
Color: Black
Breed: Norwegian Elkhound
Gender: Female
Fixed: Neutered
Age: Young
Nw 2nd ave and 54th last seen
Adel
Lost: 8/12/2018
ID: 9368
Name: Grace
Type: Dog
Color: Tan/white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Friendly but, may not come up to you. May come for food.
Urbandale
Lost: 8/11/2018
ID: 9394
Name: Juicy
Type: Cat
Color: Grey, white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly, likes to be outdoors.
Des Moines - South
Lost: 8/11/2018
ID: 9384
Name: Teddy
Type: Dog
Color: White, black, and some brown
Breed: Lhasa Apso
Gender: Male
Fixed: Not Neutered
Age: Adult
Got lose on Elder Lane and is a companion pet.
Des Moines - Central
Lost: 8/11/2018
ID: 9374
Name: Jackie
Type: Cat
Color: Black and white .. Yellow eyes
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
Drake area... Cottage grove ave. Is where she got out.. Kind of fiesty..treats n tuna will help.
Des Moines - Central
Lost: 8/11/2018
ID: 9364
Name: Jackie
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
Yellow eyes..white chest..white feet
Urbandale
Lost: 8/11/2018
ID: 9362
Name: Payton
Type: Dog
Color: Black
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
64th st urbandale. Please call with anything news 319-389-6714
Des Moines - South
Lost: 8/11/2018
ID: 9361
Name: Siku
Type: Dog
Color: White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 1500 block of E Lacona Ave. Friendly dog, very shy. Should not be contained within a stranger’s home without direct supervision as he will likely cause damage to property.
Ankeny
Lost: 8/11/2018
ID: 9360
Name: Izzy
Type: Dog
Color: Brown
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Escaped from the back yard. Skittish. Scared of men.
Des Moines - Central
Lost: 8/10/2018
ID: 9355
Name: Zoltar
Type: Dog
Color: Black & White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
He was last seen by the BP on SW 9th just south of the Cityville Apartments. He is very friendly but can be skiddish. He slipped out of his collar so he will not have one on him.
Altoona
Lost: 8/10/2018
ID: 9354
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior
Altoona
Lost: 8/10/2018
ID: 9353
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior