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>='1618185600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 1/18/2021
ID: 15899
Name:
Type: Dog
Color: creme
Breed: Bichon Frise
Gender: Unknown
Fixed: Unknown
Age: Adult
29th & Elm st
Des Moines - South
Found: 1/17/2021
ID: 15898
Name: No tags
Type: Dog
Color:
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Baby
West Des Moines
Found: 1/16/2021
ID: 15896
Name:
Type: Cat
Color: Orange and White Stripes
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Young
Very clean, vocal, All claws, Orange and White with Rings on the tail.
Clive
Found: 1/16/2021
ID: 15890
Name:
Type: Dog
Color: white, grey, and black
Breed: Alaskan Malamute
Gender: Male
Fixed: Unknown
Age: Adult
1558 NW 81st st
Des Moines - Central
Found: 1/14/2021
ID: 15885
Name:
Type: Dog
Color: Brindle brown
Breed: Belgian Shepherd Malinois
Gender: Male
Fixed: Neutered
Age: Adult
He was running in my friends yard at 36th and Seneca
Des Moines - Central
Found: 1/14/2021
ID: 15884
Name:
Type: Dog
Color: Brown brindle
Breed: Shepherd Belgian
Gender: Male
Fixed: Neutered
Age: Adult
36th and Seneca’ in beaverdale
Des Moines - East
Found: 1/13/2021
ID: 15880
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
West Des Moines
Found: 1/13/2021
ID: 15873
Name:
Type: Dog
Color: Brown with some black and white
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 1/13/2021
ID: 15872
Name: Buddy
Type: Dog
Color: Tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Senior
Grand ave heading towards 63rd Street very skidish and anxious. Will run away if approached please call if spotted
Des Moines - North
Found: 1/12/2021
ID: 15877
Name:
Type: Dog
Color: Black with brown and tan
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
She was caught at around 10:15. She was with another dog that I was unable to catch. It seemed like a Boston terrier type dog, but I could of not seen right as well.
Pleasant Hill
Found: 1/12/2021
ID: 15875
Name: Sayde
Type: Dog
Color: Brown/gray/red
Breed: Chihuahua
Gender: Unknown
Fixed: Neutered
Age: Adult
Pleasant Hill, IA
Pleasant Hill
Found: 1/12/2021
ID: 15874
Name: Sayde
Type: Dog
Color: Brown/Gray
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in Pleasant Hill, IA. Home remodeling she snuck out door.
Newton
Found: 1/11/2021
ID: 15882
Name:
Type: Dog
Color: Black
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Young
This dog is currently impounded at Jasper County Animal Control in Newton, IA.
West Des Moines
Found: 1/11/2021
ID: 15862
Name: Lucy
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
1200 block of Office Park Road
West Des Moines
Found: 1/10/2021
ID: 15864
Name: Lee
Type: Cat
Color: Orange and white tabby
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Found: 1/9/2021
ID: 15851
Name:
Type: Cat
Color: Orange and White Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
210 S Prairie View Drive - Signature Place Apartments
Windsor Heights
Found: 1/8/2021
ID: 15863
Name: Cleo
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Charles City
Found: 1/8/2021
ID: 15860
Name:
Type: Cat
Color: Gray tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Ames
Found: 1/8/2021
ID: 15848
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
It entered our house and is very skittish but doesn’t want to leave the warm house. No collar.
Des Moines - North
Found: 1/7/2021
ID: 15855
Name:
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
This cat has been seen in our area for quite some time but never approached us. I tried to approach it last summer several times but to no avail. That night he came to our front glass door and meowed loudly while looking in at us. It was below freezing outside and so of course I let him in. He is sweet as pie.
Des Moines - South
Found: 1/7/2021
ID: 15835
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Loving dog, kind of squeaky bark. Keeps leaving and coming back.
Des Moines - South
Found: 1/7/2021
ID: 15833
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
He's been in our custody for the past 2 hours.
Clive
Found: 1/5/2021
ID: 15826
Name:
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
1400 Block of Country Club Blvd
West Des Moines
Found: 1/5/2021
ID: 15823
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Found: 1/5/2021
ID: 15822
Name: Lana
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult