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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Cedar Rapids
Lost: 7/20/2017
ID: 6239
Name: Olivia
Type: Cat
Color: Gray
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
We last saw her in that house around 4:30pm-5:00pm
Stuart
Lost: 7/19/2017
ID: 6250
Name: Joe
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 7/19/2017
ID: 6236
Name: Totsie
Type: Cat
Color: Brown , black, gray
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
We live in apartments, probably ran out because screen is broken on patio door and I was on the patio sweeping
Woodbine
Lost: 7/17/2017
ID: 6280
Name: Kota
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Very nice
Des Moines - East
Lost: 7/17/2017
ID: 6238
Name: Marly
Type: Dog
Color: Black/white/grey mix
Breed: Pomeranian
Gender: Female
Fixed: Not Neutered
Age: Adult
I live at 21st and Capitol in East Des Moines. I was leaving my home and didn't realized she was behind me, she took off out the door after a rabbit.
Cedar Rapids
Lost: 7/16/2017
ID: 6258
Name: Bella
Type: Cat
Color: Multi color long hair
Breed: Norwegian Forest Cat
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen on 31st street near bever park SE side of cedar rapids. She is very friendly and loves to be held. Answers to the name Bella or Isabella. She may not have a collar on.
Ankeny
Lost: 7/16/2017
ID: 6219
Name:
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
She is super hot and with no where cool to keep her we are taking her to ARL MAIN @2:30pm
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