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
Des Moines - Central
Lost: 9/1/2017
ID: 6723
Name: Lil Buddy
Type: Cat
Color: Dark gray and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen at 28th in Brattleboro by Drake. He always walks neighborhood he's a 1 years old and his sister has been crying for him. He is never gone more then couple hours so I believe someone may have found him and took him. He belongs to my boyfriend who is worried about him. Funny to say but it's his Lil buddy and he needs him home.
Ames
Lost: 9/1/2017
ID: 6690
Name: Spud
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
North Ames, Somerset
Des Moines - West
Lost: 9/1/2017
ID: 6678
Name: Puppy
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Waukee
Lost: 9/1/2017
ID: 6664
Name: Ryder
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He snuck outside the house around 10pm on August 31st. He is declawed and an indoor cat. Last seen at 720 6th Street. Please call or text (515) 490-1440
Des Moines - South
Lost: 9/1/2017
ID: 6663
Name: Rella
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Around park sw 9th
Des Moines - East
Lost: 8/31/2017
ID: 6706
Name: Migo
Type: Cat
Color: Mostly white some orange
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Has ear and upper neck problems, roughly 12 yrs old. Very nice but skittish upon first meeting likes his fheeks pet softly and down his head and neck but only in the middle because it irritates him. His full name is amigo but we call him migi or migo. He is trained and weve had him his whole life almost.
Des Moines - East
Lost: 8/31/2017
ID: 6665
Name: Jubilee
Type: Dog
Color: White/black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 8/31/2017
ID: 6660
Name: Willis
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Waterbury area by Roosevelt High School. Has green-yellow eyes. He is a house cat and not used to being outside! Declawed.
Stanhope
Lost: 8/30/2017
ID: 6761
Name: Frank
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
5 month old puppy. Last seen on his porch at home in the country between Stanhope and Stratford.
Windsor Heights
Lost: 8/30/2017
ID:
Name: Julius
Type: Cat
Color: White with some grey
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
I can not load picture. He is just recently adopted about 2 months ago. He's an indoor cat so never has been outside. He's got blue/grey eyes and super bushy great tail. He got out at Colby Ave and 63rd. He's scared of people so I'm worry he's hiding and won't find his way home. He is chipped but does not wear collar.
Des Moines - East
Lost: 8/30/2017
ID: 6658
Name: Cash goes by Cash Cash
Type: Bird
Color: Green, red, yellow
Breed: Conure
Gender: Unknown
Fixed: Unknown
Age: Baby
He loves apples and he's a parrot so he is looking for a human to help him. Can be caught by throwing a towel on him if he doesn't come to you.
Ankeny
Lost: 8/30/2017
ID: 6644
Name: Ace
Type: Dog
Color: White and orange
Breed: Conure
Gender: Male
Fixed: Neutered
Age: Young
North side of Ankeny on high trestle trail.
Milo
Lost: 8/29/2017
ID: 6670
Name: Chewy
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Granger
Lost: 8/29/2017
ID: 6655
Name: Stark
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He's timid, especially around kids. If you see him please keep an eye on him and call.
Des Moines - Central
Lost: 8/29/2017
ID: 6648
Name:
Type: Cat
Color: Grey longhair
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Found downtown around court avenue district
Des Moines - Central
Lost: 8/29/2017
ID: 6647
Name:
Type: Cat
Color: Grey longhair
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Found downtown around court a venue
Altoona
Lost: 8/29/2017
ID: 6643
Name: Charlie
Type: Dog
Color: red/orangish brown with white patch on the top between the shoulders
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Senior
Has a sore on back of neck and right ear. Is 17 years old and friendly. will come to you if you call his name.
Urbandale
Lost: 8/29/2017
ID: 6642
Name: Milkshake
Type: Dog
Color: Grey/white
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Missing from 67th and Praire she is people friendly but does not like other dogs.
Des Moines - North
Lost: 8/29/2017
ID: 6637
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 8/29/2017
ID: 6636
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 8/29/2017
ID: 6635
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Lost: 8/29/2017
ID: 6631
Name: Company
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Neutered
Age: Young
Deer creek trail
Anamosa
Lost: 8/28/2017
ID: 6744
Name: Dale
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Lost sometime before 4pm. Got out of his fenced in kennel.
Anamosa
Lost: 8/28/2017
ID: 6661
Name: Dale
Type: Dog
Color: Brown/white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen in his kennel. He found a weak spot in the fence. Dale also had a shock collar on.
Clive
Lost: 8/28/2017
ID: 6626
Name: Newt
Type: Cat
Color: cream
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
on Drake St near 73rd ave.