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>='1600560000')) ORDER BY pm1.meta_value DESC, post_date DESC
Iowa City
Lost: 7/17/2020
ID: 14512
Name: Olive
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near 221 S Lucas St in Iowa City, Iowa. VERY shy with big eyes, a little bit of a gut. $200 reward
Johnston
Lost: 7/16/2020
ID: 14513
Name: Allie
Type: Cat
Color: Gray and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She goes outside every night, then comes back every morning. She is very nice and purrs very easily. She will not keep a collar on.
Des Moines - West
Lost: 7/16/2020
ID: 14510
Name:
Type: Dog
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Mitchellville
Lost: 7/15/2020
ID: 14527
Name: Ebony
Type: Cat
Color: black - except - The long fur that comes out of front of my ears is white now
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
I have always been an inside kitty – BUT July 15 - I snuck out and since I have NEVER lived outside can't find my way home! I'm an older kitty and have some vision and hearing problems I'm affectionate and love to be held and petted, I might try to jump into your arms The long fur that comes out of my ears is white now I live just south of old Hwy. 6 right between Colfax and Monroe
Des Moines - North
Lost: 7/15/2020
ID: 14508
Name: Husker
Type: Dog
Color: Black white tan
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 7/15/2020
ID: 14505
Name: Kaja
Type: Dog
Color: brown
Breed: Schnauzer Miniature
Gender: Unknown
Fixed: Unknown
Age: Adult
kaja is shy and can’t see well. she is not aggressive. she was last seen on college and 13th.
Des Moines - North
Lost: 7/14/2020
ID: 14504
Name: Norman
Type: Cat
Color: Flea collar
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Neighbor day him at 4:30.
West Des Moines
Lost: 7/14/2020
ID: 14502
Name: LEEroy
Type: Cat
Color: Tabby
Breed: Russian Blue
Gender: Female
Fixed: Unknown
Age: Young
She is shy. Loves dogs. Fast as can be!
Waukee
Lost: 7/13/2020
ID: 14500
Name: Fickle
Type: Cat
Color: Black
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Has his claws but is nice. Slight patch of hair missing on one front leg.
Des Moines - South
Lost: 7/13/2020
ID: 14499
Name: Ahsoka
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Baby
Greenfield plaza, off countyline road. Got out of the house while basement was being worked on. 6 months old calico, front declawed, no collar
Des Moines - Central
Lost: 7/13/2020
ID: 14497
Name: Louise
Type: Dog
Color: Black
Breed: Chinese Shar-Pei
Gender: Female
Fixed: Unknown
Age: Adult
Last seen running west on Martin Luther king jr parkway, no collar she slipped out of it.
Des Moines - South
Lost: 7/12/2020
ID: 14498
Name: Cujo
Type: Dog
Color: Brown with white stomach
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen walking with a gentleman around the Pete Crivaro Park area. Her tags fell off. Very friendly, loves to gives kisses. Shes my baby and i miss her and would like her home.
Des Moines - West
Lost: 7/12/2020
ID: 14491
Name: Kody
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Unknown
Fixed: Neutered
Age: Adult
28th and high street chip has Overland park address
Des Moines - West
Lost: 7/12/2020
ID: 14486
Name: Norah
Type: Dog
Color: Tri color
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
Around 6:30 at 44rd and Kingman
Des Moines - East
Lost: 7/12/2020
ID: 14481
Name: Josie
Type: Dog
Color: Brindle with lots of white on her head and chest
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Baby
Last seen at 7:45 am on Brook Ridge Court, Des Moines. She was seen running south in the field east of Brook Ridge Ct and west of 56th street.
Ankeny
Lost: 7/11/2020
ID: 14485
Name: Bernie
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Last seen late Saturday night near Crestbruck Park
Des Moines - North
Lost: 7/11/2020
ID: 14484
Name: Oliver Sanders
Type: Dog
Color: Black, White, Brown face
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Young
Brandon
Lost: 7/11/2020
ID: 14474
Name: Rocket
Type: Dog
Color: Tan
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Young
Lost after car accident on I-380 S at mile marker 48/49 near Brandon, Iowa. Fast runner, barks, but won’t bite. Owners not from the are but were traveling through.
Des Moines - South
Lost: 7/11/2020
ID: 14469
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
SW 12th and Virginia. Very friendly and cuddly cat/kitten. When called it responded and came to me. Pretty sure it’s a female. Offered water and food and it refused so hopefully it’s close to home.
Ankeny
Lost: 7/10/2020
ID: 14524
Name: Baby kitty
Type: Cat
Color: White
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
NW SIDE OF ANKENY HE GOT OUT AND NORMALLY COMES BACK BUT HAS NOT THIS TIME. He really likes to climb things and has hints of black in a couple places.
Burlington
Lost: 7/10/2020
ID: 14511
Name: Chase
Type: Dog
Color: Tan and white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
Last seen around Miller Street and Harrison near Great River Christian School in Burlington, IA. He is microchipped. His family misses him.
Ankeny
Lost: 7/10/2020
ID: 14506
Name: Appa
Type: Cat
Color: Grey & White
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Appa is now safely home.
Waukee
Lost: 7/10/2020
ID: 14489
Name: Mia
Type: Cat
Color: Gray and White
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
Mia has vertigo and is on a topical antibiotic for her eye. She is really wobbly on her feet right now. She was at the door meowing the other day and my son let her out. She never came back.
Algona
Lost: 7/10/2020
ID: 14478
Name: Millie
Type: Dog
Color: Red and tan
Breed: Australian Cattle Dog
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Smith Lake Campground area north of Algona. She is a skittish and scared dog
Audubon
Lost: 7/10/2020
ID: 14477
Name: Pixie
Type: Dog
Color: Black and White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
She is slim and her coat from the winter just blew out so she is not as fluffy as huskys normally are. She is very sweet but scared at first