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
Indianola
Lost: 3/10/2016
ID: 2449
Name: Rio
Type: Bird
Color: Green, gray, yellow
Breed: Parrot
Gender: Male
Fixed: Unknown
Age: Young
Indianola Iowa South 1st St
Des Moines - Central
Lost: 3/9/2016
ID: 2520
Name: Harley
Type: Dog
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen near 13th&forest near Forest Park. Very friendly. He is my everything please help me find him!
Albia
Lost: 3/9/2016
ID: 2491
Name: Sargent
Type: Dog
Color: Red
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Western monroe county
Des Moines - West
Lost: 3/9/2016
ID: 2443
Name: Thunder
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 12:30 on Wed. He has his front claws and a little white spot on his chest.
Des Moines - East
Lost: 3/8/2016
ID: 2452
Name: Marley
Type: Cat
Color: Grey white stripped
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He got out the back door when I was taking the trash out, he is our baby and we've looked everywhere for our baby. Please help us find Marley
West Des Moines
Lost: 3/8/2016
ID: 2435
Name: JOEY
Type: Dog
Color: BLACK AND WHITE
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at 2501 Westown Parkway, West Des Moines, IA. Please call 515-720-8582
Davenport
Lost: 3/8/2016
ID: 2432
Name: micah
Type: Dog
Color: black
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 3/7/2016
ID: 2429
Name: Nini
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Got outside overnight around se 19th and park, she's very friendly to some and skittish around during others ,she has a white tipped ear and a little white on her chest
Elk Run Heights
Lost: 3/5/2016
ID: 8829
Name: Morty
Type: Cat
Color: Tiger-Grey, Black, Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Toneff and James in Elk Run Heights near the truck stops at Evansdale Highway 20. Friendly. Likes to go for rides. Male, Tiger -Grey, black, brown. Aqua-blue eyes. Neutered. Drools when he purrs.
Altoona
Lost: 3/5/2016
ID: 2417
Name: Joe Joe
Type: Cat
Color: Black and white striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen Saturday morning March 5th 2016.
Des Moines - East
Lost: 3/4/2016
ID: 2413
Name: tiger/pancho
Type: Cat
Color: white with orange spots
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
He has a stripped tail and is very kind. If anyone sees him please contact. Thankyou very very much
Des Moines - South
Lost: 3/4/2016
ID: 2412
Name: Gavin
Type: Cat
Color: white and orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
I last seen him around dinner ume.. He is an indoor cat.. Very lovable. Likes people. Very sweet. He's around 1 year old .. Hes white with orange on his back and tail . has orange on his ears and above his eyes
Des Moines - South
Lost: 3/4/2016
ID: 2411
Name: Gavin
Type: Cat
Color: white and orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
I last seen him around dinner ume.. He is an indoor cat.. Very lovable. Likes people. Very sweet. He's around 1 year old .. Hes white with orange on his back and tail . has orange on his ears and above his eyes
Des Moines - East
Lost: 3/2/2016
ID: 2404
Name: Gabriel
Type: Cat
Color: Black with white spot on chest
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Declawed in the front
Yale
Lost: 3/1/2016
ID: 2399
Name: Skeeter / princess
Type: Dog
Color:
Breed: Shih Tzu
Gender: Unknown
Fixed: Not Neutered
Age: Young
Male and female Skeeter and princess last seen east of Yale 4 miles....
Lisbon
Lost: 2/29/2016
ID: 2427
Name: Weston
Type: Dog
Color: Liver/roan (brown with dark grey ticking)
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Last see near Adams Ave in Lisbon on March 2nd
Des Moines - Central
Lost: 2/29/2016
ID: 2396
Name: Cody
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 46th and University with our pregnant yellow lab- which was hit and killed by a car. Witness said Cody ran north. This was at 7pm on 2/29/16. Cody is friendly.
Des Moines - North
Lost: 2/28/2016
ID: 2394
Name: Jet (but will come to BABY)
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
We were moving to our new house, she jumped out of the jeep at NE 10th and NE 54th Ave. Saydel High School area. New surroundings for her, she is a rescued kitty, she has a cleft lip and a weeping left eye.
Ankeny
Lost: 2/28/2016
ID: 2386
Name: Daisy
Type: Dog
Color: Brown with white belly
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Young
SE side of Ankeny Skiddish but friendly Can out run a deer
Davenport
Lost: 2/26/2016
ID: 2380
Name: Coco
Type: Dog
Color: White with tan spots everwhere
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
She came out of our fence off NW Blvd (close to 53rd). Our backyard backs up to the. Ew bar, Public House. She's very friendly and I can see her going to greet guests as they came or went. She's awesome and we hope to get her back safely with your help!! Thank you!!!
Des Moines - East
Lost: 2/25/2016
ID: 2375
Name:
Type: Dog
Color: White brown black
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
This dog has been wandering in the east 36th street and east 36th court area north of university ave . I called animal control today to look for it, not sure if they found it.
Dexter
Lost: 2/23/2016
ID: 2372
Name: Jäger
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Jäger is EXTREMLY FRIENDLY lost at Diamondhead Lake he is an old guy and has all his shots he may be limping by now from arthritis. He loves to fetch sticks. Please call 515-523-1921
Des Moines - East
Lost: 2/23/2016
ID: 2371
Name: Abby
Type: Dog
Color: Reddish brown and white
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Unknown
Age: Adult
She got out of the yard early Tuesday morning
Des Moines - Central
Lost: 2/22/2016
ID: 2362
Name:
Type: Dog
Color: Brown and White
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Unknown
Age: Adult
Found at 48th and Hickman at 4:30 on 2/22
Des Moines - North
Lost: 2/21/2016
ID: 2358
Name: ringo star
Type: Cat
Color: white with grey ears and ringlets on tail
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
North east side York st and Guthrie ave. He belongs to 5 kids and his best friend is our dog very friendly plz help