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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Garner
Lost: 7/9/2017
ID: 6173
Name: Peck
Type: Cat
Color: White with black and brown spots
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Senior
Last seen in Garner. Her right hind leg walks and sits a little funny.
Adair
Lost: 7/8/2017
ID: 6148
Name: Jazmine
Type: Dog
Color: Black and brow,
Breed: Rottweiler
Gender: Female
Fixed: Neutered
Age: Young
Rottweiler and lab mix, last seen north of 2736 state highway 25 in greenfield, ia headed to the corn fields. Fireworks scared her.
Des Moines - South
Lost: 7/8/2017
ID: 5823
Name: Diesal
Type: Cat
Color: Grey
Breed: Bombay
Gender: Male
Fixed: Unknown
Age: Baby
1424 e virginia in between e virgina and glenwood
Des Moines - Central
Lost: 7/7/2017
ID: 6162
Name: Johnny
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Baby
Arlington Ave and Clark St
Des Moines - Central
Lost: 7/7/2017
ID: 6140
Name: Hero
Type: Dog
Color: Light brown and dark brown with the white stripe
Breed: Groenendael
Gender: Female
Fixed: Not Neutered
Age: Adult
Last see at the north side library
Sheffield
Lost: 7/7/2017
ID: 6131
Name: Clayto
Type: Cat
Color: Black and WHITE
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Mear firshill cresent and home
Des Moines - North
Lost: 7/7/2017
ID: 6128
Name: Franklin
Type: Dog
Color: White and tan
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Off mondamin ave May have a blue bandana extremely friendly
Ankeny
Lost: 7/6/2017
ID: 6145
Name: Little Cat
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
We think she got out of the house the evening of 7/6 and we had the garage door open all night.