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>='1573257600')) ORDER BY pm1.meta_value DESC, post_date DESC
Nashua
Lost: 6/19/2015
ID: 811
Name: Bailey
Type: Dog
Color: Black with small white diamond on chest
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
2 1/2 years old, Last seen at family home. 7 miles Southeast of Nashua. 5 miles North of Horton, Friday afternoon between 3-4 pm 6/19/2015. Has small petite lab face, Has 2 scars on top of nose from family cat. Very friendly, and playful, loves kids. Likes to be held on your lap. Has no collar due to tangled with skunk on Wed, and hadn't got new one yet. Very scared of storms. Bailey is the one with the orange collar. the other one is her sibling sister Abby who misses her very much also. They have never been apart since birth.
Des Moines - South
Lost: 6/18/2015
ID: 860
Name: Squishy
Type: Cat
Color: gray and white
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen at home she doesn't leave home for long she is very friendly likes to get in cars and nap and also does a very rare bucking thing against people
Des Moines - Central
Lost: 6/18/2015
ID: 800
Name: “Gottoe” samuel thomas beck III
Type: Cat
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Beaver & Douglas Ave Des Moines Iowa
Windsor Heights
Lost: 6/18/2015
ID: 785
Name:
Type: Cat
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 6/16/2015
ID: 814
Name: geno
Type: Dog
Color: tan and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
His right eye is always red, blood shot. His toenails on the right are different colored. Black white white black. My family hasnt been the same since he got out.
Des Moines - South
Lost: 6/16/2015
ID: 799
Name: Cheddar
Type: Cat
Color: Orange & white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
My cat is an inside/outside cat. He will get very aggressive if he is not let outside at least one to two times a day We have been letting him outside for about 5 years now. We always wondered why he was so aggressive the first few years of his life, as the vet told us to let him outside every so often. He usually comes back but on Tuesday he did not and still hasn't. I miss my baby, if you know anything or have seen him please call my number.
De Soto
Lost: 6/15/2015
ID: 770
Name: Diesel/Bella
Type: Dog
Color: Grey/Tan
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
BACK HOME
Adel
Lost: 6/15/2015
ID: 769
Name: Bella/Diesel
Type: Dog
Color: fawn/white
Breed: English Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
BACK HOME
De Soto
Lost: 6/15/2015
ID: 764
Name: diesel
Type: Dog
Color: grey/tan
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
BACK HOME
Des Moines - Central
Lost: 6/14/2015
ID: 762
Name: Tootie
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Female
Fixed: Not Applicable
Age: Adult
4004 University and 39th street vicinity. Blue Indian Ring Neck Parakeet with a ruby red bill, also silver ankle bracelet.
Urbandale
Lost: 6/14/2015
ID: 760
Name: Suzy
Type: Cat
Color: Grey white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard of 4515 84th St in Urbandale. She is a tuxedo tabby mix with grey and white. Also has a green flea and tick collar. Went missing around 10:30 pm on 6/14/2015.
Des Moines - Central
Lost: 6/13/2015
ID: 939
Name: Tootie
Type: Bird
Color: Blue Indian Ring neck Parakeet, female
Breed: Parakeet
Gender: Female
Fixed: Unknown
Age: Adult
4004 University, 39th and University, central Des Moines close to Cottage Grove, Kingman streets.
Des Moines - Central
Lost: 6/13/2015
ID: 815
Name: Tootie
Type: Bird
Color: Blue Indian Ring neck Parakeet, female
Breed: Parakeet
Gender: Female
Fixed: Unknown
Age: Adult
Last seen 4004 University, Des Moines, Ia and in the vicinity of 39th and University. Our bird also has a loud call. Please call Lynnette 515-279-0777 Tootie is our darling baby, please bring her home. She may be anywhere on the west side of Des Moines or even farther away.
Newton
Lost: 6/13/2015
ID: 778
Name: Mouse
Type: Cat
Color: black and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Young
Lost near Berg school.
Cedar Falls
Lost: 6/13/2015
ID: 747
Name: Belle
Type: Dog
Color: Tricolor
Breed: Basset Hound
Gender: Female
Fixed: Unknown
Age: Baby
Staying at 1900 vera way.. Still has least hooked on collar.
Des Moines - East
Lost: 6/12/2015
ID: 768
Name: dotsie
Type: Dog
Color: Brown and a few white spots
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
Dotsie is home now:)
Des Moines - East
Lost: 6/12/2015
ID: 767
Name: dotsie
Type: Dog
Color: Brown and a few white spots
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
Dotsie got out of the yard early Friday morning please contact me 5152505299 she was last seen around 8pm by a lady on e33rd ct please help me find her
Des Moines - East
Lost: 6/12/2015
ID: 743
Name: dotsie
Type: Dog
Color: brown and white
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
She was last seen in tge back yard around e26th in between university and maple
Des Moines - East
Lost: 6/12/2015
ID: 742
Name: dotsie
Type: Dog
Color: brown and white
Breed: Basset Hound
Gender: Unknown
Fixed: Not Neutered
Age: Young
She was last seen in tge back yard around e26th in between university and maple
Norwalk
Lost: 6/12/2015
ID: 740
Name: Lily
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Female
Fixed: Neutered
Age: Adult
South of Rolling Hills golf course. Lily is very timid and may not willing come to a stranger.
West Des Moines
Lost: 6/11/2015
ID: 804
Name: Miss Kitty (AKA Ally)
Type: Cat
Color: Grey and White
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
On 9th street and Locust, Miss Kitty is missing her top left K-9 tooth.
Des Moines - Central
Lost: 6/11/2015
ID: 734
Name: Baltu
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
New York aVe 103
Osceola
Lost: 6/10/2015
ID: 732
Name: Max
Type: Dog
Color: tan
Breed: Pug
Gender: Male
Fixed: Not Neutered
Age: Adult
Max is a rescue dog and was just moved into his new foster home that day.
Des Moines - Central
Lost: 6/8/2015
ID: 724
Name: George
Type: Cat
Color: Grey striped tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
18th and woodland street. Sherman hill. Sweet as ever
Des Moines - North
Lost: 6/8/2015
ID: 722
Name: Nikita
Type: Dog
Color: whit grey and black husky
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Last seen on Amherst by Aurora between 2nd and 14th in des moines. she is a runner but the sweetest dog.