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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Redfield
Lost: 4/15/2016
ID: 2769
Name: Percy
Type: Cat
Color: Grey/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen Between redfield, IA & Adel, IA, near the Raccoon river. Microchip # 981020011369618
Urbandale
Lost: 4/15/2016
ID: 2754
Name: DEDE
Type: Cat
Color: multi grey with white on tip of chin and belly--- GREEN EYES (not a tabby)
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
10/22 and still missing --- lost 4/15 Originally lost that night from 3914 73rd street, Urbandale. Airline/Douglas and 73rd street. She is a hunter so strayed off. Timid, very gentle may not come to you so keep her there with food and call us right away. Microchipped, all shots up do date, Urbandale license
Des Moines - South
Lost: 4/15/2016
ID: 2731
Name: Peaches
Type: Cat
Color: Orange & White
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
I live on Stanton Ave. .1 block West of Fleur Dr. She has Cancer & needs hr Meds!!!
Ankeny
Lost: 4/15/2016
ID: 2692
Name: Copper
Type: Dog
Color: Red
Breed: Vizsla
Gender: Male
Fixed: Neutered
Age: Young
Last seen at Wanda Manor apartment. NE 5th st in Ankeny behind Mercy north. He is a hunting dog and enjoys chasing small game. Dont chase him, it makes him run further, he comes when he's ready.
Urbandale
Lost: 4/15/2016
ID: 2690
Name: DeDe
Type: Cat
Color: All Grey, light and dark, NOT a Tabby
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
5/8 still missing. Lost 4/15 Microchipped. ---- ID. 0A1327123E. Fri evening about 11pm... Shy, will not come to strangers. Try to call her and say DeDe lets "EAT". Microchip ID: 0A1327123E left home on the evening of 4/15, has been seen on 4/17 in 3900 Block of 73rd, 74th, call 515-770-9311 or 515-334-0796 and tell us where you found her.
Des Moines - East
Lost: 4/13/2016
ID: 2665
Name: KING
Type: Dog
Color: Brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - South
Lost: 4/13/2016
ID: 2662
Name: Royce
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Around SE 14th and park ave. area. He has a chipped front tooth.
Des Moines - East
Lost: 4/13/2016
ID: 2658
Name: Oscar
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Loves food . Very nice .
Bussey
Lost: 4/12/2016
ID: 2992
Name: Scarlet
Type: Dog
Color: Tricolor
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
She is my daughter's 7th birthday gift. Believe to be stolen. Reward offered.
Treynor
Lost: 4/12/2016
ID: 2722
Name: Ellie
Type: Dog
Color: White and black
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in town with a german shepard
Treynor
Lost: 4/12/2016
ID: 2661
Name: Ellie
Type: Dog
Color: White with black
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Ellie was last seen Tuesday April 12th at 10am. She's the sweetest and won't hurt you
Bondurant
Lost: 4/12/2016
ID: 2653
Name: Phillip
Type: Cat
Color: Yellow Tabby Manx
Breed: Manx
Gender: Male
Fixed: Unknown
Age: Adult
Has a short tail, is rather overweight, and timid around strangers. Very scared of other cats, but loves meat and will come for food. If found a reward will be given. 319-316-3032.
Des Moines - South
Lost: 4/12/2016
ID: 2652
Name: zoey
Type: Dog
Color: white
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on the south side of Des moines near James Cownie soccer complex
Altoona
Lost: 4/11/2016
ID: 2678
Name: Lego
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 4/11/2016. Lego is very sweet. He loves cat treats. His family misses him very much!! If you have seen him or have him please call. He is part of the family!!last seen 1st st e Altoona Iowa.
Des Moines - East
Lost: 4/9/2016
ID: 2670
Name: Rosco
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is scared of people he doesn't know well. Probably hiding somewhere.
Winfield
Lost: 4/7/2016
ID: 2643
Name: Nala and Daisy
Type: Dog
Color: Yellow Lab and Black Lab
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Last Seen at my house in winfield at 6 am thursday very loveable. My daughter best friends any help is a greatly appericated. Daisy Black lab has arthits in her back legs. I have a very heart broken 3 year old girl. PLEASE HELP
Des Moines - South
Lost: 4/7/2016
ID: 2637
Name: Tosser
Type: Cat
Color: White with orange spots
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
In our back yard took off heading west across fenced in yards
Lu Verne
Lost: 4/6/2016
ID: 2784
Name: Debo
Type: Dog
Color: Red with white
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Carpenter
Lost: 4/6/2016
ID: 2639
Name: Rebel
Type: Dog
Color: Blackish brown
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
He was seen on 4/7/2016, running south through a field, the people that saw him couldn't catch him.
Windsor Heights
Lost: 4/6/2016
ID: 2632
Name: EARL CRAIG
Type: Dog
Color: Blonde
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Earl is a blonde Shorkie. Shitzu and Yorkie mix. Last seen in Windsor Heights near 69th Street. Very skiddish and hard to catch. Please call 618-240-9015 ASAP if you see him.
Adel
Lost: 4/6/2016
ID: 2631
Name: Milli
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Female
Fixed: Unknown
Age: Young
Carlisle
Lost: 4/6/2016
ID: 2627
Name: Harley
Type: Dog
Color: Tan
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Carlisle in Hardin Dr. Very friendly. No collar on since he was able to get it off.
Des Moines - South
Lost: 4/6/2016
ID: 2626
Name: Chloe
Type: Dog
Color: Black/tan/white
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
last seen wearing a purple fleece with UNI on it and a pink harness
Des Moines - East
Lost: 4/6/2016
ID: 2625
Name: Jesse
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Senior
He will probably come if you call him. He's partially blind. Please let us know
Des Moines - East
Lost: 4/6/2016
ID:
Name: Fred
Type: Dog
Color: red and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
4212 Thompson Ave, Des Moines, Ia 50317. Entered woods towads Pleasent Hill and Copper Creek area