ホーム
会員登録 
ログイン 
お問い合わせ 
アクセスランキング
新着０円物件
全国
の０円物件情報
31
件の検索結果
select `t_estates`.*, (select count(*) from `t_estate_applications` where `t_estates`.`id` = `t_estate_applications`.`estate_id` and `canceled_at` is null) as `estate_applicants_count` from `t_estates` where `is_draft` = and `public_at` <= '2025-07-20 00:02:45' and `type_auction` = 1 and `current_step` in (5) and `estate_category` in (1, 2, 0, 3) and (`land_status` in (0, 1, 2, 3, 4, 5, 6) or `land_status` is null) and `t_estates`.`deleted_at` is null order by `public_at` desc
