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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Cumming
Lost: 12/25/2018
ID: 10322
Name: Molly
Type: Dog
Color: Black tan
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Young
She's sweet and will be missing her mama and home to the point she'll be crying til shes hm. please please help find her.
Ankeny
Lost: 12/25/2018
ID: 10315
Name: Oreo
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Possibly got out of our back door. I saw the screen door was open. We live on SW Springfield Drive in SW Ankeny.
Des Moines - South
Lost: 12/25/2018
ID: 10313
Name: Bellah n bruddah
Type: Dog
Color: Female tan male tan n white. 2-2mos puppies 1 black male with tan markings and1 black nwhite female
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen se14th n watrous. 2 small dogs and 2 puppies. Tan is named bellah female. Tan and white is named bruddah. And 2-2mos old pups. 1 black with tan markings named Dave. And 1 black and white named fatty Patty. No collar dug out approximately 1230 today
Colfax
Lost: 12/25/2018
ID: 10312
Name: Beau
Type: Dog
Color: Brown
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
2965 W 124th ST N Colfax. Likely running around with our other dog (white with brown spots, same breed). Both are very friendly!
Colfax
Lost: 12/25/2018
ID: 10311
Name: Bailey
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at 2965 W 124th ST N Colfax. She is likely running around with our other dog Beau (all brown). Both are very friendly!