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>='1560988800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 7/17/2018
ID: 9235
Name: Shada
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Tuesday
Iowa Falls
Lost: 7/17/2018
ID: 9189
Name: Beannie
Type: Dog
Color: Red
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 5.29pm 2 miles S of Alden iowa. Very friendly. Please help.
Alden
Lost: 7/17/2018
ID: 9187
Name: Beanie
Type: Dog
Color: Red
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Baby
8 year old. White mark on chest. Gray collar with no tags. Comes to Beanie, Bubba, or Fennie. 100 lbs. Loves car rides but hates getting into the car. Last seen south of Alden on s27.
Des Moines - East
Lost: 7/17/2018
ID: 9184
Name: Leo
Type: Cat
Color: Grey with black stripes. Some white on feet
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Leo is the cat in front of pic
West Des Moines
Lost: 7/17/2018
ID: 9181
Name: Luna
Type: Dog
Color: Gold
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 7/17/2018
ID: 9177
Name: WonTon
Type: Dog
Color: White with brown spotting
Breed: Chinese Crested Dog
Gender: Male
Fixed: Neutered
Age: Senior
In neighborhood around stow elementary school. Very skittish and scared of most people Please call 515-249-9275
Des Moines - Central
Lost: 7/17/2018
ID: 9176
Name: Jia
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen at 3124 Glenarm Ct. by the VA hospital in Des Moines. Very friendly but may be a little shy when approaching her.
Altoona
Lost: 7/16/2018
ID: 9196
Name: Chloe
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen in a chair outside our house please contact 5157780235 or 5157780233 and our home phone is9672565 Our Andress is 409 6th street
Des Moines - South
Lost: 7/16/2018
ID: 9186
Name: Katniss Kitty Queen
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Young
Ankeny
Lost: 7/16/2018
ID: 9180
Name: Luna
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Near Crocker Elementary Ankeny
Norwalk
Lost: 7/16/2018
ID: 9169
Name: Graham
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Applicable
Age: Young
Last seen on Lewis Ave. Has a black colar on and loves people.
Des Moines - North
Lost: 7/15/2018
ID: 9162
Name: emma
Type: Dog
Color: Black/white
Breed: Whippet
Gender: Female
Fixed: Not Applicable
Age: Senior
emma is 14 years old we love her very much
Des Moines - East
Lost: 7/15/2018
ID: 9160
Name: Loki
Type: Dog
Color: Chocolate Brown
Breed: Dachshund-Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
He went across the street on E 42nd and a Mother and daughter picked him up. They told the neighbor their intention was to take him to the Animal Rescue League.
Des Moines - South
Lost: 7/14/2018
ID:
Name: Hunter Lee
Type: Dog
Color: Black
Breed: Dachshund-Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
At Harbor Freight on the south side near Army Post and SE 14th St. several people noticed some lady walking him. He is a black lab mix. Has a bushy German Shepherd tail. Very stubborn but friendly.
Des Moines - East
Lost: 7/13/2018
ID: 9147
Name: LUNA
Type: Dog
Color: Brown, white,tan
Breed: Mix
Gender: Male
Fixed: Not Applicable
Age: Baby
Des Moines - East
Lost: 7/13/2018
ID: 9142
Name: Titan
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Was last seen at Sheridan Park on Hull Ave. he is def but very friendly and loves kids.
Des Moines - East
Lost: 7/13/2018
ID: 9138
Name: Garfield
Type: Cat
Color: yellow
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen near grandview university. He is very friendly so don’t be afraid to pick him up or touch him ! He is a large part of our family so please call if you see anything
Des Moines - South
Lost: 7/13/2018
ID: 8327
Name: Fiona
Type: Cat
Color: Gray
Breed: Pit Bull
Gender: Female
Fixed: Not Applicable
Age: Young
last seen on SE 14th by Sahota liquor store. She is all gray with a small tan stripe through her fur, one tan paw and green eyes. Very furry. Has a black collar on that has silver studs.. attached to her collar is a purple tag kind of in the shape of a heart with the name Fiona on one side and my phone number on the other. She everything please alert asap if you see her
Ankeny
Lost: 7/13/2018
ID: 5311
Name: Oliver
Type: Cat
Color: Grey/White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
The kids said that he was around this weekend. We were gone this weekend and we got home on Monday and we haven't seen him since. We live in the south west part of Ankeny south of Oralabor on NW 16th St.
Clinton
Lost: 7/12/2018
ID: 10411
Name: Elsa
Type: Dog
Color: White
Breed: Tuxedo
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Supposedly given to a lady outside of the humane society.
Des Moines - East
Lost: 7/12/2018
ID: 10031
Name: Jose
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 43rd ct and Hubble Des Moines he was wearing a color but he likes to take it off he is not fixed and has a big Freckle on his lip and a scar on his ear we think he might have been stolen and dropped off in another neighborhood please help us bring him home
Ankeny
Lost: 7/12/2018
ID: 9168
Name: Blackie
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Lost in SW 24th Court - Ankeny Missing with her sister Rosie who is black and white. :(
Ankeny
Lost: 7/12/2018
ID: 9167
Name: Rosie
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near SW 24th Court Ankeny. Was with her sister Blackie. Also missing. :(
Schleswig
Lost: 7/12/2018
ID: 9154
Name: Charlie
Type: Dog
Color: golden red
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Young
Newton
Lost: 7/12/2018
ID: 9141
Name: Nyah
Type: Dog
Color:
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
She slipped out of her collar and took off late last night. She was last seen in Newton, IA on S 3rd Ave.