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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 9/7/2016
ID: 3816
Name: Judge
Type: Cat
Color: Beige/Brown with black markings
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 9/7/2016
ID: 3815
Name: Judge
Type: Cat
Color: Brown light brown with black marking whit jaw an green eyes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 9/7/2016
ID: 3814
Name: Judge
Type: Cat
Color: Beige/Brown with Black markings
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Normandy Terrace Apartments
Des Moines - East
Lost: 9/6/2016
ID: 3794
Name: Cutie
Type: Dog
Color: Tan and white
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Young
E 37th Court and Mahaska Street Sea Moines Ia 50317
Westgate
Lost: 9/5/2016
ID: 3863
Name: Sissy
Type: Dog
Color: Brindle
Breed: Mountain Cur
Gender: Unknown
Fixed: Neutered
Age: Adult
Sunday night about 11:30. She is very friendly and likes car rides. She is a farm dog. She was with our other dog. They went out. He came back and she did not.
Cedar Rapids
Lost: 9/4/2016
ID: 3839
Name: Cocoa
Type: Dog
Color: Dark brown with tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
Was lost North of Albunett on Sunday 9/4 but 2 boys found him and took him into Cedar Rapids. Cocoa ran off frm them Monday 9/5. He's very friendly but please do not chase. Only release him to my self or my husband (Jamie and Matthew Slife)
Des Moines - Central
Lost: 9/4/2016
ID: 3817
Name: Mittens
Type: Cat
Color: Black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
He left the house about midnight sunday. He has never been gone more than 36 hours. He has an extra claw / toe so his front paws look like a mitten. My 11 year old daughter has been crying to sleep each night and misses him terribly.
Des Moines - Central
Lost: 9/4/2016
ID: 3790
Name:
Type: Dog
Color: Red and white-has blue eyes
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
We know who took the puppy, but we are not sure what he will do with it. We only know that we did not and do not want the puppy gone we want her back quickly. She was going to be a present for my kids.
Des Moines - Central
Lost: 9/4/2016
ID: 3789
Name:
Type: Dog
Color: white-has blue eyes
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
We know who took the puppy, but we are not sure what he will do with it. We only know that we did not and do not want the puppy gone we want her back quickly. She was going to be a present for my kids.
Des Moines - South
Lost: 9/4/2016
ID: 3784
Name: Shadow
Type: Cat
Color: Gray with gray stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Shadow escaped today. He is very timid and may not let you pick him up. We live in Grays Lake Apartments on Fleur Dr.
Des Moines - East
Lost: 9/3/2016
ID: 3798
Name: Susie
Type: Dog
Color: Sable/Tri - Color
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on E14th and Osceola. Susie is about 23pounds and has a small bald spot on her back (close to tail end). Susie has been spade. She is very friendly. I know she is missing her human, as I am missing her. If found please call 515-250-9553
La Porte City
Lost: 9/1/2016
ID: 4764
Name: SOX
Type: Cat
Color: black body, white chest and stomach, white paws
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Unknown
Age: Adult
lost around E. Tama Rd. LPC, IA was wearing lime green collar no claws
Perry
Lost: 9/1/2016
ID: 4005
Name: Timmy
Type: Cat
Color: Black and brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
4th and Park
Des Moines - South
Lost: 9/1/2016
ID: 3956
Name: Lucy
Type: Cat
Color: mostly black calico. with orange and grey. orange strip goes straight down the middle of her forehead
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
last seen by dumpsters at the save-a-lot on 9th and park.
Bondurant
Lost: 9/1/2016
ID: 3770
Name: Ashed
Type: Cat
Color: Grey, brown, black
Breed: Maine Coon
Gender: Female
Fixed: Not Neutered
Age: Young
Late night Sept 1st
Des Moines - North
Lost: 9/1/2016
ID: 3765
Name: Buster
Type: Dog
Color: Brown
Breed: Australian Cattle Dog
Gender: Male
Fixed: Neutered
Age: Young
His tags fell off when the wire chain broke. He is dragging part of the green wire chain.
Des Moines - East
Lost: 8/31/2016
ID: 3838
Name: Daisy may
Type: Cat
Color: Tried and white
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen Aug 31st. Black collar with moon and stars purple flea collar. Black gray toe on hind leg.
Des Moines - West
Lost: 8/31/2016
ID: 3788
Name: Gracie
Type: Cat
Color: Tuxedo
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
No collar. Very shy.
Des Moines - East
Lost: 8/31/2016
ID: 3773
Name: Daisy may
Type: Cat
Color: Tri and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
E23rd and capital. Purple flea collar black collar with moon and stars.
Des Moines - East
Lost: 8/31/2016
ID: 3771
Name: Daisy may
Type: Cat
Color: Tried and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Last seen e23rd and capital. Has black collar with sun and moons. Purple flea collar. Scares easy but is very sweet. Spayed and chipped
Ankeny
Lost: 8/30/2016
ID: 3748
Name: unknown
Type: Cat
Color: black/gray/tan
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult
SE Richland Ct and SE 8th Street. Declawed
Des Moines - West
Lost: 8/30/2016
ID: 3746
Name: Maya
Type: Dog
Color: Grey and white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Off of 63rd and railroad in Des Moines Iowa
Des Moines - East
Lost: 8/29/2016
ID: 3741
Name: Quincy
Type: Dog
Color: Tan and white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
3123 Guthrie Ave Has tags on collar from hubbell animal vet and city of dm
Des Moines - East
Lost: 8/29/2016
ID: 3740
Name: Quincy
Type: Dog
Color: Tan and white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
3123 Guthrie Ave Has tags on collar from hubbell animal vet and city of dm
Williamsburg
Lost: 8/28/2016
ID: 4038
Name: Trooper
Type: Dog
Color: brown & black
Breed: Mastiff
Gender: Male
Fixed: Neutered
Age: Senior
Last seen west of Williamsburg. Crossed invisible fence with our doberman but only doberman returned (they never separate). He is very friendly and would get in anybody's car.