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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 11/18/2019
ID: 12869
Name: Brooke
Type: Cat
Color: Black/White Gray Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Originally missing from around 128th and Douglas in Urbandale. Potentially seen near 59th and Meredith,
Martelle
Lost: 11/16/2019
ID: 12871
Name: Whiskers
Type: Cat
Color: Black and Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - West
Lost: 11/16/2019
ID: 12854
Name: Ruth
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Last seen at 4520 Merle Hay Rd. Ruth has cancer and requires medications for them. She escaped while our carpets were being cleaned. She is slightly deaf and blind.
Des Moines - North
Lost: 11/16/2019
ID: 12848
Name: Ruth
Type: Cat
Color: Calico (black, orange, white)
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Last seen near Car City on Merle Hay Rd
Des Moines - North
Lost: 11/16/2019
ID: 12844
Name: Baby girl
Type: Dog
Color: Black White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Young
Loser over but McHenry Park
Ankeny
Lost: 11/16/2019
ID: 12841
Name: Angel
Type: Dog
Color: Black and brown
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Young
Around noon, shes very timid and scared of men
Lucas
Lost: 11/15/2019
ID: 12864
Name: Doc
Type: Dog
Color: Tri color black/tan/white
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Black collar w/ farm dog painted on. Microchipped and has rabies tag and microchip tag attached. Last seen on our farm before I went to work. This is the 3rd time someone has grabbed him. They took both our small dogs the first time but the rat terrier wasn't taken the last 2 times just the beagle.
Des Moines - North
Lost: 11/15/2019
ID: 12853
Name: Maui
Type: Cat
Color: White with large black spots on back and head
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen chasing something thru back yards between Royer and Arthur, between 1500 and 1700 block. A scardey cat, very loving and babied. Maybe shut up in someones garage or shed since it was 55 degrees Friday.
Des Moines - Central
Lost: 11/15/2019
ID: 12837
Name: Diesel
Type: Dog
Color: Black and white
Breed: Boykin Spaniel
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen in beaverdale on 39th st
West Des Moines
Lost: 11/15/2019
ID: 12833
Name: unknown
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Senior
Altoona
Lost: 11/15/2019
ID: 12830
Name: Charlotte
Type: Dog
Color: Dark brown/black
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Near the library in Altoona, pond area. She is very friendly and loves to bark
Ankeny
Lost: 11/14/2019
ID: 12828
Name: Bizkit
Type: Cat
Color: Yellow/orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
He has a fluffy tail!
Des Moines - North
Lost: 11/13/2019
ID: 12821
Name: Tazz
Type: Cat
Color: Grey with black stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
East 12th street Des Moines
Dubuque
Lost: 11/12/2019
ID: 12820
Name: Elsa
Type: Dog
Color: Brown and white
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in shullsburg wi she also has a bad ear and need regular medication
Sheffield
Lost: 11/11/2019
ID: 12893
Name: Bosco
Type: Dog
Color: Brown
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
East of Sheffield, Iowa
Indianola
Lost: 11/11/2019
ID: 12813
Name:
Type: Dog
Color: Black with a little white on his chest.
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
South of Indianola.
Carlisle
Lost: 11/11/2019
ID: 12811
Name: Bandit(L) Elvira(R)
Type: Dog
Color: Black, white, gray
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
Last known location was Carlisle. They will most likely be together.
Newton
Lost: 11/11/2019
ID: 12809
Name: Ally
Type: Dog
Color: Black
Breed: Yorkie Poo
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in the Aurora Heights Elementary School area. Not always friendly at first but if you talk to her she'll come to you. Please help find her, we miss her so much!
Des Moines - Central
Lost: 11/11/2019
ID: 12805
Name: Bailey
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Bailey ran off this evening before we got a chance to put her collar on. She was last seen in the drake neighborhood. She’s a senior dog with liver cancer and it’s super important that we locate her. We live off 39th and university she has her red bandanna around her neck. Please call (515)-508-1802 or (515)-710-6416 if you see her
Runnells
Lost: 11/10/2019
ID: 12824
Name: Fluffy & Milly
Type: Dog
Color: White and black
Breed: Great Pyrenees
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - Central
Lost: 11/10/2019
ID: 12819
Name: sPOOKY
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen mid-day on Sunday. She would be around 33rd/Aurora & Lower Beaver
Des Moines - East
Lost: 11/10/2019
ID: 12794
Name: Royal
Type: Dog
Color: Grey n White
Breed: Calico
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 11/10/2019
ID: 12792
Name: Apollo
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
At crosswinds apartment if anyone see him call Jeremiah 515 512 2516 or Catie At 515 339 0937 thank u
St. Charles
Lost: 11/9/2019
ID: 12791
Name: Diesel
Type: Dog
Color: Red Tri
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on a farm along the interstate at the Saint Charles exit. Acting skittish towards people.
Des Moines - South
Lost: 11/8/2019
ID: 12787
Name: Glizzy
Type: Dog
Color: Black, Brown, some White
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
6901 Se 14th.. Val Vista trailer court. Off E 14th and Bloomfield Dr.