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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 11/7/2015
ID: 1831
Name:
Type: Dog
Color: Cream white
Breed: GoldenDoodle
Gender: Male
Fixed: Unknown
Age: Adult
Looks like a young adult golden-doodle or lab-doodle. No tags.
Melcher-Dallas
Lost: 11/6/2015
ID: 1890
Name: Myrl
Type: Dog
Color: black&brown brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Senior
He is nice & will wiggle his whole body if happy. He is scared of storms or other loud noises.
Lovilia
Lost: 11/6/2015
ID: 1876
Name: cochise
Type: Dog
Color: blue merle/ white spots on blue
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
WHITE SPOT ON HIS FOREHEAD
Cedar Falls
Lost: 11/6/2015
ID: 1868
Name: Maddy
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
700 W Ridgeway Ave, Cedar Falls, IA 50613
Des Moines - East
Lost: 11/6/2015
ID: 1829
Name: Barley
Type: Dog
Color: Grey and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly. Companion dog for my father. Last seen at E 38th and E Ovid Ave
Des Moines - East
Lost: 11/6/2015
ID: 1830
Name: Barley
Type: Dog
Color: Grey and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly. Companion dog for my father. Last seen at E 38th and E Ovid Ave
Des Moines - West
Lost: 11/6/2015
ID: 1823
Name:
Type: Dog
Color: white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Found on the intersection of 60th and Forest
Ankeny
Lost: 11/6/2015
ID: 1821
Name: Sassy Sox
Type: Dog
Color: Fawn
Breed: Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
South east Ankeny by Firestation
Ankeny
Lost: 11/6/2015
ID: 1820
Name: Sassy Sox
Type: Dog
Color: Fawn
Breed: Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
South east Ankeny by Firestation
Des Moines - Central
Lost: 11/6/2015
ID: 1819
Name: Nigel
Type: Dog
Color: Brown/Black/White
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 11/5/2015
ID: 1895
Name: Callie
Type: Cat
Color: calico with white stomach and under her neck
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
My house at Park side East Apartments. She is a loving cat and will go up to anyone. She has never been outside before and I just hope she is ok.Please contact me if you see her or find her.
Clive
Lost: 11/5/2015
ID: 892
Name: MUTTLEY
Type: Dog
Color: WHITE but may be dirty from roaming
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
NEAR BAKERS RIDGE 114TH UNIVERSITY CLIVE. PLEASE CALL 515-897-8795 He may be dirty now and hair may be longer. We really miss him and pray he comes home asap!
Des Moines - North
Lost: 11/5/2015
ID: 879
Name: MUTTLEY
Type: Dog
Color: WHITE but he may be dorty from roaming.
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
HE JUMPED OUT OF A FRIENDS CAR THROUGH THE WINDOW BETWEEN DES MOINES AND URBANDALE. HE SHOULD HAVE A TAG WITH ADDRESS AND PHONE NUMBER. HE IS VERY FRIENDLY BUT GETS SCARED EASY WHEN WE LEAVE TOWN call or text 515-897-8975
Carlisle
Lost: 11/3/2015
ID: 1842
Name: Sampson
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Carlisle
Lost: 11/3/2015
ID: 1816
Name: Sampson
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Lost or taken on Tuesday night between 8:30pm-6:00am. He never stays out without coming right back in the early morning and we miss him desperately.
Des Moines - South
Lost: 11/2/2015
ID: 1801
Name: Teddy
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Walmart at se 14st
Des Moines - West
Lost: 11/2/2015
ID:
Name:
Type: Dog
Color: Tan
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 11/1/2015
ID: 1995
Name: Jinku
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He is an inside/outside cat, very loving to everyone.
Pella
Lost: 11/1/2015
ID: 1888
Name: Pumpkin Cutie
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He normally responds to Pumpkin and snapping. He was last seen around Liberty St.
Des Moines - East
Lost: 11/1/2015
ID: 1791
Name: lola
Type: Dog
Color: blue
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
She was let outside and the gate was open. My kids love her and will be devastated. Please help get her home.
Des Moines - North
Lost: 11/1/2015
ID: 1790
Name: cooper
Type: Dog
Color: blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
last seen at home on merceed street,off of 56ths st near merle hay road. behind the strip mall big lots is located in.
Portsmouth
Lost: 10/31/2015
ID: 1883
Name: Buddy
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen rural Portsmouth 1100 and Elmwood Rds. Usually with smaller brown lab named Bear. We found bear safe and sound, but cannot find Buddy. Very friendly dog.
Marshalltown
Lost: 10/31/2015
ID: 1783
Name: Ittty Bitty
Type: Dog
Color: Brown with white chest and white on paws, 60 lbs but thin looking, Pit Bull mix
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Marshalltown Iowa Country Club Area.Had leash and collar on. Vet tags on collar.n
Des Moines - North
Lost: 10/30/2015
ID: 2129
Name: Stella
Type: Cat
Color: Tabby and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 10/30/2015
ID: 1826
Name: Stella
Type: Cat
Color: Tabby/white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult