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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Found: 11/7/2020
ID: 15415
Name:
Type: Dog
Color: Grey
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
Found with a Great Dane
Pleasant Hill
Found: 11/7/2020
ID: 15414
Name:
Type: Dog
Color: Dark grey
Breed: Great Dane
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 11/6/2020
ID: 15413
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Found: 11/5/2020
ID: 15406
Name:
Type: Cat
Color: Yellow and white
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Very loving and friendly, missing front claws and also tries to come inside the house.
Des Moines - North
Found: 11/5/2020
ID: 15402
Name:
Type: Cat
Color: Grey
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
I’ve been feeding this cat. Will not come close to me. I cannot catch.
Mason City
Found: 11/5/2020
ID: 15400
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Baby
West Des Moines
Found: 11/5/2020
ID: 15396
Name: Kit Kat
Type: Cat
Color: Brown and white tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Found: 11/5/2020
ID: 15161
Name: Goose
Type: Dog
Color: Light brown/white chest
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Near 63rd/Grand
Storm Lake
Found: 11/4/2020
ID: 15392
Name:
Type: Cat
Color: Tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on Cayuga Street
West Des Moines
Found: 11/3/2020
ID: 15381
Name:
Type: Cat
Color: Grey & White Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
500 block of 7th street
West Des Moines
Found: 11/3/2020
ID: 15379
Name:
Type: Dog
Color: Black
Breed: Retriever, Labrador
Gender: Male
Fixed: Unknown
Age: Senior
Clive
Found: 11/3/2020
ID: 15378
Name:
Type: Cat
Color: Brown and White Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 11/3/2020
ID: 15375
Name:
Type: Dog
Color: Grey/White
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Picked up running down 4th and Ovid st,not aggressive.
Waukee
Found: 11/2/2020
ID: 15425
Name: Unknown
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Baby
He has been coming to my house everyday for a week now. He has no collar and he is very friendly. He has seemed starved so I been feeding him and giving him water. He has yellow eyes and meows quite a bit.
Des Moines - East
Found: 11/2/2020
ID: 15398
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
now
Des Moines - North
Found: 11/2/2020
ID: 15374
Name: Miller and Noel
Type: Cat
Color: Grey, white, black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
50th street between aura and Meredith
Ankeny
Found: 11/2/2020
ID: 15373
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Found: 11/2/2020
ID: 15372
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Baby
West Des Moines
Found: 11/2/2020
ID: 15367
Name:
Type: Dog
Color: Tan, Black & White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
600 block of S 26th Street
Des Moines - Central
Found: 11/1/2020
ID: 15361
Name:
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Adair
Found: 11/1/2020
ID: 15358
Name:
Type: Dog
Color: Tricolor
Breed: Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
Found running across highway, was scared but very friendly and let me pick him up. Has no tags or collar on.
Waukee
Found: 10/31/2020
ID: 15354
Name:
Type: Dog
Color: White
Breed: West Highland White Terrier Westie
Gender: Female
Fixed: Unknown
Age: Adult
We are currently caring for her I our backyard and plan to put her inside in a kennel over night.
Des Moines - Central
Found: 10/31/2020
ID: 15345
Name:
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Adult
Ankeny
Found: 10/30/2020
ID: 15357
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 10/30/2020
ID: 15347
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
700 block 13th