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>='1606521600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 7/21/2020
ID: 14534
Name: Winchester (Winnie)
Type: Dog
Color: Black
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Senior
Lost near Crestbruck Park. He doesn’t see well due to cataracts and is mostly deaf due to age.
Arispe
Lost: 7/21/2020
ID: 14532
Name:
Type: Dog
Color: black & brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Have him at my home
Des Moines - West
Lost: 7/21/2020
ID: 14531
Name: Bandit
Type: Dog
Color: Black, white and brown
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Des Moines - North
Lost: 7/20/2020
ID: 14528
Name: Lily
Type: Dog
Color: Blonde/ yellow
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
2nd ave and Madison Maybe timid but is very kind
Des Moines - Central
Lost: 7/20/2020
ID: 14526
Name: Yoda
Type: Cat
Color: Grey/ White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Gateway Lofts/ Downtown Des Moines
Des Moines - West
Lost: 7/19/2020
ID: 14552
Name: Dub Love
Type: Cat
Color: All black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Dub likes to sleep all day and wander all night. He’s a good cat very loving.
Des Moines - West
Lost: 7/19/2020
ID: 14551
Name: Dub Love
Type: Cat
Color: All black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Dub likes to sleep all day and wander all night. He’s a good cat very loving.
Ankeny
Lost: 7/18/2020
ID: 14525
Name: Mittens
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the Meadow Ridge area off of SE Delaware Ave. he has two white patches on the underside of him. Tint of brown to fur when in sunlight/light
Windsor Heights
Lost: 7/18/2020
ID: 14519
Name: Shadow
Type: Dog
Color: black and white
Breed: Domestic Long Hair
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
Norwalk
Lost: 7/15/2020
ID: 15449
Name: Quiver
Type: Cat
Color: Orange, white tabby
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She is shy but sweet. She has a microchip!
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.