Kerala Holiday Packages

Land - Plot For Sale - Kottayam Classifieds

Residencial  land for sale  offer Land - Plot For Sale

Residencial land for sale

Land - Plot For Sale

82 cent residencial land for sale in vakathanam,njaliyakuzhi.serious buyers contact.1.5 lakh per cent....

Reply
Land with small building offer Land - Plot For Sale

Land with small building

INR45Land - Plot For Sale

12 cent land and a small house near Kaduthuruthy jn in Kottayam dt. Residential area. Compound wall,well,electricity, tar road front. 100 mtrs from state highway. Resurvey completed. ...

Reply
5 cent plot for sale offer Land - Plot For Sale

5 cent plot for sale

INR550000Land - Plot For Sale

5 cnt plotfor immediate sale in kottayam ...

Reply
Land with Rubber Plantation for Sale offer Land - Plot For Sale

Land with Rubber Plantation for Sale

Land - Plot For Sale

2,3 Acre Land with rubber plantation to sell. Location: Changanacherry, Mammoodu(Palamattom/Rajamattom). Rubber Plantation is around 10 years old and now reaping. Plot is good for Home construction to...

Reply
villa plot for 2,00,000 per cent-15 cent Near Mammood, Changanacherry offer Land - Plot For Sale

villa plot for 2,00,000 per cent-15 cent Near Mammood, Changanacherry

INR200000Land - Plot For Sale

Villa House plots near Mammood Changanacherry Plot location Known as Chennamattom & located in 400 mtr from Mammood Venkotta road , 700 mtr from Mammood junction towards to Thiruvalla route. 8 km from...

Reply
villa plot for 1,40,000 per cent-23 cent Near Mammood,Changanacherry offer Land - Plot For Sale

villa plot for 1,40,000 per cent-23 cent Near Mammood,Changanacherry

Land - Plot For Sale

Villa House plots near Mammood Changanacherry Plot location Known as Chennamattom & located in 200 mtr from Mammood Venkotta road , 500 mtr from Mammood junction towards to Thiruvalla route. 8 km from...

Reply
Villa plot for Rs 2,50,000 / cent Main Road at Venkotta, 19 Cents offer Land - Plot For Sale

Villa plot for Rs 2,50,000 / cent Main Road at Venkotta, 19 Cents

INR250000Land - Plot For Sale

The plot is at Venkotta Inbetween Old Hospital Junction & Reethupally. Total 19 cent. Looking for 1 Individual party. We cant divide the plot. Clam & Quiet Residential Area. The plot situated 1.8 km f...

Reply
Villa Plot-Rs2,50,000at Chanjody,NearChurch,Thrikoditanam offer Land - Plot For Sale

Villa Plot-Rs2,50,000at Chanjody,NearChurch,Thrikoditanam

INR250000Land - Plot For Sale

I am planning to sell House plots. it is 7 km away from Changanacherry. Location is Chnajody. Schools & Church is close to the plot. Infront of the plot 12 feet wide concrete road. Plot is just behind...

Reply
villa plot for 190000 per cent-9 cent Near Mammood,Changanacherry offer Land - Plot For Sale

villa plot for 190000 per cent-9 cent Near Mammood,Changanacherry

INR190000Land - Plot For Sale

It is a rectangular shape residential plot with front width nearly 40 feet & length around 100 feet . Suitable for independet villa the area is like a residential layout . Electric post is close to th...

Reply
Plot for Sale at Kottayam offer Land - Plot For Sale

Plot for Sale at Kottayam

Land - Plot For Sale

7 cents of residential land for sale at Kottayam near Medical collage Babuchazhikkadan road, the last is just walkable distance to all the daily needed items.interest parties pls call me or mail mejos...

Reply
Land for sale 35 cents offer Land - Plot For Sale

Land for sale 35 cents

INR686605Land - Plot For Sale

In meenachil taluk near kannadiyurumbu school 35 cents land with front tar road for sale.cent 135000 rs per cent for sale...

Reply
SALAVE OF HOUSING PLOT offer Land - Plot For Sale

SALAVE OF HOUSING PLOT

INR150000Land - Plot For Sale

Land with small house for sale. The volume of land is about 16.2 Cent with all required aminities like electricity, water, coconut trees. Lorry access road is also there. The property is situated...

Reply

  1. 0.00281s - Function query: select idLocation,idLocationParent,name from oc_locations where lower(friendlyName)='kottayam' Limit 1
  2. 0.0032s - End function query
  3. 0.00326s - Function query: select idCategoryParent,description,name,idCategory,keyword,citydesc,citykeyword from oc_categories where friendlyName='land-plot-for-sale' Limit 1
  4. 0.00355s - End function query
  5. 0.00358s - Function query: select friendlyName,name,description,keyword from oc_categories where idCategory=51 Limit 1
  6. 0.00377s - End function query
  7. 0.00384s - Function getRows assoc
  8. 0.00386s - Function query: select l.idLocation from oc_locations l where l.idLocationParent=36
  9. 0.00638s - End function query
  10. 0.00699s - Function getRows value
  11. 0.00702s - Function query: SELECT count(p.idPost) total FROM oc_posts p inner join oc_categories c on c.idCategory=p.idCategory where p.isAvailable=1 and p.isConfirmed=1 and c.idCategory=54 and ( p.idLocation=36 )
  12. 0.03665s - End function query
  13. 0.03677s - Function getRows assoc
  14. 0.0368s - Function query: SELECT p.idPost,p.title,p.description,p.insertDate, c.Name category,c.friendlyName fcategory,c.idCategoryParent,p.type,p.price,p.password,p.hasImages, (select friendlyName from oc_categories where idCategory=c.idCategoryParent limit 1) parent FROM oc_posts p inner join oc_categories c on c.idCategory=p.idCategory where p.isAvailable=1 and p.isConfirmed=1 and c.idCategory=54 and ( p.idLocation=36 ) order by p.insertDate Desc LIMIT 0, 12
  15. 0.07058s - End function query
  16. 0.07114s - Function getRows value
  17. 0.07116s - Function query: select name from oc_locations where idLocation=36 Limit 1
  18. 0.07142s - End function query
  19. 0.07144s - Function getRows value
  20. 0.07145s - Function query: select name from oc_locations where idLocation=36 Limit 1
  21. 0.07159s - End function query
  22. 0.07161s - Function getRows value
  23. 0.07162s - Function query: select name from oc_locations where idLocation=36 Limit 1
  24. 0.07175s - End function query
  25. 0.07244s - Function getRows value
  26. 0.07245s - Function query: select name from oc_locations where idLocation=36 Limit 1
  27. 0.07259s - End function query
  28. 0.07278s - Function getRows value
  29. 0.07279s - Function query: select name from oc_locations where idLocation=36 Limit 1
  30. 0.07291s - End function query
  31. 0.07302s - Function getRows value
  32. 0.07303s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  33. 0.07315s - End function query
  34. 0.07349s - Function getRows value
  35. 0.0735s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  36. 0.07363s - End function query
  37. 0.07378s - Function getRows value
  38. 0.07379s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  39. 0.07392s - End function query
  40. 0.0741s - Function query: SELECT idLocation,name FROM oc_locations WHERE idLocationParent='0' order by idLocationParent,trim(name)
  41. 0.07651s - End function query
  42. 0.07708s - Function getRows value
  43. 0.07709s - Function query: select idLocationParent from oc_locations where idLocation=36 Limit 1
  44. 0.07726s - End function query
  45. 0.0773s - Function getRows value
  46. 0.0773s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  47. 0.07743s - End function query
  48. 0.07749s - Function getRows assoc
  49. 0.0775s - Function query: SELECT name,friendlyName,idCategory from oc_categories where idCategoryParent=0 order by `order`
  50. 0.07778s - End function query
  51. 0.07781s - Function getRows value
  52. 0.07781s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  53. 0.07794s - End function query
  54. 0.07798s - Function getRows value
  55. 0.07798s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  56. 0.0781s - End function query
  57. 0.07814s - Function getRows value
  58. 0.07815s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  59. 0.07826s - End function query
  60. 0.07831s - Function getRows value
  61. 0.07832s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  62. 0.07848s - End function query
  63. 0.07861s - Function getRows value
  64. 0.07864s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  65. 0.07877s - End function query
  66. 0.07881s - Function getRows value
  67. 0.07882s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  68. 0.07894s - End function query
  69. 0.07897s - Function getRows value
  70. 0.07898s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  71. 0.07909s - End function query
  72. 0.07913s - Function getRows value
  73. 0.07914s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  74. 0.07924s - End function query
  75. 0.07929s - Function getRows value
  76. 0.0793s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  77. 0.07943s - End function query
  78. 0.07946s - Function getRows value
  79. 0.07947s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  80. 0.07959s - End function query
  81. 0.07984s - Function getRows value
  82. 0.07985s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  83. 0.07997s - End function query
  84. 0.08001s - Function getRows value
  85. 0.08001s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  86. 0.08012s - End function query
  87. 0.08018s - Function getRows value
  88. 0.08019s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  89. 0.0803s - End function query
  90. 0.08033s - Function getRows value
  91. 0.08034s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  92. 0.08045s - End function query
  93. 0.08048s - Function getRows value
  94. 0.08049s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  95. 0.0806s - End function query
  96. 0.08069s - Function getRows value
  97. 0.08069s - Function query: select name from oc_locations where idLocation=36 Limit 1
  98. 0.08081s - End function query
  99. 0.08107s - Function getRows value
  100. 0.08108s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  101. 0.08119s - End function query
  102. 0.0814s - Function getRows value
  103. 0.08141s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  104. 0.08153s - End function query
  105. 0.08181s - Function getRows value
  106. 0.08182s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  107. 0.08193s - End function query
  108. 0.08214s - Function getRows value
  109. 0.08214s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  110. 0.08225s - End function query
  111. 0.08259s - Function getRows value
  112. 0.0826s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  113. 0.08271s - End function query
  114. 0.08301s - Function getRows value
  115. 0.08302s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  116. 0.08313s - End function query
  117. 0.08344s - Function getRows value
  118. 0.08345s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  119. 0.08357s - End function query
  120. 0.08386s - Function getRows value
  121. 0.08387s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  122. 0.08399s - End function query
  123. 0.08427s - Function getRows value
  124. 0.08431s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  125. 0.08445s - End function query
  126. 0.09132s - Function getRows value
  127. 0.09134s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  128. 0.09149s - End function query
  129. 0.09178s - Function getRows value
  130. 0.09179s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  131. 0.0919s - End function query
  132. 0.09217s - Function getRows value
  133. 0.09218s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  134. 0.0923s - End function query
  135. 0.09238s - Function getRows value
  136. 0.09239s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  137. 0.09251s - End function query
  138. 0.09272s - Function getRows value
  139. 0.09274s - Function query: select name from oc_locations where idLocation=36 Limit 1
  140. 0.09287s - End function query
  141. 0.0929s - Function getRows value
  142. 0.09291s - Function query: select idLocationParent from oc_locations where idLocation=36 Limit 1
  143. 0.09302s - End function query
  144. 0.09308s - Function getRows value
  145. 0.09308s - Function query: select name from oc_locations where idLocation=36 Limit 1
  146. 0.0932s - End function query
  147. 0.09322s - Function getRows assoc
  148. 0.09323s - Function query: select idLocation, name, friendlyName, isinternational from oc_locations where idLocationParent=36 order by name
  149. 0.09623s - End function query
  150. 0.09923s - Function getRows assoc
  151. 0.09924s - Function query: SELECT bcat.idCategory,bcat.name,bcat.friendlyName,acat.name as parent,acat.friendlyName as parentfriendlyName from oc_categories as acat,oc_categories as bcat where acat.friendlyName ='real-estate' and acat.idCategoryParent=0 and bcat.idCategoryParent=acat.idCategory order by bcat.order
  152. 0.09976s - End function query
  153. 0.09987s - Function getRows value
  154. 0.09988s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  155. 0.10001s - End function query
  156. 0.10005s - Function getRows value
  157. 0.10006s - Function query: select friendlyName from oc_locations where idLocation=36 Limit 1
  158. 0.10018s - End function query
  159. 0.10148s - Function closeDB: 55 queries generated in 0.10147s