AMS - VB

INSERT INTO BUD_CONTRACT_RENT (BUDC_RENT_ID, BUDC_RENT_CODE, BUDC_RENT_NAME, BUDC_RENT_TYPE, BUDC_RENT_STATUS, BRANCH_ID, DEP_ID, TOTAL_AMT, ADJUST_PRICE_RATE, DONE_AMT, DEPOSIT_AMT, TOTAL_SER_AMT, TOTAL_PAY_AMT, TOTAL_REMAIN_AMT, VAT, PRICE_VAT, SENDMAIL_MONTH_PAY, TYPE_PERIOD, DEPOSIT_NOTE, PERIOD_ADJUST, SIGN_DT, START_DT, END_DT, NEXT_DT, SEND_APPR_DT, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, AUTH_STATUS_DC, CHECKER_ID, APPROVE_DT, IS_CLOSED, IS_SEND_APPR, IS_SENDMAIL_PAY, BUILDING_ID, ADJUST_CONDITION, BRANCH_RENT_ID, DEP_RENT_ID, FREE_FIX_TIME, START_PAYMENT_DT, KEEP_PRICE_TIME, CTSC_UNIT, PRICE_NEWUP, START_DT_NEWUP, END_DT_NEWUP, NEXT_DT_NEWUP, LAST_UPD_DT, LAST_UPD_BY, CUR_PERIOD, CUR_PERIOD_VAL, RENT_TIME, LAST_MOVEMENT_DT, REFUND, REFUND_CONTENT, TOTAL_SQUARE, STRUCTURE_BUD, CUST_CODE, CUST_NAME, CUST_PHONE, CUST_FULLNAME, LICENCED_DT, OFFICIAL_DT, RATE_UNIT, ADJUST_PRICE_RANGE, VAT_MB, VAT_TNCN, COMPENSATION, TOTAL_FLOOR, IS_AUTO_ADJUST, RANGE_ADJUST, RANGE_CONTENT, DELIVERY_DT, ADJUST_NOTES, ADJUST_SQUARE) VALUES

('BCR000000000012', N'2203.HĐ TVP/2022 ngày 24/3/2022', N'CÔNG TY CP ĐẦU TƯ HOÀN KIẾM', 'CT', NULL, NULL, NULL, 18000000, 0, NULL, 54000000, 0, 18000000, 18000000, 5, 1636364, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2022-03-24 00:00:00.000', 121), CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-04-30 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, 'MB011', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000013', N'HĐ 2205.HĐ TVP/2022 ngày 10/5/2022', N'TỔ CHỨC SAVE THE CHILDREN INTENATIONAL', 'CT', NULL, NULL, NULL, 120020000, 0, NULL, 360060000, 0, 120020000, 120020000, 5, 10910909, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2022-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-05-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB012', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000014', N'2206.HĐ TVP/2022 ngày 18/6/2022', N'CÔNG TY BẢO HIỂM VIETTINBANK THĂNG LONG', 'CT', NULL, NULL, NULL, 123550000, 0, NULL, 370650000, 0, 123550000, 123550000, 5, 11231818, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2022-06-18 00:00:00.000', 121), CONVERT(DATETIME, '2022-07-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-06-30 00:00:00.000', 121), NULL, NULL, N'Tính tiền thuê từ 01/08/2022', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-07-01 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB013', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-07-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000015', N'HĐ 2207.HĐ TVP/2022 ngày 8/7/2022', N'CÔNG TY CỔ PHẦN CHỨNG KHOÁN KIS', 'CT', NULL, NULL, NULL, 67260000, 0, NULL, 201780000, 0, 67260000, 67260000, 5, 6114545, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2022-07-08 00:00:00.000', 121), CONVERT(DATETIME, '2022-07-08 00:00:00.000', 121), CONVERT(DATETIME, '2025-07-07 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-07-08 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36, NULL, NULL, NULL, NULL, NULL, 'MB014', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-07-08 00:00:00.000', 121), NULL, NULL),

('BCR000000000016', N'2302/HĐTVP/2023 ngày 15/04/2023', N'CÔNG TY TNHH KKDAY VIETNAM', 'CT', NULL, NULL, NULL, 70400000, 0, NULL, 140800000, 0, 70400000, 70400000, 5, 6400000, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2023-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2023-05-04 00:00:00.000', 121), CONVERT(DATETIME, '2026-05-03 00:00:00.000', 121), NULL, NULL, N'Miễn phí sửa chữa 1 tháng: 04/5-> 03/06/2023', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 1, CONVERT(DATETIME, '2023-06-04 00:00:00.000', 121), 24, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36, NULL, NULL, NULL, NULL, NULL, 'MB015', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2023-05-04 00:00:00.000', 121), NULL, NULL),

('BCR000000000017', N'2301/HĐTVP/2023 ngày 05/04/2023', N'CÔNG TY TNHH EVENUE TO SUCCESS', 'CT', NULL, NULL, NULL, 70800000, 0, NULL, 141600000, 0, 70800000, 70800000, 5, 6436364, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2026-05-09 00:00:00.000', 121), NULL, NULL, N'Miễn phí sửa chữa 1 tháng: 10/5-> 09/06/2023', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 1, CONVERT(DATETIME, '2023-06-10 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36, NULL, NULL, NULL, NULL, NULL, 'MB016', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2023-05-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000018', N'08/HĐTN.2022/VB-AS', N'CÔNG TY CỔ PHẦN QUẢNG CÁO GOCLICK', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-05-01 00:00:00.000', 121), 70, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 69, NULL, NULL, NULL, NULL, NULL, 'MN001', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000019', N'07/HĐTN.2022/VB-AS', N'CÔNG TY TNHH ĐẦU TƯ XÂY DỰNG 3B', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-05-01 00:00:00.000', 121), 70, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 69, NULL, NULL, NULL, NULL, NULL, 'MN002', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000020', N'06/HĐTN.2022/VB-AS', N'CÔNG TY TNHH AS VIỆT NAM', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-05-01 00:00:00.000', 121), 70, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 69, NULL, NULL, NULL, NULL, NULL, 'MN003', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000021', N'09/HĐTN.2022/VB-AS', N'CÔNG TY TNHH DƯỢC PHẨM HOA LÂM', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-05-01 00:00:00.000', 121), 70, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 69, NULL, NULL, NULL, NULL, NULL, 'MN004', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000022', N'11/HĐTN.2022/VB-FT', N'CN3 CÔNG TY CP ĐẦU TƯ PHÁT TRIỂN HOA LÂM', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), 69, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 68, NULL, NULL, NULL, NULL, NULL, 'MN005', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000023', N'10/HĐTN.2022/VB-FT', N'CÔNG TY TNHH BẤT ĐỘNG SẢN FIRST HOME', 'CT', NULL, NULL, NULL, 1375000, 0, NULL, 0, 0, 1375000, 1375000, 5, 125000, 0, '3T', N'', N'0', CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 2, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), 69, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 68, NULL, NULL, NULL, NULL, NULL, 'MN006', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-04-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000043', N'01/2019/HĐTN.HĐ ngày 31/05/2019 (SH20) và 02/2019/HĐTN.HĐ ngày 31/05/2019 (SH16+SH19)', N'Hà Đông ', 'DT', NULL, NULL, NULL, 101196060, NULL, NULL, 297000000, 2196060, 90000000, 99000000, 5, 9000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2019-05-30 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-06-01 00:00:00.000', 121), NULL, NULL, N'Từ năm 4 mỗi 3 năm tăng/giảm 10% so với năm liền kề trước đó', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.987', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000049', NULL, 36, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000044', N'0111/2017/HĐTVP/HT-VNTT ngày 01/11/2017', N'CN  Hải Phòng ', 'DT', NULL, NULL, NULL, 85658000, NULL, NULL, 256974000, 0, 77870909, 85658000, 5, 7787091, 9, '3', N'', N'0', CONVERT(DATETIME, '2017-01-11 00:00:00.000', 121), CONVERT(DATETIME, '2018-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-12-31 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.990', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000059', NULL, 24, CONVERT(DATETIME, '2020-01-01 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2018-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000045', N'177/17.VK/62.NQ quyển số 01.TP/CC-SCC/VK/150.17 ngày 24/05/2017', N'Bạch Đằng', 'DT', NULL, NULL, NULL, 56000000, NULL, NULL, 168000000, 0, 50909091, 56000000, 5, 5090909, 9, '6', N'', N'0', CONVERT(DATETIME, '2017-05-24 00:00:00.000', 121), CONVERT(DATETIME, '2017-06-24 00:00:00.000', 121), CONVERT(DATETIME, '2025-05-23 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.990', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000061', NULL, 36, CONVERT(DATETIME, '2020-06-24 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 95, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2017-06-24 00:00:00.000', 121), NULL, NULL),

('BCR000000000046', N'14/2017/HĐKT-ARTEXPORT.HP ngày 27/3/2017', N'Ngô Quyền ', 'DT', NULL, NULL, NULL, 55000000, NULL, NULL, 165000000, 0, 50000000, 55000000, 5, 5000000, 9, '1', N'', N'0', CONVERT(DATETIME, '2017-03-27 00:00:00.000', 121), CONVERT(DATETIME, '2017-03-27 00:00:00.000', 121), CONVERT(DATETIME, '2025-03-26 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.990', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000062', NULL, 36, CONVERT(DATETIME, '2020-03-27 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Cố định', CONVERT(DATETIME, '2017-03-27 00:00:00.000', 121), NULL, NULL),

('BCR000000000047', N'nhà 309 số HĐ: 01/16/HĐTN.HP ngày 08/09/2016 và nhà 311 số HĐ: 02/16/HĐTN.HP ngày 08/09/2016', N'Lê Hồng Phong (Lạch Tray cũ)', 'DT', NULL, NULL, NULL, 115500000, NULL, NULL, 330000000, 0, 105000000, 115500000, 5, 10500000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-08-24 00:00:00.000', 121), CONVERT(DATETIME, '2018-10-24 00:00:00.000', 121), CONVERT(DATETIME, '2030-08-23 00:00:00.000', 121), NULL, NULL, N'Từ 01/01/2025 mỗi 2 năm tăng 5tr', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.990', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000063', NULL, 24, CONVERT(DATETIME, '2020-10-24 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 142, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5tr', CONVERT(DATETIME, '2018-10-24 00:00:00.000', 121), NULL, NULL),

('BCR000000000048', N'nhà 309 số HĐ: 01/16/HĐTN.HP ngày 08/09/2016 và nhà 311 số HĐ: 02/16/HĐTN.HP ngày 08/09/2016', N'Lê Chân ', 'DT', NULL, NULL, NULL, 61710000, NULL, NULL, 60000000, 0, 56100000, 61710000, 5, 5610000, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-09-08 00:00:00.000', 121), CONVERT(DATETIME, '2016-10-10 00:00:00.000', 121), CONVERT(DATETIME, '2026-10-09 00:00:00.000', 121), NULL, NULL, N'Từ 10/10/2023-09/10/2026 giá thuê là 76tr', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.993', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000064', NULL, 24, CONVERT(DATETIME, '2018-10-10 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2016-10-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000049', N'398/2018/HĐTN.VBNA ngày 30/09/2018', N'CN Nghệ An', 'DT', NULL, NULL, NULL, 344814801, NULL, NULL, 0, 105225801, 217808182, 239589000, 5, 21780818, 9, '12', N'', N'0', CONVERT(DATETIME, '2018-09-30 00:00:00.000', 121), CONVERT(DATETIME, '2019-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2028-12-31 00:00:00.000', 121), NULL, NULL, N'Từ năm thứ 4 mỗi 2 năm tăng giảm 10% so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.993', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000061', NULL, 36, CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), 86, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2019-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000050', N'01/2020/HĐTN ngày 02/11/2020', N'Nguyễn Du', 'DT', NULL, NULL, NULL, 70325750, NULL, NULL, 208650000, 775750, 63227273, 69550000, 5, 6322727, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-11-02 00:00:00.000', 121), CONVERT(DATETIME, '2020-11-02 00:00:00.000', 121), CONVERT(DATETIME, '2025-11-02 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.993', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000062', NULL, 60, CONVERT(DATETIME, '2025-11-02 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Cố định', CONVERT(DATETIME, '2020-11-02 00:00:00.000', 121), NULL, NULL),

('BCR000000000051', N'01/2019/HĐTN.NSS ngày 09/09/2019', N'Lê Nin ', 'DT', NULL, NULL, NULL, 61435000, NULL, NULL, 162660000, 1793000, 54220000, 59642000, 5, 5422000, 9, '6', N'', N'0', CONVERT(DATETIME, '2019-09-09 00:00:00.000', 121), CONVERT(DATETIME, '2019-11-10 00:00:00.000', 121), CONVERT(DATETIME, '2029-11-09 00:00:00.000', 121), NULL, NULL, N'Từ năm 4 mỗi 3 năm tăng/giảm 10% so với năm liền kề trước đó', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.993', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000063', NULL, 36, CONVERT(DATETIME, '2022-11-10 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2019-11-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000052', N'2018/HĐTN.VBCV ngày 04/12/2008', N'Chợ Vinh ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 0, 0, 54545455, 60000000, 5, 5454545, 9, '6', N'', N'0', CONVERT(DATETIME, '2018-12-04 00:00:00.000', 121), CONVERT(DATETIME, '2019-02-04 00:00:00.000', 121), CONVERT(DATETIME, '2029-02-04 00:00:00.000', 121), NULL, NULL, N'Từ năm 4 mỗi 3 năm tăng/giảm 10% so với năm liền kề trước đó', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.997', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000064', NULL, 36, CONVERT(DATETIME, '2022-02-04 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2019-02-04 00:00:00.000', 121), NULL, NULL),

('BCR000000000064', N'HĐTN ngày 20/09/2010', N'Sơn Trà', 'DT', NULL, NULL, NULL, 27000000, NULL, NULL, 0, 0, 24545455, 27000000, 5, 2454545, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-09-20 00:00:00.000', 121), CONVERT(DATETIME, '2010-09-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-10-31 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 01 năm đầu. Mỗi năm tăng 1tr/đồng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.007', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000071', NULL, 60, CONVERT(DATETIME, '2015-09-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 181, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 1tr/đồng mỗi năm ', CONVERT(DATETIME, '2010-09-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000065', N'HĐTN ngày 26/11/2010', N'Cẩm Lệ', 'DT', NULL, NULL, NULL, 40000000, NULL, NULL, 0, 0, 36363636, 40000000, 5, 3636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-11-26 00:00:00.000', 121), CONVERT(DATETIME, '2010-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-12-31 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 02 năm đầu. 02 năm cuối 

tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.007', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000072', NULL, 24, CONVERT(DATETIME, '2012-01-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 215, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2010-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000066', N'02/10/HĐTN - Ngày 02/01/2010; PL.01/PLHĐ.HCM.19 - Ngày 19/10/2019', N'CN Khánh Hòa', 'DT', NULL, NULL, NULL, 88000000, NULL, NULL, 180000000, 0, 80000000, 88000000, 5, 8000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-01-21 00:00:00.000', 121), CONVERT(DATETIME, '2010-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-28 00:00:00.000', 121), NULL, NULL, N'năm đầu 80tr/tháng, năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.010', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000077', NULL, 12, CONVERT(DATETIME, '2011-03-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 167, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2010-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000067', N'HĐTN.VINHPHUOC.17 - Ngày 20/07/2017', N'Vĩnh Phước', 'DT', NULL, NULL, NULL, 29700000, NULL, NULL, 69000000, 0, 27000000, 29700000, 5, 2700000, 9, '3', N'', N'0', CONVERT(DATETIME, '2017-07-20 00:00:00.000', 121), CONVERT(DATETIME, '2017-08-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-07-31 00:00:00.000', 121), NULL, NULL, N'Mỗi 02 năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.010', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000078', NULL, 24, CONVERT(DATETIME, '2019-08-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2017-08-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000068', N'2019/HĐTN.KH - Ngày 31/01/2019', N'Ninh Hòa ', 'DT', NULL, NULL, NULL, 55000000, NULL, NULL, 150000000, 0, 50000000, 55000000, 5, 5000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2019-01-31 00:00:00.000', 121), CONVERT(DATETIME, '2019-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2029-04-14 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 04 năm đầu, mỗi 03 năm  tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.010', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000079', NULL, 48, CONVERT(DATETIME, '2023-04-15 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-04-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000069', N'02/2019/HĐTN.VN - Ngày 03/05/2019', N'Vạn Ninh ', 'DT', NULL, NULL, NULL, 22000000, NULL, NULL, 132000000, 0, 20000000, 22000000, 5, 2000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-05-03 00:00:00.000', 121), CONVERT(DATETIME, '2019-08-12 00:00:00.000', 121), CONVERT(DATETIME, '2026-08-12 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giữ cố định trong 05 năm đầu,

 02 năm còn lại điều chỉnh tăng/ giảm 10%.', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.010', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000080', NULL, 60, CONVERT(DATETIME, '2024-08-12 00:00:00.000', 121), 90, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-08-12 00:00:00.000', 121), NULL, NULL),

('BCR000000000070', N'01/2020/HĐTN - Ngày 15/06/2020', N'Bà Rịa - Vũng Tàu', 'DT', NULL, NULL, NULL, 99000000, NULL, NULL, 297000000, 0, 90000000, 99000000, 5, 9000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-06-15 00:00:00.000', 121), CONVERT(DATETIME, '2020-08-17 00:00:00.000', 121), CONVERT(DATETIME, '2030-08-15 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định trong 4 năm đầu. Mỗi 03 năm 

điều chỉnh tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.010', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000077', NULL, 48, CONVERT(DATETIME, '2024-08-17 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-08-17 00:00:00.000', 121), NULL, NULL),

('BCR000000000071', N'01/HĐTN/BRVT.14 - Ngày 14/07/2014; TTSĐBSHĐ ngày 25/09/2020', N'Đông Xuyên ', 'DT', NULL, NULL, NULL, 25000000, NULL, NULL, 75000000, 0, 22727273, 25000000, 5, 2272727, 9, '6', N'', N'0', CONVERT(DATETIME, '2014-07-14 00:00:00.000', 121), CONVERT(DATETIME, '2014-11-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-10-31 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.013', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000078', NULL, 36, CONVERT(DATETIME, '2017-11-01 00:00:00.000', 121), 110, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 143, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2014-11-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000072', N'2019/HĐTN.BR-VT - Ngày 26/04/2019', N'PGD Châu Đức ', 'DT', NULL, NULL, NULL, 27500000, NULL, NULL, 75000000, 0, 25000000, 27500000, 5, 2500000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-04-26 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-06 00:00:00.000', 121), CONVERT(DATETIME, '2024-06-06 00:00:00.000', 121), NULL, NULL, N'Gía thuê được giữ cố định 03 năm đầu, 02 năm tiếp

 theo tăng/ giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.013', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000079', NULL, 36, CONVERT(DATETIME, '2022-06-06 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-06-06 00:00:00.000', 121), NULL, NULL),

('BCR000000000073', N'01/2019/HĐTN.VT - Tháng 05/2019', N'PGD Bà Ria', 'DT', NULL, NULL, NULL, 29960000, NULL, NULL, 56000000, 0, 27236364, 29960000, 5, 2723636, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-05-06 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-07 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-07 00:00:00.000', 121), NULL, NULL, N'Gía thuê được giữ cố định 04 năm đầu, 03 năm tiếp theo tăng/ giảm 7%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.013', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000080', NULL, 48, CONVERT(DATETIME, '2023-06-07 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 7%', CONVERT(DATETIME, '2019-06-07 00:00:00.000', 121), NULL, NULL),

('BCR000000000085', N'030/HĐTN.HCM.16 - Ngày 30/12/2016', N'Cao Thắng ', 'DT', NULL, NULL, NULL, 161665000, NULL, NULL, 0, 0, 146968182, 161665000, 5, 14696818, 9, '6', N'', N'0', CONVERT(DATETIME, '2016-12-30 00:00:00.000', 121), CONVERT(DATETIME, '2017-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-30 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.027', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000006', NULL, 60, CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 113, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'từ 230,500,000 đồng/tháng giảm xuống 161,665,000 đồng/tháng', CONVERT(DATETIME, '2017-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000086', N'16/HĐTN.HCM.16 - Ngày 15/04/2016 

TTSĐBSHĐ ngày 13/04/2021', N'Trần Quang Khải ', 'DT', NULL, NULL, NULL, 69887500, NULL, NULL, 220000000, 0, 63534091, 69887500, 5, 6353409, 9, '3', N'', N'0', CONVERT(DATETIME, '2016-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2016-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2024-04-15 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định 01 năm đầu, mỗi năm tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.027', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000009', NULL, 36, CONVERT(DATETIME, '2019-04-15 00:00:00.000', 121), 120, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5%', CONVERT(DATETIME, '2016-04-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000087', N'14/09/HĐTN - Ngày 08/10/2009', N'Khánh Hội', 'DT', NULL, NULL, NULL, 84980000, NULL, NULL, 502941000, 0, 77254546, 84980000, 5, 7725454, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-08-10 00:00:00.000', 121), CONVERT(DATETIME, '2009-01-11 00:00:00.000', 121), CONVERT(DATETIME, '2027-10-31 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định 02 năm đầu gia hạn, 02 năm còn lại tăng/giảm 10%

Từ 1/11/2023 đến 31/10/2025: 93.478.000', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.030', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000017', NULL, 12, CONVERT(DATETIME, '2010-01-11 00:00:00.000', 121), 24, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 225, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2009-01-11 00:00:00.000', 121), NULL, NULL),

('BCR000000000088', N'1611/2020/HĐTN - Ngày 13/11/2020', N'Bình Đăng', 'DT', NULL, NULL, NULL, 99000000, NULL, NULL, 270000000, 0, 90000000, 99000000, 5, 9000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-11-23 00:00:00.000', 121), CONVERT(DATETIME, '2020-12-20 00:00:00.000', 121), CONVERT(DATETIME, '2025-12-19 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định trong 2 năm đầu. Mỗi hai năm tiếp 

theo giá thuê tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.030', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000012', NULL, 24, CONVERT(DATETIME, '2022-12-20 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-12-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000089', N'13/09/HĐTN - Ngày 23/09/2009; 09/PLHĐ.HCM.16 - Ngày 01/09/2016', N'Nguyễn Thị Thập', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 226600000, 0, 54545455, 60000000, 5, 5454545, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-09-23 00:00:00.000', 121), CONVERT(DATETIME, '2009-10-31 00:00:00.000', 121), CONVERT(DATETIME, '2028-10-31 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 03 năm gia hạn, 02 năm còn lại tăng/giảm 10%

1/11/2023 đến 31/10/2026: 65tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.030', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000015', NULL, 48, CONVERT(DATETIME, '2013-10-31 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 228, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2009-10-31 00:00:00.000', 121), NULL, NULL),

('BCR000000000090', N'16/09/HĐTN ', N'Phú Mỹ Hưng', 'DT', NULL, NULL, NULL, 154880000, NULL, NULL, 768000000, 0, 140800000, 154880000, 5, 14080000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-11-12 00:00:00.000', 121), CONVERT(DATETIME, '2020-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-12-31 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 02 năm đầu, Mỗi 02 năm

 điều chỉnh tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.030', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000019', NULL, 24, CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000091', N'335-37/HĐTN.HCM.14', N'Nguyễn Tri Phương ', 'DT', NULL, NULL, NULL, 126000000, NULL, NULL, 210000000, 0, 114545455, 126000000, 5, 11454545, 9, '3', N'', N'0', CONVERT(DATETIME, '2014-06-26 00:00:00.000', 121), CONVERT(DATETIME, '2014-07-28 00:00:00.000', 121), CONVERT(DATETIME, '2026-07-27 00:00:00.000', 121), NULL, NULL, N'Mỗi năm tăng 10%

Từ 28/07/2023 đến 27/07/2024: 126tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.033', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000014', NULL, 36, CONVERT(DATETIME, '2017-07-28 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 144, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2014-07-28 00:00:00.000', 121), NULL, NULL),

('BCR000000000092', N'1506/2018/HĐTN', N'CN Tây Sài Gòn ', 'DT', NULL, NULL, NULL, 200000000, NULL, NULL, 577696350, 0, 181818182, 200000000, 5, 18181818, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-06-15 00:00:00.000', 121), CONVERT(DATETIME, '2018-09-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-31 00:00:00.000', 121), NULL, NULL, N'Giá thuê giữ cố định 03 năm đầu, mỗi 02 năm tiếp theo được điều chỉnh tăng/ giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.033', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000111', NULL, 36, CONVERT(DATETIME, '2021-09-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2018-09-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000093', N'1610/2018/HĐTN.HCM', N'Tân Phú ', 'DT', NULL, NULL, NULL, 157300000, NULL, NULL, 429000000, 0, 143000000, 157300000, 5, 14300000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-10-16 00:00:00.000', 121), CONVERT(DATETIME, '2018-10-16 00:00:00.000', 121), CONVERT(DATETIME, '2028-10-16 00:00:00.000', 121), NULL, NULL, N'Giá thuê giữ cố định 03 năm đầu, mỗi 03 năm tiếp theo được điều chỉnh tăng/ giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.037', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000010', NULL, 36, CONVERT(DATETIME, '2021-10-16 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2018-10-16 00:00:00.000', 121), NULL, NULL),

('BCR000000000001', N'HĐ 1306 HDTT/2014 ngày 15/7/2014

PL 1306-05/PLHĐ/2020 ngày 12/03/2021

PL 1306-06/PLHĐ/2021 ngày 26/7/2021

PL 1307/PLHĐ/2022 ngày 29/7/2022', N'CÔNG TY CP HÀNG KHÔNG HẢI ÂU', 'CT', NULL, NULL, NULL, 81814887, 0, NULL, 94500000, 0, 81814887, 81814887, 5, 7437717, 3, '3T', N'', N'0', CONVERT(DATETIME, '2014-07-15 00:00:00.000', 121), CONVERT(DATETIME, '2014-07-15 00:00:00.000', 121), CONVERT(DATETIME, '2023-07-30 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2014-07-15 00:00:00.000', 121), 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 108, NULL, NULL, NULL, NULL, NULL, 'MB001', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2014-07-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000002', N'HĐ 1601 HD TT/2016 ngày 22.02.2016

Phụ lục gia hạn: ngày 10/04/2023', N'CÔNG TY TNHH LI&FUNG (VIỆT NAM)', 'CT', NULL, NULL, NULL, 7000000, 0, NULL, 0, 0, 7000000, 7000000, 5, 636364, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2016-02-22 00:00:00.000', 121), CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-04-30 00:00:00.000', 121), NULL, NULL, N'Phụ lục gia hạn 1 năm', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, NULL, NULL, NULL, NULL, 'MB002', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000003', N'HĐ 1601 HD TT/2016 ngày 22.02.2016

PL 1601-04/PLHĐ/2021 ngày 15/7/2021

PL 1601-03/PLHĐ/2021 ngày 26/04/2021)', N'CÔNG TY TNHH LI&FUNG (VIỆT NAM)', 'CT', NULL, NULL, NULL, 137184960, 0, NULL, 357033600, 0, 137184960, 137184960, 5, 12471360, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2016-02-22 00:00:00.000', 121), CONVERT(DATETIME, '2021-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-30 00:00:00.000', 121), NULL, NULL, N'Giá thuê thay đổi dựa trên tỷ giá USD tại kỳ xuất hóa đơn', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2021-05-01 00:00:00.000', 121), 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, 'MB002A', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2021-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000004', N'HĐ: 0010.HĐ TVP/2020 ngày 12/3/2020

PL: 0010-01/PLHĐ/2023 ngày 25/4/2023', N'CÔNG TY TNHH SO ASIA', 'CT', NULL, NULL, NULL, 60530407, 0, NULL, 0, 0, 60530407, 60530407, 5, 5502764, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2020-03-12 00:00:00.000', 121), CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-30 00:00:00.000', 121), NULL, NULL, N'Giá thuê thay đổi dựa trên tỷ giá USD tại kỳ xuất hóa đơn.

', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB003', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000005', N'HĐ: 0011.HĐ TVP/2020 ngày 12/3/2020

PL: 0011-01/PLHĐ/2023 ngày 25/4/2023', N'VĂN PHÒNG ĐẠI DIỆN SO KIKAKU SEKKEI LTD TẠI TP HÀ NỘI', 'CT', NULL, NULL, NULL, 15997314, 0, NULL, 47272680, 0, 15997314, 15997314, 5, 1454301, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2020-03-12 00:00:00.000', 121), CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-30 00:00:00.000', 121), NULL, NULL, N'Giá thuê thay đổi dựa trên tỷ giá USD tại kỳ xuất hóa đơn.

', '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB004', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000006', N'HĐ: 1602/HDTMB/2016

PL: 1602-02/PLHĐ/2021 ngày 17/11/2021', N'CÔNG TY ĐẦU TƯ KỸ THUẬT BERJAYA GIA THỊNH', 'CT', NULL, NULL, NULL, 69215872, 5, NULL, 207647616, 0, 69215872, 69215872, 5, 6292352, NULL, '3T', N'', N'12', CONVERT(DATETIME, '2021-11-17 00:00:00.000', 121), CONVERT(DATETIME, '2021-12-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-11-30 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2021-12-01 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, 'MB005', NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2021-12-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000007', N'HĐ 171015/HDLDT-TV (28/9/2017)

Phụ lục chuyển giao và sửa đổi ngày 25/02/2021', N'CÔNG TY CP THIẾT BỊ VIỄN THÔNG SAO PHƯƠNG NAM', 'CT', NULL, NULL, NULL, 7150000, 0, NULL, 0, 0, 7150000, 7150000, 5, 650000, NULL, '12T', N'', N'0', CONVERT(DATETIME, '2017-09-28 00:00:00.000', 121), CONVERT(DATETIME, '2020-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2023-09-30 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2020-10-01 00:00:00.000', 121), 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB006', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2020-10-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000008', N'2101/HĐTVP/2021 ngày 1/10/2021', N'CÔNG TY CP ĐẦU TƯ AHT TOÀN CẦU', 'CT', NULL, NULL, NULL, 80797464, 0, NULL, 242392000, 0, 80797464, 80797464, 5, 7345224, NULL, '3T', N'', N'0', CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-10-31 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, 'MB007', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000009', N'2202. HĐ TVP/2022 ngày 10/01/2022', N'CÔNG TY CP ĐẦU TƯ ACB HÀ NỘI', 'CT', NULL, NULL, NULL, 8550000, 0, NULL, 25650000, 0, 8550000, 8550000, 5, 777273, NULL, '3T', N'', N'12', CONVERT(DATETIME, '2022-01-10 00:00:00.000', 121), CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), CONVERT(DATETIME, '2027-01-14 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, 'MB008', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000010', N'2201. HĐ TVP/2022 ngày 10/01/2022', N'CÔNG TY TNHH ĐẦU TƯ TÀI CHÍNH Á CHÂU HÀ NỘI', 'CT', NULL, NULL, NULL, 8550000, 0, NULL, 25650000, 0, 8550000, 8550000, 5, 777273, NULL, '3T', N'', N'12', CONVERT(DATETIME, '2022-01-10 00:00:00.000', 121), CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), CONVERT(DATETIME, '2027-01-14 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, 'MB009', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2022-01-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000011', N'HD 09/HĐ TVP/2019

PL02 ngày 01/10/2021', N'CÔNG TY CP TT TẬP TRUNG MẶT TRỜI VÀNG', 'CT', NULL, NULL, NULL, 9350000, 0, NULL, 0, 0, 9350000, 9350000, 5, 850000, NULL, '12T', N'', N'0', CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-09-30 00:00:00.000', 121), NULL, NULL, NULL, '1', NULL, CONVERT(DATETIME, '2023-07-31 11:15:06.110', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 0, CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, 'MB010', NULL, NULL, NULL, NULL, NULL, 'RATE', 'DOWN', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000104', N'2307/2020/HĐTN.HCM

', N'Bình Chánh', 'DT', NULL, NULL, NULL, 40000000, NULL, NULL, 210000000, 0, 36363636, 40000000, 5, 3636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-12-03 00:00:00.000', 121), CONVERT(DATETIME, '2010-06-10 00:00:00.000', 121), CONVERT(DATETIME, '2028-06-10 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.047', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000027', NULL, 36, CONVERT(DATETIME, '2013-06-10 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 216, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2010-06-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000105', N'1905/2020/HĐTN.HCM', N'Củ Chi', 'DT', NULL, NULL, NULL, 36000000, NULL, NULL, 300000000, 0, 32727273, 36000000, 5, 3272727, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-05-17 00:00:00.000', 121), CONVERT(DATETIME, '2010-08-31 00:00:00.000', 121), CONVERT(DATETIME, '2026-08-30 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.047', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000026', NULL, 36, CONVERT(DATETIME, '2013-08-31 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 192, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2010-08-31 00:00:00.000', 121), NULL, NULL),

('BCR000000000106', N'1405/2019/HĐTN', N'Nguyễn Duy Trinh ', 'DT', NULL, NULL, NULL, 69300000, NULL, NULL, 207900000, 0, 63000000, 69300000, 5, 6300000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-05-14 00:00:00.000', 121), CONVERT(DATETIME, '2019-07-20 00:00:00.000', 121), CONVERT(DATETIME, '2024-07-20 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 03 năm đầu,  02 năm tiếp theo tăng giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.047', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000023', NULL, 36, CONVERT(DATETIME, '2022-07-20 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-07-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000107', N'2018/HĐTN.HCM', N'Trần Não', 'DT', NULL, NULL, NULL, 71500000, NULL, NULL, 214500000, 0, 65000000, 71500000, 5, 6500000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-09-12 00:00:00.000', 121), CONVERT(DATETIME, '2018-10-12 00:00:00.000', 121), CONVERT(DATETIME, '2028-10-12 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 05 năm đầu,  02 năm tiếp theo tăng không quá 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.050', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000028', NULL, 60, CONVERT(DATETIME, '2023-10-12 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng không quá 10%', CONVERT(DATETIME, '2018-10-12 00:00:00.000', 121), NULL, NULL),

('BCR000000000108', N'0110/2019/HĐTN.HD ', N'Nguyễn Tất Thành ', 'DT', NULL, NULL, NULL, 217800000, NULL, NULL, 594000000, 0, 198000000, 217800000, 5, 19800000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2019-10-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-09-30 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 02 năm đầu,  Mỗi 02 năm tiếp theo điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.050', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000029', NULL, 24, CONVERT(DATETIME, '2021-10-01 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-10-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000109', N'01-10/HĐTN/VBHCM.14', N'Huỳnh Tấn Phát ', 'DT', NULL, NULL, NULL, 46200000, NULL, NULL, 210000000, 0, 42000000, 46200000, 5, 4200000, 9, '3', N'', N'0', CONVERT(DATETIME, '2014-10-17 00:00:00.000', 121), CONVERT(DATETIME, '2014-10-20 00:00:00.000', 121), CONVERT(DATETIME, '2028-10-20 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 02 năm đầu,  03 năm tiếp theo tăng 9%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.050', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000025', NULL, 36, CONVERT(DATETIME, '2017-10-20 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 168, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2014-10-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000110', N'2017/HĐTN.HCM ', N'Võ Văn Ngân ', 'DT', NULL, NULL, NULL, 64420400, NULL, NULL, 120000000, 0, 58564000, 64420400, 5, 5856400, 9, '3', N'', N'0', CONVERT(DATETIME, '2017-08-20 00:00:00.000', 121), CONVERT(DATETIME, '2017-08-20 00:00:00.000', 121), CONVERT(DATETIME, '2027-02-19 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 01 năm đầu, Mỗi 02 năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.053', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000024', NULL, 12, CONVERT(DATETIME, '2018-08-20 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2017-08-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000111', N'1206/2020/HĐTN.NAT', N'Nguyễn Ảnh Thủ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 240000000, 0, 54545455, 60000000, 5, 5454545, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-10-02 00:00:00.000', 121), CONVERT(DATETIME, '2010-04-01 00:00:00.000', 121), CONVERT(DATETIME, '2028-03-31 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định trong 01 năm đầu, Mỗi 02 năm điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.053', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000113', NULL, 12, CONVERT(DATETIME, '2011-04-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 215, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2010-04-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000112', N'24/10/HĐTN.HCM ', N'Lê Văn Khương ', 'DT', NULL, NULL, NULL, 50800000, NULL, NULL, 300000000, 0, 46181818, 50800000, 5, 4618182, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-11-23 00:00:00.000', 121), CONVERT(DATETIME, '2010-12-31 00:00:00.000', 121), CONVERT(DATETIME, '2024-12-31 00:00:00.000', 121), NULL, NULL, N'Giá thuê nhà được giữ cố định trong 02 năm. Mỗi 02 năm tiếp theo điều chỉnh tăng/ giảm 10%.', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.053', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000112', NULL, 24, CONVERT(DATETIME, '2012-12-31 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 168, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2010-12-31 00:00:00.000', 121), NULL, NULL),

('BCR000000000113', N'1003/2021/HĐTN', N'Lê Văn Việt ', 'DT', NULL, NULL, NULL, 45000000, NULL, NULL, 180000000, 0, 40909091, 45000000, 5, 4090909, 9, '3', N'', N'0', CONVERT(DATETIME, '2021-03-10 00:00:00.000', 121), CONVERT(DATETIME, '2021-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-14 00:00:00.000', 121), NULL, NULL, N'giá thuê 60,000,000 đồng/tháng được giữ trong 03 nằm đầu, 02 năm cuối +/- 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.057', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000109', NULL, 36, CONVERT(DATETIME, '2024-04-15 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2021-04-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000125', N'09/10/HĐTN.HCM, PL Số 22-03/2022/HĐTN ngày 22/03/2022', N'PGD Chánh Hưng', 'DT', NULL, NULL, NULL, 63000000, NULL, NULL, 160623000, 0, 57272727, 63000000, 5, 5727273, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-04-06 00:00:00.000', 121), CONVERT(DATETIME, '2010-04-06 00:00:00.000', 121), CONVERT(DATETIME, '2027-04-05 00:00:00.000', 121), NULL, NULL, N'Mỗi 02 năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.067', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000101', NULL, 24, CONVERT(DATETIME, '2012-04-06 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 204, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2010-04-06 00:00:00.000', 121), NULL, NULL),

('BCR000000000126', N'21/HĐTN.HCM ', N'PGD Chương Dương', 'DT', NULL, NULL, NULL, 117240200, NULL, NULL, 923600000, 0, 106582000, 117240200, 5, 10658200, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-02-08 00:00:00.000', 121), CONVERT(DATETIME, '2010-10-03 00:00:00.000', 121), CONVERT(DATETIME, '2023-10-02 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.067', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000103', NULL, 36, CONVERT(DATETIME, '2013-10-03 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 156, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2010-10-03 00:00:00.000', 121), NULL, NULL),

('BCR000000000127', N'2810/2021/HĐTN ', N'PGD Hóc Môn', 'DT', NULL, NULL, NULL, 110000000, NULL, NULL, 300000000, 0, 100000000, 110000000, 5, 10000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2021-10-28 00:00:00.000', 121), CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2031-12-31 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 4 năm đầu. Mỗi 2 năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.070', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000102', NULL, 48, CONVERT(DATETIME, '2026-01-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000128', N'01/2019/HĐTN.VIETBANK', N'CN Daklak', 'DT', NULL, NULL, NULL, 90750000, NULL, NULL, 225000000, 0, 82500000, 90750000, 5, 8250000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-01-10 00:00:00.000', 121), CONVERT(DATETIME, '2019-03-15 00:00:00.000', 121), CONVERT(DATETIME, '2029-03-14 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giũ cố định trong 02 năm đầu,mỗi 02 năm tiếp theo sẽ tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.070', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000114', NULL, 24, CONVERT(DATETIME, '2021-03-15 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-03-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000129', N'1006/2019/HĐTN.AG', N'Chi nhánh An Giang', 'DT', NULL, NULL, NULL, 108900000, NULL, NULL, 540000000, 0, 99000000, 108900000, 5, 9900000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-06-10 00:00:00.000', 121), CONVERT(DATETIME, '2019-07-10 00:00:00.000', 121), CONVERT(DATETIME, '2024-07-10 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định 02 năm đầu. 03 năm cuối giá thuê tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.070', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000118', NULL, 36, CONVERT(DATETIME, '2022-07-10 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-07-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000130', N'1448/KM/2019/HĐTN ', N'Chi nhánh Vĩnh Phúc ', 'DT', NULL, NULL, NULL, 90000000, NULL, NULL, 300000000, 0, 81818182, 90000000, 5, 8181818, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-06-05 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-16 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-16 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giũ cố định trong 03 năm đầu,mỗi 03 năm tiếp theo sẽ điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.070', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000117', NULL, 36, CONVERT(DATETIME, '2022-06-16 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-06-16 00:00:00.000', 121), NULL, NULL),

('BCR000000000131', N'2504/2019/HĐTN.ĐN', N'Chi nhánh Đồng Nai ', 'DT', NULL, NULL, NULL, 66000000, NULL, NULL, 180000000, 0, 60000000, 66000000, 5, 6000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-04-25 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-24 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-24 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giũ cố định trong 04 năm đầu,mỗi 03 năm tiếp theo sẽ tăng/ giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.073', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000115', NULL, 48, CONVERT(DATETIME, '2023-06-24 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-06-24 00:00:00.000', 121), NULL, NULL),

('BCR000000000132', N'18/2022/HĐTN', N'Chi nhánh Bình Dương ', 'DT', NULL, NULL, NULL, 180000000, NULL, NULL, 540000000, 0, 163636364, 180000000, 5, 16363636, 9, '3', N'', N'0', CONVERT(DATETIME, '2022-05-18 00:00:00.000', 121), CONVERT(DATETIME, '2022-06-21 00:00:00.000', 121), CONVERT(DATETIME, '2027-06-20 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giũ cố định trong 04 năm 03 năm tiếp theo sẽ tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.073', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000116', NULL, 48, CONVERT(DATETIME, '2026-06-21 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2022-06-21 00:00:00.000', 121), NULL, NULL),

('BCR000000000133', N'26/2020/HĐTN.HCM ', N'Chi nhánh Đồng Tháp ', 'DT', NULL, NULL, NULL, 80000000, NULL, NULL, 240000000, 0, 72727273, 80000000, 5, 7272727, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-02-06 00:00:00.000', 121), CONVERT(DATETIME, '2020-08-20 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-19 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.073', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000119', NULL, 60, CONVERT(DATETIME, '2025-08-20 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2020-08-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000134', N'2020/HĐTN.KG', N'Chi nhánh Kiên Giang ', 'DT', NULL, NULL, NULL, 110000000, NULL, NULL, 270000000, 0, 100000000, 110000000, 5, 10000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-07-17 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-31 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố dịnh trong 2 năm đầu, năm thứ 3 giá 110,000,000 VNĐ, 02 năm cuối giá thuê nhà +/- 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.077', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000123', NULL, 24, CONVERT(DATETIME, '2022-09-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2020-09-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000025', N'02727; quyển số 02/2021 TP/CC-SCC/HĐGD ngày 10/05/2021 và 

02728; quyển số 02/2021 TP/CC-SCC/HĐGD ngày 10/05/2021', N'Gia Lâm (Đường Thành)', 'DT', NULL, NULL, NULL, 90677400, NULL, NULL, 240000000, 2677400, 80000000, 88000000, 5, 8000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2021-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2021-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2025-05-10 00:00:00.000', 121), NULL, NULL, N'Từ năm thứ 03 mỗi năm điều chỉnh 01 lần', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.970', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000038', NULL, 24, CONVERT(DATETIME, '2023-05-10 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 48, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2021-05-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000026', N'04546.2020/HĐTN quyển số 3 TP/CC-SCC/HĐGD ngày 18/09/2020', N'Mỹ Đình (Nguyễn Thái Học cũ)', 'DT', NULL, NULL, NULL, 100582240, NULL, NULL, 264000000, 1582240, 90000000, 99000000, 5, 9000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-09-18 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-18 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-17 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.973', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000034', NULL, 12, CONVERT(DATETIME, '2021-09-18 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng từ 88 triệu lên 99 triệu', CONVERT(DATETIME, '2020-09-18 00:00:00.000', 121), NULL, NULL),

('BCR000000000027', N'01/2019/HĐTN.ĐC ngày 25/04/2019', N'Đội Cấn ', 'DT', NULL, NULL, NULL, 115500000, NULL, NULL, 200000000, 0, 105000000, 115500000, 5, 10500000, 9, '6', N'', N'0', CONVERT(DATETIME, '2019-05-11 00:00:00.000', 121), CONVERT(DATETIME, '2019-05-11 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-11 00:00:00.000', 121), NULL, NULL, N'Từ năm thứ 04 mỗi năm tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.973', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000045', NULL, 36, CONVERT(DATETIME, '2022-05-11 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0,05', CONVERT(DATETIME, '2019-05-11 00:00:00.000', 121), NULL, NULL),

('BCR000000000028', N'5625.2009/HĐTN ngày 21/12/2009', N'Quán Thánh ', 'DT', NULL, NULL, NULL, 95500000, NULL, NULL, 50000000, 0, 86818182, 95500000, 5, 8681818, 9, '6', N'', N'0', CONVERT(DATETIME, '2009-12-21 00:00:00.000', 121), CONVERT(DATETIME, '2009-12-21 00:00:00.000', 121), CONVERT(DATETIME, '2024-12-21 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.973', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000040', NULL, 24, CONVERT(DATETIME, '2011-12-21 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Cố định giá đến khi hết hạn', CONVERT(DATETIME, '2009-12-21 00:00:00.000', 121), NULL, NULL),

('BCR000000000029', N'Số HĐ: …../2019/HĐTN.CT ngày 10/05/2019', N'Bắc Từ Liêm ', 'DT', NULL, NULL, NULL, 100000000, NULL, NULL, 100000000, 0, 90909091, 100000000, 5, 9090909, 9, '0', N'', N'0', CONVERT(DATETIME, '2019-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-31 00:00:00.000', 121), NULL, NULL, N'Từ năm thứ 03 mỗi 02 năm điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.977', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000046', NULL, 24, CONVERT(DATETIME, '2021-06-01 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000030', N'04508.2020/CCHH/HĐTN quyển số 13 TP/CC-SCC/HĐGD ngày 22/09/2020', N'Thanh Xuân ', 'DT', NULL, NULL, NULL, 71500000, NULL, NULL, 180000000, 0, 65000000, 71500000, 5, 6500000, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-09-22 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-22 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-21 00:00:00.000', 121), NULL, NULL, N'Từ 01/01/2022 đến hết hạn HĐTN tăng/giảm 10%

01/01/2024-21/09/2025: 71.500.000tr/tháng (chưa VAT)', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.977', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000037', NULL, 3, CONVERT(DATETIME, '2020-12-22 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2020-09-22 00:00:00.000', 121), NULL, NULL),

('BCR000000000031', N'01/2018/HĐTN ngày 10/5/2018', N'Láng Hạ', 'DT', NULL, NULL, NULL, 115000000, NULL, NULL, 100000000, 0, 104545455, 115000000, 5, 10454545, 9, '12', N'', N'0', CONVERT(DATETIME, '2018-05-10 00:00:00.000', 121), CONVERT(DATETIME, '2018-07-01 00:00:00.000', 121), CONVERT(DATETIME, '2028-06-30 00:00:00.000', 121), NULL, NULL, N'Từ 01/07/2026 đến 30/06/2028 ( hết hạn HĐ) tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.977', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000048', NULL, 36, CONVERT(DATETIME, '2021-07-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2018-07-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000032', N'370.2009/HĐTN ngày 29/04/2009 và thỏa thuận sửa đổi bổ sung mới nhất số công chứng: 2362.2021, quyển số 01TP/SS-SCC/HĐGD ngày 22/04/2021', N'Khâm Thiên ', 'DT', NULL, NULL, NULL, 66000000, NULL, NULL, 0, 0, 60000000, 66000000, 5, 6000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2009-04-29 00:00:00.000', 121), CONVERT(DATETIME, '2009-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-06-01 00:00:00.000', 121), NULL, NULL, N'Từ 02/06/2022 đến 02/06/2024 tăng từ 60tr lên 66tr theo HĐTN', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.977', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000035', NULL, 12, CONVERT(DATETIME, '2010-06-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2009-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000033', N'03616/2020/HĐTN ngày 31/07/2020', N'Lê Thanh Nghị', 'DT', NULL, NULL, NULL, 90000000, NULL, NULL, 80000000, 0, 81818182, 90000000, 5, 8181818, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-07-31 00:00:00.000', 121), CONVERT(DATETIME, '2020-08-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-01 00:00:00.000', 121), NULL, NULL, N'Từ 01/01/2024 trở về sau giá thuê điều chỉnh tăng/giảm 10% so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.980', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000036', NULL, 16, CONVERT(DATETIME, '2021-12-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2020-08-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000034', N'6148.2011/HĐTN ngày 19.9.2011', N'Lò Đúc ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 0, 0, 54545455, 60000000, 5, 5454545, 9, '6', N'', N'0', CONVERT(DATETIME, '2011-09-19 00:00:00.000', 121), CONVERT(DATETIME, '2011-06-15 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-19 00:00:00.000', 121), NULL, NULL, N'Gia hạn từ 19/09/2023-19/09/2025 tăng từ 60tr lên 64tr', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.980', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000039', NULL, 24, CONVERT(DATETIME, '2013-06-15 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 171, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2011-06-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000053', N'68/2020/HĐTN ngày 04/09/2020', N'PGD Hưng Dũng ', 'DT', NULL, NULL, NULL, 71400000, NULL, NULL, 100000000, 0, 64909091, 71400000, 5, 6490909, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-09-04 00:00:00.000', 121), CONVERT(DATETIME, '2020-10-22 00:00:00.000', 121), CONVERT(DATETIME, '2030-10-22 00:00:00.000', 121), NULL, NULL, N'Từ năm 3 mỗi năm tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.997', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000088', NULL, 24, CONVERT(DATETIME, '2022-10-22 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng  5%', CONVERT(DATETIME, '2020-10-22 00:00:00.000', 121), NULL, NULL),

('BCR000000000074', N'01/14/HĐTN.CT - Ngày 27/02/2014; TTSĐBSHĐ ngày 06/04/2021', N'An Hòa', 'DT', NULL, NULL, NULL, 40000000, NULL, NULL, 90000000, 0, 36363636, 40000000, 5, 3636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2014-02-27 00:00:00.000', 121), CONVERT(DATETIME, '2014-04-25 00:00:00.000', 121), CONVERT(DATETIME, '2024-04-27 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.017', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000056', NULL, 36, CONVERT(DATETIME, '2017-04-25 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2014-04-25 00:00:00.000', 121), NULL, NULL),

('BCR000000000094', N'2311/2018/HĐTN.HCM', N'Bắc Sài Gòn ', 'DT', NULL, NULL, NULL, 272654300, NULL, NULL, 709500000, 0, 247867546, 272654300, 5, 24786754, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-10-25 00:00:00.000', 121), CONVERT(DATETIME, '2018-12-03 00:00:00.000', 121), CONVERT(DATETIME, '2026-12-02 00:00:00.000', 121), NULL, NULL, N'Tầng 1: Mỗi hai năm điều chỉnh tăng không quá 10%.

Tầng 02: Mỗi năm điều chỉnh tăng 5% so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.037', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000106', NULL, 12, CONVERT(DATETIME, '2019-12-03 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10% và tăng 5%', CONVERT(DATETIME, '2018-12-03 00:00:00.000', 121), NULL, NULL),

('BCR000000000114', N'2019/HĐTN.ĐXH', N'Đỗ Xuân Hợp ', 'DT', NULL, NULL, NULL, 91000000, NULL, NULL, 501600000, 0, 82727273, 91000000, 5, 8272727, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-01-26 00:00:00.000', 121), CONVERT(DATETIME, '2019-04-15 00:00:00.000', 121), CONVERT(DATETIME, '2024-04-14 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định trong suốt 0 2 năm đầu, mỗi  02 năm điều chỉnh tăng không quá 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.057', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000107', NULL, 24, CONVERT(DATETIME, '2021-04-15 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng không quá 10%', CONVERT(DATETIME, '2019-04-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000135', N'2206/2020/HĐTN ', N'Chi nhánh Quảng Ninh', 'DT', NULL, NULL, NULL, 143000000, NULL, NULL, 351000000, 0, 130000000, 143000000, 5, 13000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2020-06-22 00:00:00.000', 121), CONVERT(DATETIME, '2020-08-20 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-19 00:00:00.000', 121), NULL, NULL, N'giá chưa thuế

giá thuê năm đầu tiên: 117tr/tháng

giá thuê năm thứ 2: 130tr/tháng

từ 01/01/2023 giá thuê điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.077', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000121', NULL, 12, CONVERT(DATETIME, '2021-08-20 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2020-08-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000054', N'01/11/HĐTN.QNG - Ngày 17/03/2011', N'CN Quãng Ngãi', 'DT', NULL, NULL, NULL, 115013800, NULL, NULL, 413100000, 0, 104558000, 115013800, 5, 10455800, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-12-25 00:00:00.000', 121), CONVERT(DATETIME, '2011-05-19 00:00:00.000', 121), CONVERT(DATETIME, '2026-03-17 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.997', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000090', NULL, 60, CONVERT(DATETIME, '2016-05-19 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 178, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Cố định giá đến khi hết hạn', CONVERT(DATETIME, '2011-05-19 00:00:00.000', 121), NULL, NULL),

('BCR000000000055', N'2018/HĐTN.QN - Ngày 14/12/2018', N'PGD Tư Nghĩa ', 'DT', NULL, NULL, NULL, 24200000, NULL, NULL, 132000000, 0, 22000000, 24200000, 5, 2200000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-12-14 00:00:00.000', 121), CONVERT(DATETIME, '2019-02-20 00:00:00.000', 121), CONVERT(DATETIME, '2029-02-20 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 03 năm đầu, Mỗi 03 năm điều

 chỉnh tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.000', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000091', NULL, 36, CONVERT(DATETIME, '2022-02-20 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-02-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000056', N'02/2019/HĐTN.MĐ - Ngày 27/03/2019', N'Mộ Đức ', 'DT', NULL, NULL, NULL, 33000000, NULL, NULL, 0, 0, 30000000, 33000000, 5, 3000000, 9, '12', N'', N'0', CONVERT(DATETIME, '2019-03-27 00:00:00.000', 121), CONVERT(DATETIME, '2019-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-01 00:00:00.000', 121), NULL, NULL, N'Từ năm 4 mỗi 3 năm tăng/giảm 10% so với năm liền kề trước đó', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.000', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000092', NULL, 60, CONVERT(DATETIME, '2024-05-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000057', N'HĐTN ngày 25/04/2019', N'Bình Sơn ', 'DT', NULL, NULL, NULL, 22000000, NULL, NULL, 60000000, 0, 20000000, 22000000, 5, 2000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-04-25 00:00:00.000', 121), CONVERT(DATETIME, '2019-07-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-30 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 03 năm đầu, Mỗi 03 năm điều chỉnh tăng không quá 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.000', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000093', NULL, 36, CONVERT(DATETIME, '2022-07-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng không quá 10%', CONVERT(DATETIME, '2019-07-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000058', N'HĐTN ngày 06/03/2009; 01/PLHĐ.ĐN - Ngày 03/03/2021', N'CN Đà Nẵng', 'DT', NULL, NULL, NULL, 173643750, NULL, NULL, 0, 0, 157857955, 173643750, 5, 15785795, 9, '6', N'', N'0', CONVERT(DATETIME, '2009-03-06 00:00:00.000', 121), CONVERT(DATETIME, '2009-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-05 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 01 năm đầu. 

Các năm còn lại mỗi năm tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.000', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000065', NULL, 24, CONVERT(DATETIME, '2011-04-05 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 204, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5%', CONVERT(DATETIME, '2009-04-05 00:00:00.000', 121), NULL, NULL),

('BCR000000000059', N'HĐTN ngày 15/08/2009; 01/PL/2019 - Ngày 05/09/2019', N'Thanh Khê', 'DT', NULL, NULL, NULL, 66000000, NULL, NULL, 0, 0, 60000000, 66000000, 5, 6000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2009-08-15 00:00:00.000', 121), CONVERT(DATETIME, '2009-09-28 00:00:00.000', 121), CONVERT(DATETIME, '2024-09-29 00:00:00.000', 121), NULL, NULL, N'cố định 03 năm đầu, 02 năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.003', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000066', NULL, 36, CONVERT(DATETIME, '2012-09-28 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2009-09-28 00:00:00.000', 121), NULL, NULL),

('BCR000000000060', N'HĐTN ngày 11/08/2009; PLHĐ/TC.16 - Ngày 23/08/2016', N'Tân Chính ', 'DT', NULL, NULL, NULL, 86000000, NULL, NULL, 0, 0, 78181818, 86000000, 5, 7818182, 9, '6', N'', N'0', CONVERT(DATETIME, '2009-10-26 00:00:00.000', 121), CONVERT(DATETIME, '2009-10-26 00:00:00.000', 121), CONVERT(DATETIME, '2025-10-26 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định trong 02 năm gia hạn

Từ 27/10/2023 đến 26/10/2025: 110tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.003', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000067', NULL, 60, CONVERT(DATETIME, '2014-10-26 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 192, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2009-10-26 00:00:00.000', 121), NULL, NULL),

('BCR000000000061', N'01/2017/HĐTN-TTKDHV - Ngày 18/04/2017', N'Hùng Vương', 'DT', NULL, NULL, NULL, 49500000, NULL, NULL, 45000000, 0, 45000000, 49500000, 5, 4500000, 9, '6', N'', N'0', CONVERT(DATETIME, '2017-04-18 00:00:00.000', 121), CONVERT(DATETIME, '2017-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2027-04-30 00:00:00.000', 121), NULL, NULL, N'cố định 02 năm đầu, 03 năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.003', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000068', NULL, 84, CONVERT(DATETIME, '2024-05-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2017-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000062', N'HĐTN ngày 15/06/2016', N'Chợ Mới', 'DT', NULL, NULL, NULL, 72600000, NULL, NULL, 0, 0, 66000000, 72600000, 5, 6600000, 9, '6', N'', N'0', CONVERT(DATETIME, '2018-01-16 00:00:00.000', 121), CONVERT(DATETIME, '2018-03-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-02-28 00:00:00.000', 121), NULL, NULL, N'cố định 03 năm đầu, 02 năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.003', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000069', NULL, 36, CONVERT(DATETIME, '2021-03-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2018-03-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000063', N'HĐTN ngày 25/06/2010; 01/PL/DDA.19 - Ngày 24/07/2019', N'Đống Đa', 'DT', NULL, NULL, NULL, 33000000, NULL, NULL, 0, 0, 30000000, 33000000, 5, 3000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-06-25 00:00:00.000', 121), CONVERT(DATETIME, '2010-08-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-08-01 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.007', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000070', NULL, 84, CONVERT(DATETIME, '2017-08-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 168, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Cố định giá đến khi hết hạn', CONVERT(DATETIME, '2010-08-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000035', N'02571.2018/HĐTN quyển số 2 TP/CC-SCC/HĐGD ngày 01/06/2018', N'Lạc Trung ', 'DT', NULL, NULL, NULL, 70000000, NULL, NULL, 0, 0, 63636364, 70000000, 5, 6363636, 9, '12', N'', N'0', CONVERT(DATETIME, '2011-06-06 00:00:00.000', 121), CONVERT(DATETIME, '2011-06-15 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-15 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.980', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000052', NULL, 36, CONVERT(DATETIME, '2014-06-15 00:00:00.000', 121), 9, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'từ 16/06/2023 đến 15/06/2026 tăng từ 68tr lên 70tr', CONVERT(DATETIME, '2011-06-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000036', N'027/2016/HĐT-BH ngày 02/08/2016 (tầng 1) và 151/2020/HĐT-BH ngày 30/12/2019 (thuê thêm tầng 2). Phụ lục mới nhất số 06/PL-027/2016/HĐT-BH ngày 01/06/2021 và 03/PL-151/2020/HĐT-BH ngày 10/06/2021', N'Tố Hữu ', 'DT', NULL, NULL, NULL, 91335716, NULL, NULL, 270261420, 5824104, 77737829, 85511612, 5, 7773783, 9, '6', N'', N'0', CONVERT(DATETIME, '2016-08-02 00:00:00.000', 121), CONVERT(DATETIME, '2016-09-20 00:00:00.000', 121), CONVERT(DATETIME, '2024-09-19 00:00:00.000', 121), NULL, NULL, N'Từ 20/09/2023 đến 19/09/2024 (Hết hạn HĐTN) giữ nguyên giá thuê hiện tại', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.980', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000051', NULL, 24, CONVERT(DATETIME, '2018-09-20 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'giá thuê giữ cố định đến khi hết hạn', CONVERT(DATETIME, '2016-09-20 00:00:00.000', 121), NULL, NULL),

('BCR000000000037', N'5033.2014/HĐTN quyển 01 TP/CC SCC ngày 18/12/2014. Thỏa thuận sửa đổi bổ sung số công chứng 2908.2021/SĐBS ngày 21/05/2021', N'Trung Hòa ', 'DT', NULL, NULL, NULL, 72600000, NULL, NULL, 198000000, 0, 66000000, 72600000, 5, 6600000, 9, '3', N'', N'0', CONVERT(DATETIME, '2014-12-18 00:00:00.000', 121), CONVERT(DATETIME, '2014-12-10 00:00:00.000', 121), CONVERT(DATETIME, '2023-12-10 00:00:00.000', 121), NULL, NULL, N'11/12/2021 đến 11/12/2023 giá thuê là 72.600.000', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.983', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000041', NULL, 36, CONVERT(DATETIME, '2017-12-10 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 108, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2014-12-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000038', N'HĐ lần đầu số công chứng 4283.2010/HDDTN ngày 03/12/2010 và Hợp đồng sửa đổi bổ sung mới nhất số công chứng: 5863.2020/HĐSĐ ngày 19/11/2020', N'Nguyễn Khánh Toàn ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 0, 0, 54545455, 60000000, 5, 5454545, 9, '12', N'', N'0', CONVERT(DATETIME, '2010-03-12 00:00:00.000', 121), CONVERT(DATETIME, '2010-12-15 00:00:00.000', 121), CONVERT(DATETIME, '2025-12-15 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.983', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000050', NULL, 60, CONVERT(DATETIME, '2015-12-15 00:00:00.000', 121), 15, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2010-12-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000039', N'01/2019-HĐTN ngày 24/09/2020', N'Tây Hồ', 'DT', NULL, NULL, NULL, 101349000, NULL, NULL, 210000000, 2349000, 90000000, 99000000, 5, 9000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-09-24 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-24 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-23 00:00:00.000', 121), NULL, NULL, N'tăng từ 70tr lên 90tr theo thỏa thuân ban đầu', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.983', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000043', NULL, 24, CONVERT(DATETIME, '2022-09-24 00:00:00.000', 121), 90, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng theo thỏa thuận', CONVERT(DATETIME, '2020-09-24 00:00:00.000', 121), NULL, NULL),

('BCR000000000040', N'số công chứng HĐ thuê nhà lần đầu 615.2010/HĐTN ngày 25/03/2010 và số công chứng phụ lục gia hạn gần nhất: 01866 quyển số 2/2021.TP/CC-SCC/HĐGD ngày 01/04/2021', N'Đền Lừ', 'DT', NULL, NULL, NULL, 40000000, NULL, NULL, 0, 0, 36363636, 40000000, 5, 3636364, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-03-25 00:00:00.000', 121), CONVERT(DATETIME, '2010-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2025-05-01 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định trong 02 năm gia hạn là 40tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.987', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000044', NULL, 24, CONVERT(DATETIME, '2012-05-01 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2010-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000041', N'0502/2021/HĐTN ngày 05/02/2021', N'Hoàng Mai (Kim Đông cũ)', 'DT', NULL, NULL, NULL, 110000000, NULL, NULL, 300000000, 0, 100000000, 110000000, 5, 10000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2021-02-05 00:00:00.000', 121), CONVERT(DATETIME, '2021-05-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-04-30 00:00:00.000', 121), NULL, NULL, N'Từ năm 3 đến hết hạn HĐTN tăng/ giảm 10%

01/05/2023-31/10/2023: 100tr/tháng 

01/11/2023-30/04/2026: 110tr/tháng

giá chưa bao gồm thuế', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.987', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000047', NULL, 24, CONVERT(DATETIME, '2023-05-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2021-05-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000042', N'00496.2020/HĐTN quyển số 01 TP/SS SCC/HĐGD ngày 04/02/2020', N'Nguyễn Văn Cừ', 'DT', NULL, NULL, NULL, 88500000, NULL, NULL, 88500000, 0, 80454546, 88500000, 5, 8045454, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-04-02 00:00:00.000', 121), CONVERT(DATETIME, '2020-02-04 00:00:00.000', 121), CONVERT(DATETIME, '2026-02-04 00:00:00.000', 121), NULL, NULL, N'Từ năm 3 mỗi 2 năm tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:21.987', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000042', NULL, 24, CONVERT(DATETIME, '2022-02-04 00:00:00.000', 121), 25, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'Tăng/giảm 10%', CONVERT(DATETIME, '2020-02-04 00:00:00.000', 121), NULL, NULL),

('BCR000000000075', N'02/10/HĐTN.CT - Ngày 30/07/2010; TTSĐBSHĐ ngày 15/05/2020', N'Ninh Kiều', 'DT', NULL, NULL, NULL, 41800000, NULL, NULL, 100000000, 0, 38000000, 41800000, 5, 3800000, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-07-30 00:00:00.000', 121), CONVERT(DATETIME, '2017-09-15 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-15 00:00:00.000', 121), NULL, NULL, N'Gía thuê giữ cố định 01 năm, từ năm thứ 02 đến 

năm 05 tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.017', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000057', NULL, 12, CONVERT(DATETIME, '2018-09-15 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2017-09-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000076', N'01/2019/HĐTN.CT - Ngày 26/03/2019', N'Bình Thủy', 'DT', NULL, NULL, NULL, 20570000, NULL, NULL, 56100000, 0, 18700000, 20570000, 5, 1870000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-03-26 00:00:00.000', 121), CONVERT(DATETIME, '2019-05-15 00:00:00.000', 121), CONVERT(DATETIME, '2026-05-14 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giữ cố định 03 năm đầu, mỗi 03 năm điều

 chỉnh tăng 10% ', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.017', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000058', NULL, 36, CONVERT(DATETIME, '2022-05-15 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-05-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000077', N'3/10/HĐTN - Ngày 03/02/2010; TTSĐBSHĐ ngày 24/12/2019', N'CN Long An', 'DT', NULL, NULL, NULL, 63000000, NULL, NULL, 180000000, 0, 57272727, 63000000, 5, 5727273, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-03-02 00:00:00.000', 121), CONVERT(DATETIME, '2010-03-03 00:00:00.000', 121), CONVERT(DATETIME, '2025-03-02 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 2 năm đầu .  03 năm cuối tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.020', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000081', NULL, 24, CONVERT(DATETIME, '2012-03-03 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5%', CONVERT(DATETIME, '2010-03-03 00:00:00.000', 121), NULL, NULL),

('BCR000000000078', N'2019/HĐTN.LA - Ngày 17/04 /2019', N'Đức Hòa ', 'DT', NULL, NULL, NULL, 44000000, NULL, NULL, 132000000, 0, 40000000, 44000000, 5, 4000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-04-17 00:00:00.000', 121), CONVERT(DATETIME, '2019-05-22 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-22 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.020', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000082', NULL, 60, CONVERT(DATETIME, '2024-05-22 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2019-05-22 00:00:00.000', 121), NULL, NULL),

('BCR000000000079', N'2019/HĐTN.LA - Ngày 22/03/2019', N'Bến Lức ', 'DT', NULL, NULL, NULL, 25000000, NULL, NULL, 75000000, 0, 22727273, 25000000, 5, 2272727, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-03-22 00:00:00.000', 121), CONVERT(DATETIME, '2019-05-15 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-14 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.020', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000083', NULL, 60, CONVERT(DATETIME, '2024-05-15 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2019-05-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000080', N'03/2019/HĐTN.LA - Ngày 26/04/2019', N'Cần Guộc', 'DT', NULL, NULL, NULL, 22000000, NULL, NULL, 60000000, 0, 20000000, 22000000, 5, 2000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-04-26 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-09 00:00:00.000', 121), CONVERT(DATETIME, '2024-06-09 00:00:00.000', 121), NULL, NULL, N'Gía thuê được giữ cố định 03 năm đầu, 2 năm tiếp theo tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.020', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000084', NULL, 36, CONVERT(DATETIME, '2022-06-09 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2019-06-09 00:00:00.000', 121), NULL, NULL),

('BCR000000000081', N'01/10/HĐTN.SGDST - Ngày 09/11/2010; 41.2019/PL-HĐTN - Ngày 19/07/2019', N'Ngô Gia Tự', 'DT', NULL, NULL, NULL, 27500000, NULL, NULL, 0, 0, 25000000, 27500000, 5, 2500000, 9, '6', N'', N'0', CONVERT(DATETIME, '2010-09-11 00:00:00.000', 121), CONVERT(DATETIME, '2010-11-15 00:00:00.000', 121), CONVERT(DATETIME, '2028-11-15 00:00:00.000', 121), NULL, NULL, N'02 năm đầu gia hạn 27.5tr/tháng

03 năm cuối 30.25tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.023', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 24, CONVERT(DATETIME, '2012-11-15 00:00:00.000', 121), 6, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 216, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2010-11-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000082', N'12/2019/HĐTN.ST - Ngày 12/03/2019', N'Kế Sách ', 'DT', NULL, NULL, NULL, 19800000, NULL, NULL, 0, 0, 18000000, 19800000, 5, 1800000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-03-12 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-06-01 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.023', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000004', NULL, 84, CONVERT(DATETIME, '2026-06-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000083', N'19/2019/HĐTN.ST - Ngày 26/03/2019', N'Mỹ Tú ', 'DT', NULL, NULL, NULL, 17600000, NULL, NULL, 96000000, 0, 16000000, 17600000, 5, 1600000, 9, '6', N'', N'0', CONVERT(DATETIME, '2019-03-26 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), CONVERT(DATETIME, '2024-05-31 00:00:00.000', 121), NULL, NULL, N' Giá thuê được giữ cố định 03 năm đầu, giá thuê

 2 năm còn lại tăng/ giàm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.023', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000003', NULL, 36, CONVERT(DATETIME, '2022-06-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-06-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000084', N'HĐTN ngày 18/02/2020', N'CN TP Hồ Chí Minh ', 'DT', NULL, NULL, NULL, 643726108, NULL, NULL, 0, 0, 585205553, 643726108, 5, 58520555, 9, '3', N'', N'0', CONVERT(DATETIME, '2015-09-01 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-02 00:00:00.000', 121), CONVERT(DATETIME, '2026-09-01 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định 01 năm đầu, 02 năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.027', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 36, CONVERT(DATETIME, '2023-09-02 00:00:00.000', 121), 90, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-09-02 00:00:00.000', 121), NULL, NULL),

('BCR000000000095', N'1609/2019/HĐTN.HVH ', N'Phổ Quang', 'DT', NULL, NULL, NULL, 100057540, NULL, NULL, 270000000, 1057540, 90000000, 99000000, 5, 9000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2019-09-16 00:00:00.000', 121), CONVERT(DATETIME, '2019-11-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-10-31 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giữ cố định 02 năm đầu, mỗi 02 năm giá thuê sẽ được điều chỉnh tăng/giảm 10% ', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.037', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000020', NULL, 24, CONVERT(DATETIME, '2021-11-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2019-11-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000096', N'31/11/HĐTN.HCM ', N'Điện Biên Phủ', 'DT', NULL, NULL, NULL, 49500000, NULL, NULL, 58000000, 0, 45000000, 49500000, 5, 4500000, 9, '3', N'', N'0', CONVERT(DATETIME, '2011-11-16 00:00:00.000', 121), CONVERT(DATETIME, '2012-08-07 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-06 00:00:00.000', 121), NULL, NULL, N'Năm đầu giữ nguyên giá , năm sau tăng 53.9tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.040', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000008', NULL, 36, CONVERT(DATETIME, '2015-08-07 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 156, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 9,2%', CONVERT(DATETIME, '2012-08-07 00:00:00.000', 121), NULL, NULL),

('BCR000000000097', N'1802/2020/HĐTN_NTL', N'Nơ Trang Long ', 'DT', NULL, NULL, NULL, 62000000, NULL, NULL, 208305000, 0, 56363636, 62000000, 5, 5636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-12-22 00:00:00.000', 121), CONVERT(DATETIME, '2009-01-02 00:00:00.000', 121), CONVERT(DATETIME, '2029-01-31 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.040', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000021', NULL, 36, CONVERT(DATETIME, '2012-01-02 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 240, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2009-01-02 00:00:00.000', 121), NULL, NULL),

('BCR000000000098', N'01-2023/HĐTN/3B-VB', N'Cộng Hòa ', 'DT', NULL, NULL, NULL, 260000000, NULL, NULL, 900000000, 40000000, 200000000, 220000000, 5, 20000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2023-03-09 00:00:00.000', 121), CONVERT(DATETIME, '2023-03-09 00:00:00.000', 121), CONVERT(DATETIME, '2028-03-08 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định trong 02 năm đầu. 03 năm còn lại mỗi năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.040', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000007', NULL, 24, CONVERT(DATETIME, '2025-03-09 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2023-03-09 00:00:00.000', 121), NULL, NULL),

('BCR000000000099', N'HĐTN số công chứng 001506 ngày 10/02/2015; 01/PLHĐ.HCM.19 - Ngày 21/09/2019; 10/09/HĐTN - Ngày 04/08/2009', N'Lý Thường Kiệt', 'DT', NULL, NULL, NULL, 162140000, NULL, NULL, 146949000, 0, 147400000, 162140000, 5, 14740000, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-08-04 00:00:00.000', 121), CONVERT(DATETIME, '2009-10-05 00:00:00.000', 121), CONVERT(DATETIME, '2027-10-05 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định trong 02 năm đầu. 03 năm còn lại tăng 85tr/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.040', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000013', NULL, 24, CONVERT(DATETIME, '2011-10-05 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 216, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2009-10-05 00:00:00.000', 121), NULL, NULL),

('BCR000000000100', N'16/HĐTN.HCM.16 - Ngày 05/07/2016; TTSĐBSHĐ ngày 22/01/2020

TTSĐBS ngày 09/12/2021', N'Quang Trung ', 'DT', NULL, NULL, NULL, 152250000, NULL, NULL, 266730000, 0, 138409091, 152250000, 5, 13840909, 9, '3', N'', N'0', CONVERT(DATETIME, '2016-05-07 00:00:00.000', 121), CONVERT(DATETIME, '2016-07-23 00:00:00.000', 121), CONVERT(DATETIME, '2026-01-23 00:00:00.000', 121), NULL, NULL, N'giá thuê năm đầu 152tr/tháng. Mỗi năm tăng 5%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.040', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000011', NULL, 12, CONVERT(DATETIME, '2017-07-23 00:00:00.000', 121), 18, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5%', CONVERT(DATETIME, '2016-07-23 00:00:00.000', 121), NULL, NULL),

('BCR000000000101', N'10/2019/HĐTN.NTS - Ngày 10/12/2019', N'Nguyễn Thái Sơn ', 'DT', NULL, NULL, NULL, 62700000, NULL, NULL, 277800000, 0, 57000000, 62700000, 5, 5700000, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-11-18 00:00:00.000', 121), CONVERT(DATETIME, '2009-12-25 00:00:00.000', 121), CONVERT(DATETIME, '2024-12-24 00:00:00.000', 121), NULL, NULL, N'Gía thuê được giữ cố định trong vòng 03 năm đầu, 02 năm tiếp theo giá thuê tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.043', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000018', NULL, 36, CONVERT(DATETIME, '2012-12-25 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 180, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2009-12-25 00:00:00.000', 121), NULL, NULL),

('BCR000000000102', N'12/09/HĐTN - Ngày 28/08/2009; 05/PLHĐ.HCM.16 - Ngày 01/12/2016

Số 0511/2021/HĐTN.HCM', N'Nguyễn Sơn ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 149028000, 0, 54545455, 60000000, 5, 5454545, 9, '3', N'', N'0', CONVERT(DATETIME, '2009-08-28 00:00:00.000', 121), CONVERT(DATETIME, '2009-11-30 00:00:00.000', 121), CONVERT(DATETIME, '2026-11-30 00:00:00.000', 121), NULL, NULL, N'giá thuê mỗi năm tăng 5tr', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.043', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000016', NULL, 12, CONVERT(DATETIME, '2010-11-30 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 204, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5tr', CONVERT(DATETIME, '2009-11-30 00:00:00.000', 121), NULL, NULL),

('BCR000000000103', N'2020/HĐTN ', N'Lê Trọng Tấn ', 'DT', NULL, NULL, NULL, 105000000, NULL, NULL, 630000000, 0, 95454546, 105000000, 5, 9545454, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-08-11 00:00:00.000', 121), CONVERT(DATETIME, '2020-08-15 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-14 00:00:00.000', 121), NULL, NULL, N'Gía thuê giữ cố định trong 2 năm đầu, mỗi năm tiếp theo tăng không quá 5%

Gía thuê áp dụng từ ngày 15/09/2023 đến 14/09/2024: 110.250.000/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.043', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000022', NULL, 24, CONVERT(DATETIME, '2022-08-15 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng không quá 5%', CONVERT(DATETIME, '2020-08-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000115', N'2311/HĐTN-VBHCM ', N'Hàng Xanh ', 'DT', NULL, NULL, NULL, 60000000, NULL, NULL, 150000000, 0, 54545455, 60000000, 5, 5454545, 9, '3', N'', N'0', CONVERT(DATETIME, '2015-11-25 00:00:00.000', 121), CONVERT(DATETIME, '2015-11-23 00:00:00.000', 121), CONVERT(DATETIME, '2026-11-24 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định trong suốt 0 1năm gia hạn , 02 năm cuối tăng 65,000,000 đồng/tháng', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.057', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000030', NULL, 36, CONVERT(DATETIME, '2018-11-23 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 132, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 5tr', CONVERT(DATETIME, '2015-11-23 00:00:00.000', 121), NULL, NULL),

('BCR000000000116', N'07/2018/HĐTN.HCM', N'Đinh Tiên Hoàng ', 'DT', NULL, NULL, NULL, 90000000, NULL, NULL, 265999500, 0, 81818182, 90000000, 5, 8181818, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-07-23 00:00:00.000', 121), CONVERT(DATETIME, '2018-07-23 00:00:00.000', 121), CONVERT(DATETIME, '2028-07-22 00:00:00.000', 121), NULL, NULL, N'Gía thuê được giữ cố định trong 04 năm đầu, giá thuê 04 năm tiếp theo tăng/ giảm 10%.  Giá thuê 02 năm còn lại tăng/ giảm 10%. ', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.057', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000108', NULL, 48, CONVERT(DATETIME, '2022-07-23 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2018-07-23 00:00:00.000', 121), NULL, NULL),

('BCR000000000117', N'0802/2018/HĐTN.HCM', N'PGD Bình Tân (3 tháng 2) + TTĐT', 'DT', NULL, NULL, NULL, 110000000, NULL, NULL, 210000000, 0, 100000000, 110000000, 5, 10000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-08-02 00:00:00.000', 121), CONVERT(DATETIME, '2018-08-02 00:00:00.000', 121), CONVERT(DATETIME, '2024-09-30 00:00:00.000', 121), NULL, NULL, N'giá thuê được giữ cố định 02 năm đầu, mỗi 02 năm điều chỉnh tăng/giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.060', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 24, CONVERT(DATETIME, '2020-08-02 00:00:00.000', 121), 0, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 73, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/giảm 10%', CONVERT(DATETIME, '2018-08-02 00:00:00.000', 121), NULL, NULL),

('BCR000000000118', N'2207/2021HĐTN.HCM; 2208/2021HĐTN.HCM', N'PGD Trần Hưng Đạo', 'DT', NULL, NULL, NULL, 150000000, NULL, NULL, 262980000, 0, 136363637, 150000000, 5, 13636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-08-24 00:00:00.000', 121), CONVERT(DATETIME, '2010-11-01 00:00:00.000', 121), CONVERT(DATETIME, '2026-05-31 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.060', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000096', NULL, 24, CONVERT(DATETIME, '2012-11-01 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 186, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2010-11-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000119', N'01-2022/HĐTN/3B-VB', N'PGD Tân Qúy ', 'DT', NULL, NULL, NULL, 71500000, NULL, NULL, 780000000, 0, 65000000, 71500000, 5, 6500000, 9, '6', N'', N'0', CONVERT(DATETIME, '2022-07-08 00:00:00.000', 121), CONVERT(DATETIME, '2022-07-31 00:00:00.000', 121), CONVERT(DATETIME, '2027-07-31 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giữ cố định trong 2 năm đầu.

Các năm còn lại tăng 10% so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.060', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000099', NULL, 24, CONVERT(DATETIME, '2024-07-31 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2022-07-31 00:00:00.000', 121), NULL, NULL),

('BCR000000000120', N'01.06/HĐTN-VBHCM.15', N'PGD Bàu Cát', 'DT', NULL, NULL, NULL, 372680000, NULL, NULL, 495000000, 0, 338800000, 372680000, 5, 33880000, 9, '3', N'', N'0', CONVERT(DATETIME, '2015-04-06 00:00:00.000', 121), CONVERT(DATETIME, '2016-06-04 00:00:00.000', 121), CONVERT(DATETIME, '2027-06-04 00:00:00.000', 121), NULL, NULL, N'Giá thuê được giữ cố định trong 1 năm đầu.

Các năm còn lại tăng 10% so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.060', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000097', NULL, 36, CONVERT(DATETIME, '2019-06-04 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 132, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2016-06-04 00:00:00.000', 121), NULL, NULL),

('BCR000000000121', N'22/10/HĐTN.HCM ', N'PGD Lũy Bán Bích', 'DT', NULL, NULL, NULL, 46000000, NULL, NULL, 136560000, 0, 41818182, 46000000, 5, 4181818, 9, '3', N'', N'0', CONVERT(DATETIME, '2010-10-25 00:00:00.000', 121), CONVERT(DATETIME, '2010-11-26 00:00:00.000', 121), CONVERT(DATETIME, '2024-11-26 00:00:00.000', 121), NULL, NULL, NULL, '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.063', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000098', NULL, 36, CONVERT(DATETIME, '2013-11-26 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 168, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'0', CONVERT(DATETIME, '2010-11-26 00:00:00.000', 121), NULL, NULL),

('BCR000000000122', N'057/2018/HĐTN.HCM', N'Chợ Lớn ', 'DT', NULL, NULL, NULL, 132000000, NULL, NULL, 320000000, 0, 120000000, 132000000, 5, 12000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2018-08-23 00:00:00.000', 121), CONVERT(DATETIME, '2018-08-23 00:00:00.000', 121), CONVERT(DATETIME, '2025-08-22 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 03 năm đầu, mỗi 02 tiếp theo tăng giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.063', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000100', NULL, 36, CONVERT(DATETIME, '2021-08-23 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/ giảm10%', CONVERT(DATETIME, '2018-08-23 00:00:00.000', 121), NULL, NULL),

('BCR000000000123', N'057/2018/HĐTN.HCM', N'Chợ Lớn ', 'DT', NULL, NULL, NULL, 67000000, NULL, NULL, 402000000, 0, 60909091, 67000000, 5, 6090909, 9, '12', N'', N'0', CONVERT(DATETIME, '2019-05-06 00:00:00.000', 121), CONVERT(DATETIME, '2019-06-10 00:00:00.000', 121), CONVERT(DATETIME, '2024-06-10 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 03 năm đầu, mỗi 02 tiếp theo tăng giảm 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.063', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000100', NULL, 36, CONVERT(DATETIME, '2022-06-10 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng/ giảm10%', CONVERT(DATETIME, '2019-06-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000124', N'1406/2018/HĐTN.HCM ', N'PGD Bình Trị Đông', 'DT', NULL, NULL, NULL, 40000000, NULL, NULL, 120000000, 0, 36363636, 40000000, 5, 3636364, 9, '3', N'', N'0', CONVERT(DATETIME, '2017-10-14 00:00:00.000', 121), CONVERT(DATETIME, '2010-12-01 00:00:00.000', 121), CONVERT(DATETIME, '2028-06-30 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố định 01 năm đầu gia hạn, mỗi 02 tiếp theo tăng giảm 4tr/tháng so với năm liền kề', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.067', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000104', NULL, 72, CONVERT(DATETIME, '2016-12-01 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 210, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, NULL, CONVERT(DATETIME, '2010-12-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000136', N'97/2019/HĐTN - Ngày 09/07/2020', N'CN Quảng Nam ', 'DT', NULL, NULL, NULL, 110000000, NULL, NULL, 660000000, 0, 100000000, 110000000, 5, 10000000, 9, '12', N'', N'0', CONVERT(DATETIME, '2020-07-09 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-10 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-10 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố điịnh 03 năm đầu, 02 năm còn lại tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.077', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000120', NULL, 36, CONVERT(DATETIME, '2023-09-10 00:00:00.000', 121), 60, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-09-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000137', N'0108/2020/HĐTN.BĐ - Ngày 01/08/2020', N'CN Bình Định ', 'DT', NULL, NULL, NULL, 99000000, NULL, NULL, 270000000, 0, 90000000, 99000000, 5, 9000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2020-08-01 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-10 00:00:00.000', 121), CONVERT(DATETIME, '2025-09-09 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố điịnh 03 năm đầu, 02 năm còn lại tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.080', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', 'BRN000000000122', NULL, 36, CONVERT(DATETIME, '2023-09-10 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-09-10 00:00:00.000', 121), NULL, NULL),

('BCR000000000138', N'Số 2801/2022/HĐTN.HCM', N'310B Điện Biên Phủ', 'DT', NULL, NULL, NULL, 165000000, NULL, NULL, 900000000, 0, 150000000, 165000000, 5, 15000000, 9, '6', N'', N'0', CONVERT(DATETIME, '2022-01-28 00:00:00.000', 121), CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), CONVERT(DATETIME, '2028-12-31 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 02 năm đầu. Mỗi một năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.080', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 24, CONVERT(DATETIME, '2024-01-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2022-01-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000139', N'1810/2021/HĐTN.HCM', N'284 Lý Thường Kiệt (ĐGTS)', 'DT', NULL, NULL, NULL, 77000000, NULL, NULL, 210000000, 0, 70000000, 77000000, 5, 7000000, 9, '3', N'', N'0', CONVERT(DATETIME, '2021-10-15 00:00:00.000', 121), CONVERT(DATETIME, '2021-10-15 00:00:00.000', 121), CONVERT(DATETIME, '2028-10-14 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 02 năm đầu. Mỗi một năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.080', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 24, CONVERT(DATETIME, '2023-10-15 00:00:00.000', 121), 45, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2021-10-15 00:00:00.000', 121), NULL, NULL),

('BCR000000000140', N'MB.06_HĐTN', N'TRUNG TÂM ĐÀO TẠO (phần mở rộng)', 'DT', NULL, NULL, NULL, 220000000, NULL, NULL, 450000000, 0, 200000000, 220000000, 5, 20000000, 9, NULL, N'', N'0', CONVERT(DATETIME, '2022-06-17 00:00:00.000', 121), CONVERT(DATETIME, '2022-11-01 00:00:00.000', 121), CONVERT(DATETIME, '2029-10-31 00:00:00.000', 121), NULL, NULL, N'giá thuê cố định 02 năm đầu. Mỗi một năm tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.080', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 24, CONVERT(DATETIME, '2024-11-01 00:00:00.000', 121), 30, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2022-11-01 00:00:00.000', 121), NULL, NULL),

('BCR000000000141', N'HĐTN ngày 18/02/2020', N'Lim II ', 'DT', NULL, NULL, NULL, 2682583150, NULL, NULL, 22000000000, 0, 2438711957, 2682583150, 5, 243871193, 9, NULL, N'', N'0', CONVERT(DATETIME, '2015-09-01 00:00:00.000', 121), CONVERT(DATETIME, '2020-09-02 00:00:00.000', 121), CONVERT(DATETIME, '2026-09-01 00:00:00.000', 121), NULL, NULL, N'giá thuê giữ cố  định 01 năm đầu, 02 năm cuối tăng 10%', '1', 'thaohtt1', CONVERT(DATETIME, '2023-07-31 11:15:22.083', 121), 'A', NULL, 'admin', CONVERT(DATETIME, '2023-07-28 00:00:00.000', 121), NULL, NULL, 'Y', NULL, 'GG', NULL, NULL, 36, CONVERT(DATETIME, '2023-09-02 00:00:00.000', 121), 90, 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RATE', 'UP', 0, 5, NULL, NULL, 'N', NULL, N'tăng 10%', CONVERT(DATETIME, '2020-09-02 00:00:00.000', 121), NULL, NULL)

UPDATE SYS_CODEMASTERS SET CurValue = 142 WHERE Prefix = 'BCR'

UPDATE BUD_CONTRACT_RENT SET AUTH_STATUS = 'U', IS_SEND_APPR = 'Y'