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