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>='1606262400')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 10/10/2020
ID: 15183
Name:
Type: Cat
Color: White & Orange Flame Point
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Adult
3000 University Avenue
West Des Moines
Found: 10/10/2020
ID: 15182
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Mills Civic Parkway & Cascade Avenue (found with brown tabby)
West Des Moines
Found: 10/10/2020
ID: 15181
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Mills Civic Parkway & Cascade Avenue (found with black cat)
Johnston
Found: 10/9/2020
ID: 15172
Name: Unknown
Type: Cat
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found with another cat. Unknown if they live together. No microchip.
Johnston
Found: 10/9/2020
ID: 15171
Name: Betty Boo
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found with another cat. She has a microchip but address and phone number are incorrect.
West Des Moines
Found: 10/9/2020
ID: 15169
Name:
Type: Dog
Color: brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Senior
1500 block 19th street
Des Moines - Central
Found: 10/9/2020
ID: 15168
Name:
Type: Dog
Color: Brown & black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
At 4049 43rd st des moines, is 50310. Keeping in our dog crate French porch.
Des Moines - South
Found: 10/9/2020
ID: 15166
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Westgate
Found: 10/8/2020
ID: 15180
Name: Jabba
Type: Dog
Color: Black and brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
Dog is chipped but was re homed and new owner did not register him
Des Moines - Central
Found: 10/8/2020
ID: 15164
Name:
Type: Dog
Color: Tri color
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Found: 10/8/2020
ID: 15158
Name:
Type: Dog
Color: Brown and cream
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/8/2020
ID: 15157
Name:
Type: Dog
Color: Grey
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/7/2020
ID: 15150
Name:
Type: Dog
Color: white
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Ashworth Road and 40th Street
Grimes
Found: 10/7/2020
ID: 15149
Name: Lydia
Type: Cat
Color: White and grey, some black
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Around SE 35th St in Grimes, Iowa near Cutty's/Johnston area
Des Moines - North
Found: 10/6/2020
ID: 15146
Name:
Type: Dog
Color: Brown white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Pit mix skittish but a good boy. Call me and come get him if he is yours
West Des Moines
Found: 10/5/2020
ID: 15136
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/4/2020
ID: 15135
Name:
Type: Dog
Color: White and Tan
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Johnston
Found: 10/4/2020
ID: 15134
Name: Unknown
Type: Cat
Color: Black with a white patch on it's chest and 2 white spots on it's tummy
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Very friendly but can tell it is scared a little. Kept it segregated from the rest of the cats last night to make it feel more comfortable. I will be taking this kitty to my vet today to see if he/she has a chip and determine what sex it is. I think it is female but not sure. Found on Hyperion Point in Johnston.
West Des Moines
Found: 10/4/2020
ID: 15128
Name:
Type: Dog
Color: white
Breed: Poodle
Gender: Male
Fixed: Not Neutered
Age: Adult
600 block of 17th street, found with small tricolor terrier mix
West Des Moines
Found: 10/4/2020
ID: 15127
Name:
Type: Dog
Color: Black, White and tan tricolor
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
600 block of 17th street, found with a small, white poodle mix
Urbandale
Found: 10/4/2020
ID: 15125
Name:
Type: Cat
Color: Black, white flecks in fur
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
12800 block of Walnut Ridge
West Des Moines
Found: 10/4/2020
ID: 15124
Name: Queen
Type: Cat
Color: Brown & White Tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Pointe West Apartments
Waukee
Found: 10/3/2020
ID: 15152
Name:
Type: Cat
Color: Gray
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Found: 10/3/2020
ID: 15118
Name:
Type: Dog
Color: Fawn
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
600 block Boston Ave
Clive
Found: 10/1/2020
ID: 15104
Name:
Type: Dog
Color: Tan & White
Breed: Mastiff
Gender: Male
Fixed: Unknown
Age: Adult
Near Crestview School