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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Marshalltown
Found: 11/1/2018
ID: 10321
Name:
Type: Dog
Color: Black/White
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
Found at South 12th Ave. Proof of ownership REQUIRED!
West Burlington
Found: 11/1/2018
ID: 10144
Name: Free to good home
Type: Cat
Color: Dark grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
This afternoon, he is very friendly, walks right in. May have been abandoned. We have 3 cats, and they aren't happy about any strange cats. He'll come in, eat, has used a litter box, but leaves if the door is opened. Want to have him vet checked, will if he keeps coming around.
West Burlington
Found: 11/1/2018
ID: 10143
Name: Free to good home
Type: Cat
Color: Dark grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
This afternoon, he is very friendly, walks right in. May have been abandoned. We have 3 cats, and they aren't happy about any strange cats. He'll come in, eat, has used a litter box, but leaves if the door is opened. Want to have him vet checked, will if he keeps coming around.
Mingo
Found: 10/31/2018
ID: 9928
Name: Unknown
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
It showed up on our deck on Halloween begging for food. We fed him some dog food and he's been here since then. Very friendly, seems quite young, a few scrapes.
Des Moines - Central
Found: 10/31/2018
ID: 9922
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found young cat in our yard. Scanned for chip, none found, no tags, be prepared to provide detailed physical description of the cat as well as a description of her collar.
West Des Moines
Found: 10/31/2018
ID: 9900
Name: Unknown
Type: Cat
Color: Grey
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Cat was comfortable but skittish. Hungry, healthy. Seemed lost. Ate and drank. Friendly but kept distance. Contact 515.577.5985
Des Moines - North
Found: 10/31/2018
ID: 9899
Name:
Type: Cat
Color: Black Tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Windsor Heights
Found: 10/31/2018
ID: 9898
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
This cute little guy was found in the street near my house and he came right up to me! He's got a broken bone in his foot so I am keeping him with me until he is claimed. I am also going to see what I can do about his foot.
Des Moines - North
Found: 10/31/2018
ID: 9897
Name: Rocko
Type: Dog
Color: White
Breed: Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
14th n university area
Ames
Found: 10/30/2018
ID: 9888
Name: ?
Type: Cat
Color: dark brown on top, some stripes, light color on belly
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
I saw this cat in the stairwell and it has no collar. It appears to be very friendly and well-fed. For some reason I cannot upload pictures...
Monroe
Found: 10/28/2018
ID: 9871
Name:
Type: Dog
Color: Black and tan
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
He was found wandering around the Dollar General in Monroe. He was trying to get in the store. He’s walking with a slight limp on his front left paw.
Waukee
Found: 10/27/2018
ID: 9870
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Found: 10/27/2018
ID: 9867
Name:
Type: Dog
Color: Red and White
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Johnston
Found: 10/26/2018
ID: 9862
Name: Khalessi
Type: Cat
Color: Black with white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Is blind in one eye and has extra toes.
Des Moines - Central
Found: 10/25/2018
ID: 9857
Name: Unknown
Type: Cat
Color: Orange White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Located at 2815 48th Street Des Moines, Iowa
Altoona
Found: 10/25/2018
ID: 9856
Name: Unknown
Type: Cat
Color: Gray
Breed: Nebelung
Gender: Male
Fixed: Unknown
Age: Young
Ironwood Glen neighborhood of Altoona, Iowa (3rd Ave SW) Contact: sue.phanivong@gmail.com
Ankeny
Found: 10/24/2018
ID: 9851
Name: Lola
Type: Dog
Color: Silver/Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Found: 10/24/2018
ID: 9849
Name:
Type: Dog
Color: Black and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Around Burger King on MLK and Hickman Road.
Des Moines - Central
Found: 10/23/2018
ID: 9844
Name:
Type: Cat
Color: Gray & White
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/22/2018
ID: 9885
Name:
Type: Cat
Color:
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Baby
Very friendly, young male not neutered.
West Des Moines
Found: 10/22/2018
ID: 9839
Name: Boomer
Type: Cat
Color: black and white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Young
FOUND
Monroe
Found: 10/20/2018
ID: 9872
Name:
Type: Cat
Color: Gray and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
This Sweet boy has been hanging around our neighborhood for over a week. We thought he belonged to a neighbor but found out that’s not the case.
Des Moines - Central
Found: 10/13/2018
ID: 9800
Name: Unknown
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Small very sweet kitty. Showed up on our back porch Saturday night. Vet says no chip. We live by the Des Moines Art Center.
Granger
Found: 10/12/2018
ID: 9785
Name: Unknown
Type: Cat
Color: Tortoise
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Jester Lake Estates
Altoona
Found: 10/12/2018
ID: 9778
Name: Finley
Type: Dog
Color: White some black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Baby