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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Randalia
Lost: 12/26/2018
ID: 10394
Name: Bella
Type: Dog
Color: brown
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
in Randalia, Iowa
Cumming
Lost: 12/25/2018
ID: 10357
Name: Molly
Type: Dog
Color: Black/Tan
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen 12/25/18, Evening. Lost at 120th Street and Vintage Avenue, Cumming; NE corner of Madison County. Very friendly 6 month old Rottweiler Puppy. If seen or found call: 319 431-1590
Altoona
Lost: 12/25/2018
ID: 10341
Name: Clark (kent)
Type: Cat
Color: Orange stripped
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
He only has three legs. He is missing one of his back legs. Very sweet.
Cumming
Lost: 12/25/2018
ID: 10324
Name: Molly
Type: Dog
Color: Black/Tan
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 7:30 PM; 6 month female puppy. At 120th St and Vintage Ave just off Cumming Road.
Cumming
Lost: 12/25/2018
ID: 10322
Name: Molly
Type: Dog
Color: Black tan
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Young
She's sweet and will be missing her mama and home to the point she'll be crying til shes hm. please please help find her.
Ankeny
Lost: 12/25/2018
ID: 10315
Name: Oreo
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Possibly got out of our back door. I saw the screen door was open. We live on SW Springfield Drive in SW Ankeny.
Des Moines - South
Lost: 12/25/2018
ID: 10313
Name: Bellah n bruddah
Type: Dog
Color: Female tan male tan n white. 2-2mos puppies 1 black male with tan markings and1 black nwhite female
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen se14th n watrous. 2 small dogs and 2 puppies. Tan is named bellah female. Tan and white is named bruddah. And 2-2mos old pups. 1 black with tan markings named Dave. And 1 black and white named fatty Patty. No collar dug out approximately 1230 today
Colfax
Lost: 12/25/2018
ID: 10312
Name: Beau
Type: Dog
Color: Brown
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
2965 W 124th ST N Colfax. Likely running around with our other dog (white with brown spots, same breed). Both are very friendly!
Colfax
Lost: 12/25/2018
ID: 10311
Name: Bailey
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at 2965 W 124th ST N Colfax. She is likely running around with our other dog Beau (all brown). Both are very friendly!
Marion
Lost: 12/24/2018
ID: 10327
Name: George
Type: Dog
Color: Golden
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Adult
I took him out at 1am he got out of the fence somehow
Marion
Lost: 12/24/2018
ID: 10326
Name:
Type: Dog
Color: Golden
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 12/24/2018
ID: 10301
Name: Luca
Type: Dog
Color: White with blue tick spots
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on Kinsey ave by Stowe elementary
Des Moines - East
Lost: 12/24/2018
ID: 10300
Name: Luca
Type: Dog
Color: Blue and white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
Sunday night
Clinton
Lost: 12/23/2018
ID: 10348
Name:
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He was last seen behind goodwill on 13th ave. He's very shy
Melcher-Dallas
Lost: 12/23/2018
ID: 10308
Name: Jasper
Type: Cat
Color: Orange with white belly
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen outside of the house he is a larger cat with a thick furry tail he pretty friendly will likely come up to someone for attention doesn't have a collar he always scratches them off
Davenport
Lost: 12/22/2018
ID: 10303
Name: Vince
Type: Dog
Color: Dark brindle
Breed: Whippet
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in wooded area of Duck Creek Park in Davenport, east of Jersey Ridge Road. Is special needs and has great anxiety and fear issues. Please do't try to approach him or he'll run. Show him food and walk/run away from him with hope that he'll follow. Best bet is to use food to try to lure him into a fenced yard or other enclosure. He's a sight hound is is very fast. Please call day or night: 563.723.1945 or 563.499-0823
Davenport
Lost: 12/22/2018
ID: 10302
Name: Vince Male
Type: Dog
Color: Dark brindle
Breed: Whippet
Gender: Male
Fixed: Neutered
Age: Adult
He's a Whippet--Looks like a small greyhound. Has part of right ear missing. Last seen in wooded area east of Jersey Ridge Rd. on the bike path in Duck Creek Park. Is special needs and has great anxiety and fear. Please don't try to approach him or he'll run. Show him food and walk/run away from him with hope that he'll follow. Best bet is to use food to try to lure him into a fenced back yard or other enclosure. He's a sight hound and is very fast. Last seen in the woods of Duck Creek Park. Please call day or night: 563.723.1845 or 563.499.0823
Winterset
Lost: 12/21/2018
ID: 10410
Name: Motakka
Type: Dog
Color: Black, white, gray
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Motakka gets very car sick and is very skittish around new people. He is very playful and likes to jump up on people. He is a good dog though. He is missed by us a lot.
Lewis
Lost: 12/21/2018
ID: 10382
Name: Nosey
Type: Dog
Color: White with orange spots
Breed: Basset Hound
Gender: Female
Fixed: Unknown
Age: Adult
Last seen in countryside south of Lewis Iowa (in southwest Iowa) Small for a basset, very sweet and loves people, but also likes to bark a lot. She is not microchipped and snuck out of her house while her collar was off. She has a slight bald patch on the lowest point of her chest, and spots on the skin of her belly.
Bondurant
Lost: 12/20/2018
ID: 10397
Name: Nelly
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Super friendly and talkative. Will come right up to you, esp if you have food. White diagonal line down nose. Small scar on nose. Not declawed.
Des Moines - East
Lost: 12/20/2018
ID: 10350
Name: Lily mouse
Type: Cat
Color: Multicolored
Breed: Siamese
Gender: Female
Fixed: Not Applicable
Age: Adult
Urbandale
Lost: 12/20/2018
ID: 10284
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Altoona
Lost: 12/20/2018
ID: 5902
Name: Ginger
Type: Cat
Color: White with black & orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Altoona
Lost: 12/20/2018
ID: 5901
Name: Ginger
Type: Cat
Color: White with black & orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Ginger is a small, friendly cat. We miss her bunches!
Des Moines - South
Lost: 12/19/2018
ID: 10304
Name: Axel
Type: Cat
Color: White and black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
my buddies cat hasnt came home it's been about five days. his name is Axel he has long white and black hair really friendly. lives on the south side off sw9th on summit. if anyone has seen him or has him please call 5154144132