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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
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 - East
Lost: 8/8/2019
ID: 12085
Name: Pancho
Type: Dog
Color: Golden Brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Very Friendly Dog Under Bite
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.
Des Moines - East
Lost: 8/6/2019
ID: 12077
Name: Oranthal
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in my backyard. He is food motivated and friendly. Maybe scars as he is rarely outside
Bettendorf
Lost: 8/5/2019
ID: 12132
Name: Yoshi
Type: Cat
Color: Tabby
Breed: Maine Coon
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in home at 810 27th Street, Bettendorf. He escaped out an open screen door.
Earlham
Lost: 8/5/2019
ID: 12089
Name: Nadia
Type: Cat
Color: Grey with white chest and paws
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
I-80 Exit 104 W/B on ramp. Nadia ran into weeds/brush on north side of ramp @ 9:00 PM At time she escaped she had pink collar w/name & tag with phone #. Ear is notched. Well fed. She is E-X-T-R-E-M-E-L-Y MISSED!! REWARD FOR HER SAFE RECOVERY
Madrid
Lost: 8/5/2019
ID: 12067
Name: Major
Type: Dog
Color: Black tri
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
East of Madrid between Madrid and shedahl
Des Moines - South
Lost: 8/5/2019
ID: 12063
Name: Kiko
Type: Dog
Color: Golden brown
Breed: Shiba Inu
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Indianola road and SE 8th street. Across from Howe Elementary South DSM. Very friendly and loves our kids. Very food driven. Name is pronounced Key-Co. Please help us find him! Please call 515-779-8656
Ames
Lost: 8/4/2019
ID: 12091
Name: Grumpy
Type: Dog
Color: Red tick
Breed: English Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen just south of Ames Iowa.
Pella
Lost: 8/4/2019
ID: 12061
Name: Peanut
Type: Cat
Color: Black
Breed: Manx
Gender: Unknown
Fixed: Neutered
Age: Young
She ran into the cornfield right next to Madison Middle School, in Pella Iowa. It was the cornfield behind the apartments when she broke out of her carrier. She is extremely nervous and is probably terrified. Shes a sweetheart. She’s an inside cat. She has on a pink breakaway collar and might be still wearing purple sparkle claw caps. She has dullish green-yellow eyes. She loves wet food so may be lured that way.
Des Moines - North
Lost: 8/4/2019
ID: 12057
Name: Nema
Type: Dog
Color: Fawn
Breed: Doberman Pinscher
Gender: Female
Fixed: Not Applicable
Age: Adult
On the corner of Beaver Ave and Hickman Rd.
La Motte
Lost: 8/4/2019
ID: 12055
Name: Zolon
Type: Dog
Color: Reddish brown
Breed: Australian Cattle Dog
Gender: Male
Fixed: Neutered
Age: Young
Aka “Zo”
La Motte
Lost: 8/4/2019
ID: 12054
Name: Rory
Type: Dog
Color: Brown/chocolate
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Young
Likes to play “ball” and can get very timid with loud noises
Ankeny
Lost: 8/4/2019
ID: 12051
Name: Lilly
Type: Dog
Color: White and brindle
Breed: American Bulldog
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 8/3/2019
ID: 12066
Name: Can’te
Type: Cat
Color: Grey/Tan some stripes
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
He went missing on NE 3rd street Two houses from Cornell Elementary School. He's a grouchy Lil guy and hes very fat.
Des Moines - East
Lost: 8/3/2019
ID: 12042
Name: Duke
Type: Dog
Color: White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 8/3/2019
ID: 12041
Name: Duke
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 8/3/2019
ID: 12028
Name: Tankers
Type: Dog
Color: Light brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult