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 = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1571184000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 7/4/2016
ID: 3380
Name: Annabelle
Type: Dog
Color: Brindle
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard 400 block E Sheridan Ave. Her pinky toenails are black the rest are white. She is very loved and missed, please help find her. She's afraid of fireworks and thunder storms. She is very spoiled, always inside, on furniture and sleeps in our bed.
Des Moines - North
Lost: 7/4/2016
ID: 3379
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard 400 block E Sheridan Ave. Her pinky toenails are black the rest are white. She is very loved and missed, please help find her. She's afraid of fireworks and thunder storms. She is very spoiled, always inside, on furniture and sleeps in our bed.
Des Moines - East
Lost: 7/4/2016
ID: 3377
Name:
Type: Dog
Color: Brow
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Grimes
Lost: 7/4/2016
ID: 3356
Name: Moo Moo
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Cuttys camp ground in Grimes Iowa
Des Moines - West
Lost: 7/4/2016
ID: 3350
Name: Frogs
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Young
She has all claws. She was also born with a broken tail so there's a kink at the end!
Des Moines - East
Lost: 7/4/2016
ID: 3342
Name: Lemmy
Type: Dog
Color: Brown, Black, White
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
He was last seen behind my grandmother's fence but must have been extremely scared of the fireworks. He was around E. 13th and Hull ave. He has a blue and grey stripe shirt on that has a blue paw on the collar of his shirt. He's very scared, please bring him home.
Des Moines - East
Lost: 7/4/2016
ID: 3341
Name: Lemmy
Type: Dog
Color: Black, Brown, and White
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
He was last seen behind my grandmother's fence but must have been extremely scared of the fireworks. He was around E. 13th and Hull ave. He has a blue and grey stripe shirt on that has a blue paw on the collar of his shirt. He's very scared, please bring him home.
Des Moines - East
Lost: 7/4/2016
ID: 3340
Name: Duce
Type: Dog
Color: Black and white
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Adult
By 14th and euclid
Des Moines - South
Lost: 7/4/2016
ID: 3338
Name: Jax
Type: Dog
Color: White
Breed: English Setter
Gender: Male
Fixed: Unknown
Age: Young
He has brown spot on his belly. He is very friendly but shy towards strangers!
Des Moines - North
Lost: 7/4/2016
ID: 3327
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in back yard. 400 block East Sheridan Ave. neighbor said he seen her run East on East Sheridan about 9:30-9:45 this morning. She is very scared of fireworks.
Des Moines - North
Lost: 7/4/2016
ID: 3326
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in back yard. Neighbor said he seen run to the East of 400 block East Sheridan Ave about 9:30-9:45 this morning
Des Moines - South
Lost: 7/3/2016
ID: 3996
Name: Alize
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
If anyone sees her she is not with her correct owner these sick people even stole her dog food to feed her I've looked everywhere :/
Des Moines - East
Lost: 7/3/2016
ID: 3786
Name: Milla
Type: Dog
Color: Brown with white on breast and front paws
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 7/3/2016
ID: 3651
Name: Sheebah
Type: Dog
Color: Black and white
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
She's beautiful unique 1 of a kind... We miss our family!
Ames
Lost: 7/3/2016
ID: 3467
Name: Otis
Type: Dog
Color: Silver-gray
Breed: Weimaraner
Gender: Male
Fixed: Neutered
Age: Adult
Otis got out of yard and was last seen at 13th St & Northwestern in Ames Sunday 7/3/16 before Ames Fireworks. Very friendly, had a blue collar & tag. 8 yr old family pet, silver gray color with white spot on chest.
Des Moines - East
Lost: 7/3/2016
ID: 3408
Name: sheebah
Type: Dog
Color: black and white
Breed: Weimaraner
Gender: Female
Fixed: Not Applicable
Age: Young
please if any1 has seen her or have any information we miss our family very much.
Des Moines - East
Lost: 7/3/2016
ID: 3343
Name: Milla
Type: Dog
Color: Light brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
East Hubbell. Very friendly and excitable.
Des Moines - South
Lost: 7/3/2016
ID: 3319
Name: Buster
Type: Dog
Color: White and Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the Easter Lake area. You can also call Gaylene at 515-480-2936 Update: He was spotted by a neighbor on the corner of SW 9th and Leach on 07/03
West Des Moines
Lost: 7/3/2016
ID:
Name: Lulu
Type: Dog
Color: Brown, white, tan
Breed: Brittany Spaniel
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Last seen in our backyard which backs to the woods behind Ponderosa Dr and S Prairie View.
Council Bluffs
Lost: 7/2/2016
ID: 3532
Name: Izzie
Type: Dog
Color: Blue Merle (grey and white)
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Senior
Microchip information is out of date, it has my maiden name Hansel and the phone number is likely wrong. Izzie has blue eyes and appears to be wearing eye makeup with her coloring.
Boone
Lost: 7/2/2016
ID: 3360
Name: Hercules
Type: Dog
Color: brown brindle
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
By energy star. Very friendly
Winterset
Lost: 7/2/2016
ID: 3315
Name: Remington
Type: Dog
Color: White with black and brown spots
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen July 2nd,2016. He will answer to the name of Remington.He disappear from 53 Grade street,Winterset,Ia.
Clive
Lost: 7/2/2016
ID: 3312
Name:
Type: Cat
Color:
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Adult
Bengal cat killed and was moved the median between 80th and 82nd and Hickman in Clive.
Clive
Lost: 7/2/2016
ID: 3310
Name:
Type: Cat
Color:
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Adult
Sorry post should unknown sex. Bengal was hit and killed is in the grass median between 80th and 82nd on Hickman.
Dubuque
Lost: 7/2/2016
ID: 3297
Name: Carter
Type: Dog
Color: Tan and Silver
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Jaeger Dr and Brian St in Dubuque.