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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Windsor Heights
Lost: 2/7/2017
ID: 4825
Name: Hoover
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Has cataracts and hard of hearing. Very friendly.
Des Moines - East
Lost: 2/6/2017
ID: 4850
Name: Felix
Type: Cat
Color: White/gray stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is very shy and not a outside cat at all. Has a pink nose with black out line. Light green eyes
Indianola
Lost: 2/5/2017
ID: 4827
Name: Niko
Type: Cat
Color: White and Tan
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen around 1210 N 9th St around 3-4pm. He has two tan spots on his back and he's very fluffy. He's only 9 months old, he's very friendly but not towards new animals he get skiddish
Des Moines - East
Lost: 2/5/2017
ID: 4817
Name: Pazzo
Type: Cat
Color: Orange tiger striped
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Help! We just moved to a new house and he got scared and ran off in the transport process.
Des Moines - East
Lost: 2/3/2017
ID: 4823
Name: Snowball
Type: Cat
Color: Black and white
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Adult
He was last seen on the east side on e 27th st .
Des Moines - Central
Lost: 2/2/2017
ID: 4807
Name: Redd
Type: Dog
Color: White with red markings on ears and large red patch over right eye.
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen Thursday night at a home on SE 5th and Trowbridge, a couple of blocks north of the Post Office on McKinley. He got off his lead and was in the front yard. Someone in a tan truck picked him up. He is friendly will go up to anyone.
Ankeny
Lost: 1/31/2017
ID: 4792
Name: Baby
Type: Cat
Color: Brown and black and white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
SE Delaware in ankeny
Des Moines - East
Lost: 1/31/2017
ID: 4791
Name: Diesel & Thorn
Type: Dog
Color: brindle with white paws and cheset
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Diesel (the dog on the right) and Thorn (dog on the left) are both missing! Diesel is a pit bull boxer mix. They escaped today Jan 31st and due to health reasons their owner couldn't move quickly enough to catch them. They're not neutered (were due to be fixed with a program next week). Diesel is about 1 year old. Thorn is about 9-10 months. Diesel is more of a boxer size. Thorn is short and stocky but not built up or anything. both are very sweet. they aren't aggressive but may be scared to be approached by strangers (they're big babies) Please call or text right away if you see or find them! 515-446-0180 or 515-446-1413
Des Moines - East
Lost: 1/31/2017
ID: 4790
Name: Thorn
Type: Dog
Color: red with white on his chest
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
He's my friends dog, he and their other dog got out today by accident. Due to health reasons, she wasn't able to catch them fast enough! Last seen on Broadway near 2nd! Not vicious but may not approach strangers. Please call or text 515-473-0180 or 515-446-1413
Des Moines - East
Lost: 1/30/2017
ID: 4787
Name: Hooey
Type: Dog
Color: Black and White
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
Him and the other dog were chained in the yard together. They were still hooked together when they got off the chain. The othee dog with him is a Bulldog male who is not neutered.
Des Moines - South
Lost: 1/29/2017
ID: 4776
Name: Logan
Type: Dog
Color: Red and white
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Baby
Fleur dr and Kenyon near the air
Des Moines - North
Lost: 1/28/2017
ID: 4921
Name: Chispa
Type: Dog
Color: Chocolate brown
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Adult
She's still missing please if anything call me! She's my little girl!! 831-288-9145
Des Moines - North
Lost: 1/28/2017
ID: 4843
Name: Chispita
Type: Dog
Color: Chocolate brown
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
If seen please call 831 288 8145
Des Moines - North
Lost: 1/28/2017
ID: 4796
Name: Chispa
Type: Dog
Color: Chocolate
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 1/28/2017
ID: 4795
Name: Chispa
Type: Dog
Color: Chocolate
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 1/28/2017
ID: 4794
Name: Chispa
Type: Dog
Color: Chocolate
Breed: Chihuahua
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 1/28/2017
ID: 4793
Name: Chispa
Type: Dog
Color: Chocolate
Breed: Chihuahua
Gender: Unknown
Fixed: Unknown
Age: Adult
St. Marys
Lost: 1/27/2017
ID: 4803
Name: Lady
Type: Dog
Color: Chocolate Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen in St. Mary's, IA Collar may or may not still be on but includes tag & phone number If you've seen our dog, please contact 641-297-2346 (home) or 515-313-3124 (cell)
St. Marys
Lost: 1/27/2017
ID: 4802
Name: Lady
Type: Dog
Color: Chocolate Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen in St. Marys, IA. Collar includes tag with phone number
St. Marys
Lost: 1/27/2017
ID: 4801
Name: Lady
Type: Dog
Color: Chocolate Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Name tag on collar is 'Nalla' with contact phone number. However her name is Lady & her collar accidentally got switched with our other dog
St. Marys
Lost: 1/27/2017
ID: 4800
Name: Lady
Type: Dog
Color: Chocolate Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Name tag on collar is 'Nalla' with contact phone number. However her name is Lady & her collar accidentally got switched with our other dog
Mason City
Lost: 1/26/2017
ID: 4834
Name: Vera
Type: Dog
Color: Black an white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Very friendly, last seen on 3rd an n Georgia in mason city
Des Moines - North
Lost: 1/26/2017
ID: 4797
Name: Elsa
Type: Cat
Color: Tabby
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Last seen at my parents house. I live near them & she usually walks between our homes & goes into both homes like they're hers, which they are.. Please help bring Elsa home!!
Des Moines - Central
Lost: 1/25/2017
ID: 5017
Name: Red
Type: Dog
Color: Light brown with white
Breed: Vizsla
Gender: Male
Fixed: Neutered
Age: Young
Last seen getting into a blue van in beaverdale on Urbandale Ave by the church. I have a reward for finding him and any other information helpful.
Rome
Lost: 1/25/2017
ID: 4773
Name: Shiloh
Type: Dog
Color: Black
Breed: Vizsla
Gender: Female
Fixed: Not Neutered
Age: Young
She has longer, not groomed black hair petite pup loves other dogs can be skiddish if trying to get in car but is a super friendly lady who is only about 6-8 months old