SELECT scity.city_name,sl.locality_name,sc.cat_name,ss.sec_name,p.short_description,p.full_description,p.id,DATE_FORMAT(p.created_date,'%a ,%M %e, %Y %H:%i:%s')as created_date FROM sargam_properties p, sargam_sections ss,sargam_categories sc,sargam_cities scity,sargam_localities sl WHERE sl.locality_id=34 and sl.locality_id=p.locality_id and p.city_id=scity.city_id and scity.city_id=p.city_id and sc.cat_id=p.cat_id and ss.sec_id=sc.sec_id and ss.sec_id=p.sec_id and p.status=1 order by p.created_date desc limit 10 Sargam Estate http://www.sargamestate.com/ FeedCreator 1.7.2 gifs/sargam-estate.png Sargam Estate http://sargamestate.com/story.php?propertyId=1491 Property is towards Roorkee 700 mtr in from NH-58, Near Monford Public School, Ramashri Garden Extension, plot is 33.6 X 53.6 call for detail at 9818838000 Wed ,April 28, 2010 22:59:46 GMT http://sargamestate.com/story.php?propertyId=1452 284 Sq ft SHOP on RENT @ Rs 9000 per month (negotiable) in Jwalapur, HARIDWAR Location : Main Market, Jwalapur, Haridwar Contact Mr Saxena 01334 233508 09997068461 Tue ,February 23, 2010 00:10:03 GMT http://sargamestate.com/story.php?propertyId=1441 2 Plots for Sale in Ravi Vihar, Bahar Sima Nagar Palika, Jwalapur for 510/--520/- per Sqft. Thu ,January 28, 2010 22:12:54 GMT http://sargamestate.com/story.php?propertyId=1440 2 Plots for Sale in Jwalapur Behind Meda Mill for 600/- per Sqft. Thu ,January 28, 2010 21:55:05 GMT http://sargamestate.com/story.php?propertyId=1439 4 Plots for Sale behind Meda Mill for 600/- per Sqft. Thu ,January 28, 2010 21:41:45 GMT http://sargamestate.com/story.php?propertyId=1438 2 Plots for Sale in Madhu Vihar for 600/- per Sqft. Thu ,January 28, 2010 21:16:01 GMT http://sargamestate.com/story.php?propertyId=1437 2 Plots for Sale in Madhu Vihar for 9Lacs. 600/- per Sqft. Thu ,January 28, 2010 21:00:06 GMT http://sargamestate.com/story.php?propertyId=1379 Agriculture land for Sale 20Lacs per bigha in Jwalapur. Tue ,January 26, 2010 16:56:22 GMT http://sargamestate.com/story.php?propertyId=1377 Agriculture Land for Sale 20Lacs per bigha in Jwalapur. Mon ,January 25, 2010 16:37:55 GMT http://sargamestate.com/story.php?propertyId=1376 Agriculture Land for Sale 20Lacs per bigha in Jwalapur. Mon ,January 25, 2010 16:27:56 GMT