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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 4/20/2017
ID: 5414
Name: Diesal
Type: Dog
Color: Tan and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Lost: 4/20/2017
ID: 5413
Name: Diesal
Type: Dog
Color: Tan and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 4/20/2017
ID: 5369
Name: Rosco
Type: Dog
Color: Tan with white markings
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 4/20/17 around 9pm Hes friendly with kids/adults/other animals.
Des Moines - East
Lost: 4/20/2017
ID: 5368
Name: Rosco
Type: Dog
Color: Tan/white markings
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 9pm April 20, 2017 near the Fairgrounds. He's friendly with kids/adults and other pets and of course loves food.
Des Moines - North
Lost: 4/19/2017
ID: 7053
Name: Lu
Type: Cat
Color: tan/brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at cash saver on euclid. he is very sweet and we have had him for 9 years. we miss him dearly he has been gone for 6 months... if seen please email or call!!!
Waukee
Lost: 4/19/2017
ID: 5357
Name: Marley
Type: Dog
Color: White tan
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
SE brick and SE Laurel behind Stivers in Waukee. Very scared. Just spayed this week.
Des Moines - North
Lost: 4/19/2017
ID: 5350
Name: Lu
Type: Cat
Color: tan/blakish brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Cash saver on NE 14th st or by truck stop/burger king NE 14th
Des Moines - South
Lost: 4/19/2017
ID: 5345
Name: King
Type: Dog
Color: black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
200-300 Hart Ave in south Des Moines. Lab-Pit mix. very friendly.
Des Moines - South
Lost: 4/18/2017
ID: 5352
Name: Zen
Type: Cat
Color: Black/White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 4/18/2017
ID: 5351
Name: Zen
Type: Cat
Color: Black/White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 4/18/2017
ID: 5348
Name: Meow meow
Type: Cat
Color: Brown with tan spots
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Around park fair mall
Des Moines - South
Lost: 4/18/2017
ID: 5341
Name: Sweets
Type: Dog
Color: White
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
At my house 8603 warren dr
Milo
Lost: 4/18/2017
ID: 5337
Name: Rizzo
Type: Cat
Color: orange white tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Outside Town and Country Vet Clinic, he was a stray up to a few weeks ago, got neutered and his shots last Thursday. He injuried his back left paw and was headed to the vet when he escaped from the car, he gets very nervous in a kennel so my brother was trying to comfort him tell til he jumped from his arms.
West Des Moines
Lost: 4/18/2017
ID: 5336
Name: Winnie
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
Very skittish. Call 515-554-2333. May run if approached.
Altoona
Lost: 4/17/2017
ID: 5408
Name: Meow
Type: Cat
Color: Orange with a little bit of white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
In Altoona
Monticello
Lost: 4/17/2017
ID: 5340
Name: toto
Type: Dog
Color: brown/black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen at 430pm at our house in scotch grove. was gone by 830pm very shy.
Ankeny
Lost: 4/17/2017
ID: 5338
Name: Jewel
Type: Cat
Color: Black and Tan
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Senior
Jewel is incredibly shy but very sweet. She may hiss if scared but never is mean. She's always been a house cat. She has a tan diamond marking between her shoulder blades.
Huxley
Lost: 4/17/2017
ID: 5333
Name: Lucy
Type: Dog
Color: Black with White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She is mostly black with a white chest and white spots on a couple of her paws. She is very sweet and will come to her name. Food is always a yes.
Huxley
Lost: 4/17/2017
ID: 5332
Name: Molly
Type: Dog
Color: Brindle/Black/White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
May come off as aggressive. Do not approach, let her come to you. She can be bribed with food. Once comfortable with you, she is very lovey. Her head is brindle, as well as her hips and shoulders. The rest of her body is black and white. She has a black saddleback. She has a white spot on back of her head that looks similar to an upside down heart.
Des Moines - South
Lost: 4/17/2017
ID: 5324
Name: Scarlett
Type: Dog
Color: White and brindle
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Southside by fleur, very friendly dog, energetic, has a scar on her belly from being fixed. No tags on collar. Knows sit, kick it down, stay and roll over.
Des Moines - North
Lost: 4/17/2017
ID: 5318
Name: Chico
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 1st & Tiffin 4/7/17. If you have any information on where he maybe please contact me at (515)721-4215 or (515)991-0566
Des Moines - South
Lost: 4/16/2017
ID:
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
se 14th and maury
Des Moines - South
Lost: 4/16/2017
ID: 5322
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
se 14th and maury
Des Moines - South
Lost: 4/16/2017
ID: 5321
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
Last seen as 14tg and mairy
Ames
Lost: 4/16/2017
ID: 5316
Name: Simba
Type: Cat
Color: Striped top, white underbelly and paws
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
West Ames Not declawed Loves west food