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>='1632268800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 9/18/2020
ID: 14989
Name:
Type: Small or Furry
Color: black and white
Breed: Ferret
Gender: Unknown
Fixed: Unknown
Age: Baby
2200 block EP True Pkwy
Urbandale
Found: 9/18/2020
ID: 14987
Name:
Type: Cat
Color: Orange and white Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
10200 block Hickory lane
Urbandale
Found: 9/18/2020
ID: 14986
Name:
Type: Dog
Color: White and Rust
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Adult
Aurora and 70th
Urbandale
Found: 9/17/2020
ID: 14983
Name:
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
700 block roseland dr
Urbandale
Found: 9/17/2020
ID: 14981
Name:
Type: Dog
Color: black and white
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
75th & Douglas Ave
Des Moines - South
Found: 9/17/2020
ID: 14980
Name:
Type: Dog
Color:
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Baby
Grimes
Found: 9/16/2020
ID: 14973
Name: Unknown
Type: Cat
Color: Give full description
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Found At an apt complex SE Grimes Was hiding in neighbors plants
Des Moines - West
Found: 9/16/2020
ID: 14964
Name: Unknown
Type: Dog
Color: Tan with white on paws
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
I have her at my house waiting for the owner.
West Des Moines
Found: 9/16/2020
ID: 14962
Name:
Type: Dog
Color: Cream
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Pleasant Hill
Found: 9/15/2020
ID: 14958
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
I-235 Eastbound. Found with white dog. In Pleasant Hill together under a covered porch with food and water.
Pleasant Hill
Found: 9/15/2020
ID: 14957
Name:
Type: Dog
Color: White with tan curls
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
I-235 Eastbound Lane. Found with Black dog. Both on covered porch with food and water in Pleasant Hill.
West Des Moines
Found: 9/15/2020
ID: 14951
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Pleasant Hill
Found: 9/15/2020
ID: 14950
Name:
Type: Dog
Color: Grey/tan
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 9/14/2020
ID: 14966
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4600 Block of Pleasant Street
Des Moines - Central
Found: 9/14/2020
ID: 14953
Name: Harry
Type: Dog
Color: Brown and black
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen running away from 1914 King Ave Des Moines. He chases cars.
Johnston
Found: 9/14/2020
ID: 14948
Name: Ivovry
Type: Cat
Color: White and grey
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Adult
Very skirmish, last seen in Johnston
West Des Moines
Found: 9/14/2020
ID: 14947
Name:
Type: Dog
Color: black and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
500 block 1st street
Urbandale
Found: 9/14/2020
ID: 14946
Name:
Type: Cat
Color: Grey and Black
Breed: Himalayan
Gender: Unknown
Fixed: Unknown
Age: Adult
2700 block Beverly Drive
Urbandale
Found: 9/14/2020
ID: 14943
Name:
Type: Dog
Color: Yellow
Breed: Retriever, Labrador
Gender: Male
Fixed: Unknown
Age: Adult
Oskaloosa
Found: 9/13/2020
ID: 14940
Name: Unknown
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
West Des Moines
Found: 9/13/2020
ID: 14939
Name:
Type: Dog
Color: white
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
1200 block of Locus Street
Des Moines - South
Found: 9/13/2020
ID: 14937
Name:
Type: Dog
Color: Black with white on belly and feet
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Dog came in our garage dragging a chain. On Lacona Avenue. Please call 515-991-3547 if this is your pet.
West Des Moines
Found: 9/12/2020
ID: 14931
Name: Nova Rain
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
5900 Block of Vista Drive
Urbandale
Found: 9/11/2020
ID: 15680
Name: Doodle
Type: Cat
Color: White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
We have been feeding and sheltering him for a few months and just confirmed he belonged to some one in or around 50322. Unfortunately the phone number connected to his micro chip does not reach the original owner. His chip number was 985113000025805 and we were told his registered name was Doodle.
West Des Moines
Found: 9/11/2020
ID: 14928
Name: Slate
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Jasper County