대표번호

1522-4773

렌트신청

장기렌트 추천차량

    select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo on car.car_seq = photo.car_seq where rent_type = '신차장기' and use_flag = 1 and delete_flag = 0 order by reg_date desc LIMIT 0,8

단기렌트 가능차량

    select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo on car.car_seq = photo.car_seq where rent_type = '단기' and use_flag = 1 and delete_flag = 0 order by reg_date desc LIMIT 0,8

사고대차대량

    select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo on car.car_seq = photo.car_seq where rent_type = '보험사고' and use_flag = 1 and delete_flag = 0 order by reg_date desc LIMIT 0,8