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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Grimes
Lost: 11/21/2017
ID: 7461
Name: Jazmine
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
Jazmine has a white patch on her chest and an underground fence color on.
Grimes
Lost: 11/21/2017
ID: 7460
Name: Jazmine
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
Jazmine has a white patch on her chest and an underground fence color on.
Des Moines - West
Lost: 11/21/2017
ID: 7447
Name: Pippin
Type: Dog
Color: Black and White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Senior
Last seen the evening of 11/21/17. He was just diagnosed with an intestine problem and needs his meds.
Clive
Lost: 11/21/2017
ID: 7445
Name: Mel
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Last seen at the PetSMart in Clive off University.
Waukee
Lost: 11/21/2017
ID: 7443
Name: Mimi
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
last seen in SE Glendale Drive, Waukee
Des Moines - East
Lost: 11/21/2017
ID: 7438
Name: Trig
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
On E 46th by the Des Moines complex ball fields
Des Moines - Central
Lost: 11/20/2017
ID: 7449
Name: JINX
Type: Cat
Color: Calico- long hair
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
beaverdale area
Dubuque
Lost: 11/20/2017
ID: 7441
Name: Dodat
Type: Dog
Color: white grey
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 11/20/2017
ID: 7433
Name: Dewey
Type: Dog
Color: White/Black
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 11/20/2017
ID: 7431
Name: Kenaey
Type: Dog
Color: Brown with black
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Adult
On 10th st des moines
Des Moines - East
Lost: 11/19/2017
ID: 7992
Name: Baby
Type: Dog
Color: White brown brindle
Breed: Staffordshire Bull Terrier
Gender: Female
Fixed: Not Applicable
Age: Baby
Dec 23 michelles lounge with Nick Briner and Amy Grover baby was in white toyota 4 runner blacked out rims missouri plates. Then eyewitness seen her apt bldg behind home plate diner east 14th white bldg first one then spotted at southridge trailer park 802 county line road trailer 242 sarah casey and john scott also terri mefford wrote on paws her niece has this dog heres number no number given after tracking her down she states she made a mistake. What lieing or being honest i will send police there today. I want my dog shr could be in diagonal iowa his brothers josh briner eagleville missouri another brother or stuart iowa josh burt a friend of his or boone matt grenshaw but shes somewhere he has no druvers licsense if u see her and i get her back i have a reward just calk ill di rest please help me
Des Moines - North
Lost: 11/19/2017
ID: 7436
Name: Roxy
Type: Dog
Color: White with brown and black spots
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen around 3pm at home. She is friendly. She is so ugly she is cute!
Altoona
Lost: 11/19/2017
ID: 7428
Name: RIZZIE
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa 5153262782
Altoona
Lost: 11/19/2017
ID: 7427
Name: RIZZIE
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa 5163262782
Altoona
Lost: 11/19/2017
ID: 7425
Name:
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa
Des Moines - South
Lost: 11/18/2017
ID: 7434
Name: Jack Daniel’s Whitlow
Type: Dog
Color: Brown,Black,Tan
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Senior
Saturday at 6pm he was let out of the back yard .we searched every where but could not find him .miss him so much
Des Moines - South
Lost: 11/18/2017
ID: 7419
Name: Sampson
Type: Dog
Color: Brown and white
Breed: English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Around 1pm on sw 12th and Hyde drive
Des Moines - South
Lost: 11/17/2017
ID: 7412
Name: Miley or “My My”
Type: Cat
Color: White with big grey spots
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She is scared of outside doesn’t usually go more than 4 feet if she gets outside and darts back in. She is probably scared. She got out when bringing in groceries. Lost from SW 6th and Thornton area.
West Des Moines
Lost: 11/16/2017
ID: 7558
Name: Elwood
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Elwood likes to roam and we think someone may think he is a stray. His brother Jake misses him and so do we.
Ankeny
Lost: 11/16/2017
ID: 7410
Name: teddy
Type: Dog
Color: brown
Breed: Poodle Toy
Gender: Male
Fixed: Unknown
Age: Adult
UPDATE!!!! HE HAS BEEN FOUND AND RETURNED HOME. THANK YOU!
Des Moines - South
Lost: 11/15/2017
ID: 7442
Name:
Type: Cat
Color: Black
Breed: Poodle Toy
Gender: Male
Fixed: Neutered
Age: Adult
Medium- Large indoor/ outdoor cat WITHOUT HIS COLLAR. Overly friendly... probably has a second family somewhere, but we are looking for him. His names Frank, he's up to date on all shots, neutered and microchipped but he has not been turned into ARL. We live close to Quick Trip on se 14th and waterous and he has been known to visit.
Des Moines - North
Lost: 11/15/2017
ID: 7415
Name: bessie
Type: Dog
Color: white and black with black spots
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
last seen in the area of martin luther king and Euclid. she is a very friendly dog, can't post a photo because I didn't take any. also she is black and white with a lot of black spots. also she has a micro chip in #985113000958439
Pleasant Hill
Lost: 11/14/2017
ID: 7398
Name: Pookie
Type: Cat
Color: White and grey tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He’s mostly white with patches of grey tabby on his head, back, rear legs and tail. He is obese, neutered, front declawed and has been a strict indoor cat so he has no collar. He is incredibly friendly but may be skittish due to the situation.
Pella
Lost: 11/13/2017
ID: 7448
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Young
Outside of Otley at home
Pella
Lost: 11/13/2017
ID: 7444
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at home in county outside of Otley, Iowa