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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 9/11/2016
ID: 3845
Name: Ace
Type: Dog
Color: Brown/white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
He's very nice. Has 1white spot on top of his head.
Des Moines - South
Lost: 9/10/2016
ID: 3835
Name: Missy
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Senior
My parents dog has been missing for over an hour on the south side of Des Moines. They live near Jordan Park and Love Joy Elementary. If you see her please call 515-577-8632
Des Moines - South
Lost: 9/10/2016
ID: 3833
Name: Machete
Type: Dog
Color: Brown
Breed: English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
At around 10:30
Birmingham
Lost: 9/9/2016
ID: 3843
Name: Sophie
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Female
Fixed: Not Neutered
Age: Young
Birmingham
Lost: 9/9/2016
ID: 3842
Name: Sophie
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Female
Fixed: Not Neutered
Age: Young
Hwy 1 N, Birmingham next to the storage units.
Vinton
Lost: 9/8/2016
ID: 3828
Name: Buster
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Vinton Iowa
Des Moines - North
Lost: 9/7/2016
ID: 3825
Name: Mac
Type: Dog
Color: White and grey
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 9/7/2016
ID: 3824
Name: Judge
Type: Cat
Color: Brown with black markings white jaw green eyes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen Normandy terrace apartments
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.