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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 8/11/2019
ID: 12097
Name: Riley
Type: Dog
Color: White
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Young
In our backyard at 10pm on 8/10/19... right on indianola ave by Jackson elementary
Des Moines - West
Lost: 8/10/2019
ID: 12020
Name: Frazier
Type: Cat
Color: Gray
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at residence 7/31/19; Salisbury Oaks neighborhood. Frazier is well fed, and very mild mannered.
Des Moines - Central
Lost: 8/9/2019
ID: 12117
Name: Tuxedo
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Tuxedo was last seen on Friday night. We moved houses and he has a way of making it back to the old house. He went missing in the Roosevelt drake area and does not have a collar on. If anyone has seen or has him please contact me at (515)-508-1802 we miss him dearly and are very concerned as he is old.
Keystone
Lost: 8/9/2019
ID: 12115
Name: Wednesday
Type: Dog
Color: Brindle
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Young
Last seen on 72nd street in keystone. She has one eye and needs her medication 4 times a day. She is special needs
Des Moines - East
Lost: 8/9/2019
ID: 12110
Name: Sunshine comes to kitty kitty
Type: Cat
Color: Orange/yellos tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
InsIde only cat she got out sometime Friday when the sliding glass door was open for someone coming in or out....
Urbandale
Lost: 8/9/2019
ID: 12109
Name: Cheeto
Type: Cat
Color: Tiger striped & calico
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Very shy, quiet meow. Orange spot on forehead.
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: 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