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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/16/2019
ID: 12160
Name: Lucy
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 8/16/2019
ID: 12136
Name:
Type: Dog
Color:
Breed: Bichon Frise
Gender: Unknown
Fixed: Neutered
Age: Senior
North of North high school, in Des Moines. Has id tags and license.
Denver
Lost: 8/16/2019
ID: 12134
Name: Scruffy (adopted name is Ike)
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Young
Denver Iowa cross street Killdeer Ave. and 260th St.
Des Moines - Central
Lost: 8/14/2019
ID: 12149
Name: Beans
Type: Cat
Color: Tan/black
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Adult
54th st. Between Madison and Aurora. Ran west. He walks with a limp due to his right leg being broken.
Des Moines - South
Lost: 8/14/2019
ID: 12135
Name: Bella
Type: Cat
Color: Orange,black, and fawn
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Adult
She has an orange spot on her forehead.
Dubuque
Lost: 8/13/2019
ID: 12156
Name: Annabelle
Type: Dog
Color: black
Breed: Labradoodle
Gender: Female
Fixed: Unknown
Age: Adult
my ex-wife gave her to lady Amy McDermott is her name
Des Moines - Central
Lost: 8/11/2019
ID: 12108
Name: mindy aronow
Type: Cat
Color: black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
She lives at 4650 NW 52 street She is black long haired She is spayed. She goes by Sally and will come when called
Ankeny
Lost: 8/11/2019
ID: 12106
Name: Koby
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Washington
Lost: 8/11/2019
ID: 12105
Name: Ellen
Type: Dog
Color: White
Breed: Pointer
Gender: Female
Fixed: Neutered
Age: Senior
She is not familiar with running in the fields and farms. She may be afraid of people but she is used to the sound of four-wheelers. She is a retired sled dog and may follow along if you find her. She has pine tar dripping on her back from laying under the pine tree. And I've tried to give her a hair cut so you can see where I've clipped her hair.
Des Moines - South
Lost: 8/11/2019
ID: 12103
Name: Archer and Doby
Type: Dog
Color: White black and brown
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Sw 14th
Des Moines - Central
Lost: 8/11/2019
ID: 12098
Name: KC
Type: Dog
Color: Black
Breed: Bearded Collie
Gender: Male
Fixed: Not Neutered
Age: Young
Last night in our backyard around 10PM on 8/10... by indianola ave and Jackson elementary
Des Moines - Central
Lost: 8/11/2019
ID: 12097
Name: Riley
Type: Dog
Color: White
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Young
In our backyard at 10pm on 8/10/19... right on indianola ave by Jackson elementary
Des Moines - Central
Lost: 8/9/2019
ID: 12117
Name: Tuxedo
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Tuxedo was last seen on Friday night. We moved houses and he has a way of making it back to the old house. He went missing in the Roosevelt drake area and does not have a collar on. If anyone has seen or has him please contact me at (515)-508-1802 we miss him dearly and are very concerned as he is old.
Keystone
Lost: 8/9/2019
ID: 12115
Name: Wednesday
Type: Dog
Color: Brindle
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Young
Last seen on 72nd street in keystone. She has one eye and needs her medication 4 times a day. She is special needs
Des Moines - East
Lost: 8/9/2019
ID: 12110
Name: Sunshine comes to kitty kitty
Type: Cat
Color: Orange/yellos tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
InsIde only cat she got out sometime Friday when the sliding glass door was open for someone coming in or out....
Urbandale
Lost: 8/9/2019
ID: 12109
Name: Cheeto
Type: Cat
Color: Tiger striped & calico
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Very shy, quiet meow. Orange spot on forehead.
Mitchellville
Lost: 8/8/2019
ID: 12154
Name: Journey
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He was last seen near 2nd and Market in Mitchellville. He is a long, thin cat, almost a year old.
Waukee
Lost: 8/8/2019
ID: 12102
Name: Ben
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
On our front porch in Waukee, IA
Urbandale
Lost: 8/8/2019
ID: 12088
Name: Colbalt
Type: Cat
Color: White with gray tips
Breed: Ragdoll
Gender: Male
Fixed: Neutered
Age: Adult
In the house
Des Moines - West
Lost: 8/7/2019
ID: 12126
Name: Morgan
Type: Dog
Color: Black with white underside
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 23rd and Clark. Morgan is a very friendly dog. He is 5 years old. I purchased Morgan from the ARL as a surprise birthday gift for son's 8th birthday. Every since I can remember my son always said he wanted to rescue a dog and give it a nice home to come to. My son was on summer vacation with other family members when Morgan disappeared. If you have Morgan or see him please call his name, keep him in your possession, and please contact me via email at ebell3214@gmail.com. Thank you!
Des Moines - East
Lost: 8/7/2019
ID: 12122
Name: Max
Type: Dog
Color: Brown and white
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Young
3100 block E Sheridan
Peosta
Lost: 8/7/2019
ID: 12116
Name: Squirt
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 8/7/2019
ID: 12080
Name: Abbie
Type: Dog
Color: white with black markings
Breed: Fox Terrier
Gender: Female
Fixed: Neutered
Age: Senior
2335 Reynolds Lane, east des moines near Hubbell, Guthrie Aves , east 25th to 29th both north and south of guthrie ave. My dog is 15 yrs old and can't see or hear very well. she needs to drink a lot of water. could become dis-oriented. likes kids, cats, and other dogs.
Des Moines - East
Lost: 8/7/2019
ID: 12075
Name: Minnie and Lola
Type: Dog
Color: Minnie: White with black spots. Lola: black lab
Breed: Fox Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Got out of the gate on Leyden Ave and E42nd st.
Des Moines - East
Lost: 8/6/2019
ID: 12438
Name: Pharaoh
Type: Cat
Color: white, tan, black stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Disappeared south of fairgrounds, south of E. 30th viaduct and Scott Ave. South of Willard School.