{"iTotalDisplayRecords":"11","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `bd_project_id`, `bd_project_name`, `bd_project_location`, `bd_project_start_date`, `bd_project_gfs_month`, `bd_project_launch_date`, `bd_project_development_time`, `bd_project_sales_time`, `bd_project_file_path`, `bd_project_fund_source`, `bd_project_status`, `bd_project_added_by`, `bd_project_added_on`, `bd_project_added_user_name`, `bd_fund_source_name`, `bd_fund_source_active`, `display_order`, `project_district`, `bd_project_type`, `project_type_name`, `bd_district_name`, `plan_approval_date`, `planning_authority`, `planning_authority_name`\r\n    FROM bd_projects\r\n     WHERE `bd_project_type` = '3'\r\n    ORDER BY display_order ASC\r\n    \r\n    ","aaData":[{"bd_project_id":"165588957558703200","bd_project_name":"SHYAM RESIDENCY","bd_project_location":"Yeshwanthpur","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2023-02-01","bd_project_development_time":"6","bd_project_sales_time":"0","bd_project_file_path":"documents\/bd\/plan\/202308021690948923.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161457624467680800","bd_project_added_on":"2022-10-28 12:38:39","bd_project_added_user_name":"GOWTHAM.V","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"1","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2022-11-28","planning_authority":"1","planning_authority_name":"BDA","documentsCount":3,"landCost_1":"0.00","paidAmount_1":"0","pendingAmount_1":0,"landCost":"0","paidAmount":"0","pendingAmount":"0","expected_site_cost":0,"stamp_duty":0,"development_cost":0,"sales_marketing_cost":0,"finance_rate":0,"salable_area_manual":0,"liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"164300688024334600","bd_project_name":"KNS ANANTA PHASE 1","bd_project_location":"Maragondanahalli Krishnasagara","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2023-09-24","bd_project_development_time":"12","bd_project_sales_time":"36","bd_project_file_path":"documents\/bd\/plan\/202304061680766116.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2022-01-24 12:18:00","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"2","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2023-01-24","planning_authority":"1","planning_authority_name":"BDA","documentsCount":3,"landCost_1":"157812500.00","paidAmount_1":"0","pendingAmount_1":157812500,"landCost":"15,78,12,500","paidAmount":"0","pendingAmount":"15,78,12,500","expected_site_cost":"4000.00","stamp_duty":"94580000","development_cost":"771500000","sales_marketing_cost":"471600000","finance_rate":"0","salable_area_manual":"1179220","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"164760462022804800","bd_project_name":"KNS AROHA","bd_project_location":"Puradpalya","bd_project_start_date":"2022-02-18","bd_project_gfs_month":"2022-03-01","bd_project_launch_date":"2022-03-01","bd_project_development_time":"20","bd_project_sales_time":"23","bd_project_file_path":"documents\/bd\/plan\/202205181652857444.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2022-03-18 17:27:00","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"3","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"0000-00-00","planning_authority":"0","planning_authority_name":null,"documentsCount":0,"landCost_1":"12339858.00","paidAmount_1":"0","pendingAmount_1":12339858,"landCost":"1,23,39,858","paidAmount":"0","pendingAmount":"1,23,39,858","expected_site_cost":0,"stamp_duty":0,"development_cost":0,"sales_marketing_cost":0,"finance_rate":0,"salable_area_manual":0,"liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"166969874113437300","bd_project_name":"KNS ANANTA PHASE 2","bd_project_location":"Maragondanahalli Krishnasagara","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2023-12-30","bd_project_development_time":"12","bd_project_sales_time":"24","bd_project_file_path":"documents\/bd\/plan\/202306061686033221.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2022-11-29 10:42:21","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"3","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2023-05-29","planning_authority":"1","planning_authority_name":"BDA","documentsCount":3,"landCost_1":"77750000.00","paidAmount_1":"0","pendingAmount_1":77750000,"landCost":"7,77,50,000","paidAmount":"0","pendingAmount":"7,77,50,000","expected_site_cost":0,"stamp_duty":0,"development_cost":0,"sales_marketing_cost":0,"finance_rate":0,"salable_area_manual":0,"liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"156983724615375800","bd_project_name":"KNS ATHENA PHASE 2","bd_project_location":"Mathahalli, Dasanapura","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2020-08-01","bd_project_development_time":"10","bd_project_sales_time":"24","bd_project_file_path":"documents\/bd\/plan\/202307031688370633.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"15662874817808100","bd_project_added_on":"2019-09-30 15:24:06","bd_project_added_user_name":"SUHAS.C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"4","project_district":"2","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":"Bengalur North","plan_approval_date":"0000-00-00","planning_authority":"1","planning_authority_name":"BDA","documentsCount":2,"landCost_1":"0.00","paidAmount_1":"0","pendingAmount_1":0,"landCost":"0","paidAmount":"0","pendingAmount":"0","expected_site_cost":"2250.00","stamp_duty":"31491135","development_cost":"139500000","sales_marketing_cost":"48000000","finance_rate":"0","salable_area_manual":"213202","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"159142936018210900","bd_project_name":"KNS LAUREL PHASE A","bd_project_location":"MUGULURU","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2021-07-15","bd_project_development_time":"12","bd_project_sales_time":"24","bd_project_file_path":"documents\/bd\/plan\/202112111639227391.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"15662874817808100","bd_project_added_on":"2020-06-06 13:12:40","bd_project_added_user_name":"SUHAS.C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"4","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2021-06-15","planning_authority":"4","planning_authority_name":"BMRDA","documentsCount":5,"landCost_1":"14000000.00","paidAmount_1":"0","pendingAmount_1":14000000,"landCost":"1,40,00,000","paidAmount":"0","pendingAmount":"1,40,00,000","expected_site_cost":"2500.00","stamp_duty":"17668675","development_cost":"52400000","sales_marketing_cost":"37400000","finance_rate":"0","salable_area_manual":"149849","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"164429890559104900","bd_project_name":"KNS ATHARVA","bd_project_location":"Doddacheemanahalli, Kundana Hobli, Devanahalli ","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2022-11-08","bd_project_development_time":"12","bd_project_sales_time":"36","bd_project_file_path":"documents\/bd\/plan\/202205171652788830.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2022-02-08 11:11:45","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"5","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2022-02-08","planning_authority":"3","planning_authority_name":"BIAAPA","documentsCount":2,"landCost_1":"0.00","paidAmount_1":"0","pendingAmount_1":0,"landCost":"0","paidAmount":"0","pendingAmount":"0","expected_site_cost":"3000.00","stamp_duty":"10610600","development_cost":"40800000","sales_marketing_cost":"18700000","finance_rate":"0","salable_area_manual":"62340","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"162141888598576300","bd_project_name":"KNS CALISTO PHASE 2","bd_project_location":"MYSURU","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2021-09-15","bd_project_development_time":"6","bd_project_sales_time":"24","bd_project_file_path":"documents\/bd\/plan\/202208241661315896.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2021-05-19 15:38:05","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"6","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2021-07-25","planning_authority":"5","planning_authority_name":"MUDA","documentsCount":2,"landCost_1":"70280000.00","paidAmount_1":"0","pendingAmount_1":70280000,"landCost":"7,02,80,000","paidAmount":"0","pendingAmount":"7,02,80,000","expected_site_cost":"4000.00","stamp_duty":"23089480","development_cost":"75400000","sales_marketing_cost":"46200000","finance_rate":"0","salable_area_manual":"115329","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"162159059950511400","bd_project_name":"KNS LAUREL PHASE B","bd_project_location":"KUTHAGANAHALLI","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2021-09-15","bd_project_development_time":"6","bd_project_sales_time":"12","bd_project_file_path":"documents\/bd\/plan\/202301231674449367.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2021-05-21 15:19:59","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"7","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2021-08-15","planning_authority":"4","planning_authority_name":"BMRDA","documentsCount":3,"landCost_1":"0.00","paidAmount_1":"0","pendingAmount_1":0,"landCost":"0","paidAmount":"0","pendingAmount":"0","expected_site_cost":"2500.00","stamp_duty":"19312250","development_cost":"81400000","sales_marketing_cost":"31200000","finance_rate":"0","salable_area_manual":"124430","liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"163920319862125500","bd_project_name":"KNS CALISTO ","bd_project_location":"KERAGALLI, MYSURU ","bd_project_start_date":"2021-12-11","bd_project_gfs_month":"2022-01-25","bd_project_launch_date":"2022-01-26","bd_project_development_time":"8","bd_project_sales_time":"36","bd_project_file_path":"documents\/bd\/plan\/202112111639203198.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"161443082645090600","bd_project_added_on":"2021-12-11 11:43:18","bd_project_added_user_name":"SUHAS C","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"7","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"0000-00-00","planning_authority":"0","planning_authority_name":null,"documentsCount":1,"landCost_1":"150000000.00","paidAmount_1":"0","pendingAmount_1":150000000,"landCost":"15,00,00,000","paidAmount":"0","pendingAmount":"15,00,00,000","expected_site_cost":0,"stamp_duty":0,"development_cost":0,"sales_marketing_cost":0,"finance_rate":0,"salable_area_manual":0,"liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0},{"bd_project_id":"158995230383948300","bd_project_name":"VIJAYANAGARA BUILDING","bd_project_location":"VIJAYANAGARA","bd_project_start_date":"0000-00-00","bd_project_gfs_month":"0000-00-00","bd_project_launch_date":"2020-09-30","bd_project_development_time":"24","bd_project_sales_time":"10","bd_project_file_path":"documents\/bd\/plan\/202303081678253948.","bd_project_fund_source":"1","bd_project_status":"1","bd_project_added_by":"143620071466608200","bd_project_added_on":"2020-05-20 10:55:03","bd_project_added_user_name":"NANJEGOWDA","bd_fund_source_name":"OWN","bd_fund_source_active":"1","display_order":"38","project_district":"0","bd_project_type":"3","project_type_name":"Ongoing","bd_district_name":null,"plan_approval_date":"2020-07-31","planning_authority":"1","planning_authority_name":"BDA","documentsCount":0,"landCost_1":"1.00","paidAmount_1":"0","pendingAmount_1":1,"landCost":"1","paidAmount":"0","pendingAmount":"1","expected_site_cost":0,"stamp_duty":0,"development_cost":0,"sales_marketing_cost":0,"finance_rate":0,"salable_area_manual":0,"liaisonCost":0,"actualSalesMarketingCost":0,"actualDevelopmentCost":0}]}