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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 1/4/2019
ID: 10386
Name: Trinity (Trini)
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Super shy and hasn’t been out before! Will probably be super scared!
Des Moines - East
Lost: 1/3/2019
ID: 10461
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 1/3/2019
ID: 10432
Name: PRADA
Type: Dog
Color: BROWN & White- The bown is almost a greyish color...
Breed: Staffordshire Bull Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Young
East 40th st. And Dubuque- Des Moines, Ia....
Des Moines - East
Lost: 1/3/2019
ID: 10409
Name: Prada
Type: Dog
Color: Brown-(almost a gray) and White
Breed: Staffordshire Bull Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Baby
Last seen on 40th and Dubuque...
Bondurant
Lost: 1/3/2019
ID: 10393
Name: Chloe or Mama
Type: Cat
Color: white with black strips and a little gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
last known was Lincoln street between 3rd streets and 5th streets possibly in Se bondurant
Iowa City
Lost: 1/3/2019
ID: 10389
Name: KitKat
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
KitKat is an indoor-outdoor kitty, very friendly and curious. Lets people pet and hold her but would not wear a collar which makes people think that she is lost and needs to be rescued. If picked up, please let us know her whereabouts.
Des Moines - East
Lost: 1/3/2019
ID: 10385
Name: PRADA
Type: Dog
Color: BROWN/WHITE
Breed: Pit Bull
Gender: Unknown
Fixed: Not Applicable
Age: Young
Lost around East 40th st. By fairgrounds...
Waukee
Lost: 1/2/2019
ID: 10380
Name: Oliver
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He is very food motivated. May be the only way to catch him.
Waukee
Lost: 1/2/2019
ID: 10379
Name: Oliver
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He is very food motivated. May be the only way to catch him.
Clive
Lost: 1/1/2019
ID: 10472
Name:
Type: Cat
Color: yellow tabby
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly and talks to you a lot. Now at Furry friends
Des Moines - Central
Lost: 12/31/2018
ID: 10381
Name: Mickey
Type: Dog
Color: Black with white chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by 37th and Franklin in Basketball. Mickey is very friendly, loves to shake hands, is wearing his brown collar with his microchip number on it. My daughter absolutely adores him and we will pay to have him brought home.
Mitchellville
Lost: 12/31/2018
ID: 10375
Name: Lucy
Type: Cat
Color: Black & White tuxedo
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Bloomfield
Lost: 12/31/2018
ID: 10372
Name: Violet
Type: Dog
Color: White brown
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Baby
Northwest of belknap Iowa
Bloomfield
Lost: 12/31/2018
ID: 10371
Name: Violet
Type: Dog
Color: White with brown
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Young
North of Belknap Iowa
Waukee
Lost: 12/31/2018
ID: 10364
Name: Maggie
Type: Dog
Color: Grey
Breed: Poodle Miniature
Gender: Female
Fixed: Neutered
Age: Senior
Near Casey’s on NE Alice’s RD. Wearing navy blue fleece with purple harness underneath.
Norwalk
Lost: 12/30/2018
ID: 10377
Name: Smokey
Type: Dog
Color: Black with white on chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He was in norwalk and is very friendly. Has a rough spot on one ear. He has extra toes on the his back feet
Runnells
Lost: 12/29/2018
ID: 10383
Name: Copper
Type: Dog
Color: Tri-color
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
He has a white "c" marking on the back of his neck.
Creston
Lost: 12/28/2018
ID: 10447
Name: Big T
Type: Cat
Color: Green Eyes , White Goatee , Grey with Black Tiger-Striped Markings
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
“Big T” was last seen from his family and neighbors on the night of December 27th, 2018, coming home, from the 500 block of the North Vine Street area, in Creston. He is current on all shots as well. And although he does like to live his life outdoors, however, this is very uncharacteristic behavior for him. Creston Animal Rescue Efforts (C.A.R.E.), Dog Gone Rescue, Animal Control, and the city’s townsfolk have all been keeping their eyes peeled for the missing kitty. But no one has been able to spot him either. Please, help in our search for “Big T” by spreading the word and contacting us on any information that will lead to him, reuniting with his sisters and family. Thanks!
Iowa City
Lost: 12/28/2018
ID: 10346
Name: Isaac
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's a strictly indoor cat so I don't know exactly when or really how he got out. If his throat is felt, there's a "tube" that's cut short (not his windpipe but feels similar) from being attacked by a dog when he was a kitten. Has a white patch between his hind legs. Very fearful of strangers.
Adel
Lost: 12/27/2018
ID: 10418
Name: duke
Type: Dog
Color: black
Breed: Doberman Pinscher
Gender: Male
Fixed: Unknown
Age: Senior
on panther creek road
Ankeny
Lost: 12/27/2018
ID: 10333
Name: Ozzy
Type: Dog
Color: White and gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He is wearing a blue collar around his body
Randalia
Lost: 12/26/2018
ID: 10394
Name: Bella
Type: Dog
Color: brown
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
in Randalia, Iowa
Cumming
Lost: 12/25/2018
ID: 10357
Name: Molly
Type: Dog
Color: Black/Tan
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen 12/25/18, Evening. Lost at 120th Street and Vintage Avenue, Cumming; NE corner of Madison County. Very friendly 6 month old Rottweiler Puppy. If seen or found call: 319 431-1590
Altoona
Lost: 12/25/2018
ID: 10341
Name: Clark (kent)
Type: Cat
Color: Orange stripped
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
He only has three legs. He is missing one of his back legs. Very sweet.
Cumming
Lost: 12/25/2018
ID: 10324
Name: Molly
Type: Dog
Color: Black/Tan
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 7:30 PM; 6 month female puppy. At 120th St and Vintage Ave just off Cumming Road.