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
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
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
Des Moines - North
Found: 9/10/2020
ID: 14933
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale
Found: 9/10/2020
ID: 14930
Name:
Type: Cat
Color: persian long hair
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Friendly, approached me, has all claws. No microchip.