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>='1600128000')) ORDER BY pm1.meta_value DESC, post_date DESC
Windsor Heights
Lost: 7/18/2020
ID: 14519
Name: Shadow
Type: Dog
Color: black and white
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
1600 block of 56th St very people-friendly
Cedar Rapids
Lost: 7/18/2020
ID: 14518
Name: Sammy
Type: Dog
Color: Grey
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
He got out of the yard about 10pm Saturday night from 3905 Lennox Ave NE Cedar Rapids IA 52402
Cedar Rapids
Lost: 7/18/2020
ID: 14517
Name: Sammy
Type: Dog
Color: Grey
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Senior
He got out of the yard about 10 pm Saturday night and wondered off.
Tama
Lost: 7/17/2020
ID: 14758
Name: Obie
Type: Cat
Color: Orange Tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
He is friendly and is a cat that has been raised indoors his whole life.
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.