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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 1/28/2017
ID: 4795
Name: Chispa
Type: Dog
Color: Chocolate
Breed:
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
Des Moines - North
Lost: 1/24/2017
ID:
Name: Fitz
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He has green eyes. His front paws are declawed. Escaped this morning from his house near Beaver and Urbandale. Very mild mannered.
Des Moines - North
Lost: 1/24/2017
ID:
Name: Fitz
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He has green eyes. His front paws are declawed. Escaped this morning from his house near Beaver and Urbandale. Very mild mannered.
Fairbank
Lost: 1/23/2017
ID: 4769
Name: Ollie
Type: Dog
Color: Brown and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Young
Two dogs missing since Mon. Jan. 23rd while hunting. $2000.00 reward if found and returned. Last seen on 150th Street near Fairbank, Iowa. Two Males; both wearing I.D. collars. Black male is also wearing a GoPro camera. Black Male answers to "Ranger". Brown Male answers to "Ollie". Please contact BJ Bowman (304) 561-7030 or Jason Adams (304) 638-4092 if you have any information regarding these beloved boys.
Fairbank
Lost: 1/23/2017
ID: 4768
Name: Ranger
Type: Dog
Color: Black and White
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Two Pointer Breed dogs missing since Mon. Jan. 23rd while hunting. $2000.00 reward if found and returned. Last seen on 150th Street near Fairbank, Iowa. Both Males; both wearing I.D. collars. Black and white male answers to "Ranger" and is also wearing a GoPro camera. Brown and white male answers to "Ollie". Please contact BJ Bowman (304) 561-7030 or Jason Adams (304) 638-4092 if you have any information regarding these beloved boys.
Des Moines - East
Lost: 1/23/2017
ID: 4762
Name: Nala
Type: Cat
Color: Orange with some white
Breed: German Wirehaired Pointer
Gender: Unknown
Fixed: Neutered
Age: Adult
In the Grandview college area. She has no collar. Please help!
Des Moines - East
Lost: 1/22/2017
ID: 4759
Name: daisy rae
Type: Dog
Color: all brown
Breed: Welsh Corgi Cardigan
Gender: Female
Fixed: Not Neutered
Age: Baby
east side of des moines on 18th and capital ave zip 50316 please help! shes very small
Ankeny
Lost: 1/22/2017
ID: 4756
Name: Archer
Type: Cat
Color: black and caramel
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Norwalk
Lost: 1/21/2017
ID: 4752
Name: Mack
Type: Dog
Color: Briwn and white
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
West of Norwalk water tower about four miles. About 1 mile south of happy apple orchard.
Des Moines - East
Lost: 1/21/2017
ID: 4743
Name: Brutus
Type: Dog
Color: Brown
Breed: Bullmastiff
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen around 1:30am. He's very nice and he's probably pretty scared right now.
Des Moines - East
Lost: 1/20/2017
ID: 4782
Name: Raider
Type: Cat
Color: Black with a little white on his chest and belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
I last seen him playing in the back bay of our auto repair shop at 3214 E. 14th st. Des Moines. I'm missing him very badly and just want my raider baby back home.
Dubuque
Lost: 1/18/2017
ID: 4788
Name: Patrick
Type: Dog
Color: Jet black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at guard shack in dub.ia.mother captured pic.on whispering hope rescue on same date.could be in sageville mud lake richardsville heritage trail area.loves to hunt rabbits and attention! Very friendly and beautiful.been looking about 100 miles on foot.lost other phone with his pics on it so no pics yet.please help we miss him dearly.hes the leader of the pets.thanks!
Des Moines - North
Lost: 1/13/2017
ID: 4706
Name: Toby
Type: Cat
Color: Gray and white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Winterset
Lost: 1/12/2017
ID: 4757
Name: ?
Type: Cat
Color: Gray & white
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Young
Chip not registered
Colo
Lost: 1/12/2017
ID: 4704
Name: Zoe
Type: Dog
Color: Tan and brown
Breed: Chiweenie
Gender: Female
Fixed: Unknown
Age: Young
Last seen in Colo by co-op