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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Adel
Lost: 7/15/2017
ID: 6237
Name: Jordy
Type: Dog
Color: Gold/yellow
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - West
Lost: 7/14/2017
ID: 6226
Name: Steve
Type: Cat
Color: Tan and Brown Siamese
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Steve was last seen on 7/14 at 9 pm. The tip of one of his ears is missing. We live one block east of Beaver Ave and 1 1/2 block North of Hickman Ave so right in the heart of Beaverdale. He loves us his family completely, but he is wary of strangers. He will warm up to you. He loves canned cat food and usually comes running when we snap the can open. If you see him please feel free to call my cell phone: 515-490-5717. He befriended us as a stray 8 years ago and he has never stopped saying thank you to us. Best cat I have ever owned. Thank you to everyone who looks.
Des Moines - North
Lost: 7/14/2017
ID: 6223
Name: Steve
Type: Cat
Color: Siamese: tan/brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Steve is a Siamese with the tip of one ear missing. He was last seen at 9 pm on 7/14. I live in the Beaverdale area of Des Moines.
Des Moines - South
Lost: 7/14/2017
ID: 6215
Name: Wade
Type: Dog
Color: Brown with black stripe on back
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
By evergreen apartments
Des Moines - Central
Lost: 7/14/2017
ID: 6213
Name: Mavis
Type: Cat
Color: White
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
We believe Mavis got out of the house between 4 and 9 pm on Friday. She is not wearing a collar. She's a bigger white cat with a gray/black tail. She is so sweet and we miss her!!!!
Waterville
Lost: 7/13/2017
ID: 6245
Name: Peede
Type: Dog
Color: Black and White
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
2 dogs (Peede and Sassy) strayed from our farm. They could have ranged very far by now. Any sightings E. of Waukon would be rewarded.
Ankeny
Lost: 7/13/2017
ID: 6222
Name: Vinny
Type: Cat
Color: Grey and black striped w/ green eyes
Breed: Ocicat
Gender: Male
Fixed: Not Neutered
Age: Young
We just rescued this cat and brought him home but he slipped out at our home off 49th in North Ankeny. He has ear mites and needs to get to vet. He is VERY sweet. I don't yet know how he will react if called to. My kids are devastated so if you see him please get in touch.
Iowa City
Lost: 7/12/2017
ID: 6355
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Cedar Rapids
Lost: 7/12/2017
ID: 6354
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Burlington
Lost: 7/12/2017
ID: 6353
Name:
Type: Dog
Color:
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Des Moines - South
Lost: 7/12/2017
ID: 6350
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
At home inside. Daughter came home after work to find she was missing from inside the home. MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Des Moines - Central
Lost: 7/12/2017
ID: 6349
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
At home inside. Daughter came home after work to find she was missing from inside the home. https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/19990243_10211652034834625_2739597610809816448_n.jpg?oh=0e7ee74668ab446201f4ae959b818979&oe=5A37F641 https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/20108236_10211652034914627_7198831696189497554_n.jpg?oh=c36514d6ec5c9b512c334e6767c97475&oe=59FF2D93 MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Marshalltown
Lost: 7/12/2017
ID: 6348
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
At home inside. Daughter came home after work to find she was missing from inside the home. https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/19990243_10211652034834625_2739597610809816448_n.jpg?oh=0e7ee74668ab446201f4ae959b818979&oe=5A37F641 https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/20108236_10211652034914627_7198831696189497554_n.jpg?oh=c36514d6ec5c9b512c334e6767c97475&oe=59FF2D93 MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Ottumwa
Lost: 7/12/2017
ID: 6347
Name: Teala
Type: Dog
Color: gray and white
Breed: French Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
At home inside. Daughter came home after work to find she was missing from inside the home. https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/19990243_10211652034834625_2739597610809816448_n.jpg?oh=0e7ee74668ab446201f4ae959b818979&oe=5A37F641 https://scontent-ort2-2.xx.fbcdn.net/v/t1.0-9/20108236_10211652034914627_7198831696189497554_n.jpg?oh=c36514d6ec5c9b512c334e6767c97475&oe=59FF2D93 MISSING (Update) Last seen 7/12/17 around 12:00PM west of Birmingham, IA at our country home. $1000.00 reward for her return, no questions asked. $100.00 to anyone able to provide information or insight to her whereabouts. Description: Blue French Bulldog, brown eyes, distinct white chest markings, roughly 25 pounds. Please call (641)919-5318.
Des Moines - East
Lost: 7/12/2017
ID: 6212
Name: Connie and fran
Type: Pig
Color: One black one black and white
Breed: Pot Bellied
Gender: Female
Fixed: Not Neutered
Age: Adult
Ankeny
Lost: 7/11/2017
ID: 6235
Name: Rosie
Type: Cat
Color: Black
Breed: Pot Bellied
Gender: Female
Fixed: Neutered
Age: Young
16th St Ankeny Iowa
Clive
Lost: 7/11/2017
ID: 6193
Name: Bella
Type: Dog
Color: Brown and Black
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
Heading towards Hickman road
Clive
Lost: 7/11/2017
ID: 6178
Name: Bella
Type: Dog
Color: Brown and Black
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
At 164th street near clive/Urbandale border at 164th and Aurora
Urbandale
Lost: 7/11/2017
ID: 6176
Name: Casper
Type: Cat
Color: Orange and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 7/10/2017
ID: 6742
Name: Asia
Type: Cat
Color: All grey
Breed: Manx
Gender: Female
Fixed: Neutered
Age: Young
She got out Monday morning around 2am-7am in north Ankeny. She's been missing for almost two months and is microchipped. If you see anything resembling her please contact the ARL! We miss her dearly and want her home safe.
Le Mars
Lost: 7/10/2017
ID: 6430
Name: Annie
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen playing in the backyard with her sister Bmo, a small calico shorthair. Both have been missing ever since. Offering reward for their safe return.
Le Mars
Lost: 7/10/2017
ID: 6429
Name: Bmo
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen playing in the backyard with her sister Annie, a small black shorthair female. Haven't seen either of them since. Offering reward for their safe return.
West Des Moines
Lost: 7/10/2017
ID: 6166
Name: Sammy
Type: Reptile
Color: Tan/Brown
Breed: Turtle
Gender: Male
Fixed: Unknown
Age: Young
Sammy was last seen in our fenced back yard on 7/10/17. When we checked on him in the early evening he was missing and there was a hole in the hurricane fence. The location is on 59th St in West Des Moines. Our yard backs up to 60th between Ashworth and Vista.
Ames
Lost: 7/10/2017
ID: 6160
Name: Hot Shell Rae
Type: Reptile
Color:
Breed: Turtle
Gender: Male
Fixed: Unknown
Age: Young
Last seen near the river down South Riverside Dr.
Ankeny
Lost: 7/10/2017
ID: 6157
Name: Asia
Type: Cat
Color: Gray
Breed: Turtle
Gender: Female
Fixed: Neutered
Age: Adult
May have seen her running around 49th street in North Ankeny. She is unlikely to walk up to anyone and will run away if you try to get her.