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>='1593820800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
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.