カフェでくつろぎながら物件探し

カフェで会話する男女

東京都狛江市にある「コマエカフェ不動産」は、カフェを併設している不動産屋さんです。
敷居が高くて入りづらいという不動産屋さんのイメージからの脱却をコンセプトに、カフェという誰もが気軽に立ち寄り、相談できる空間でお待ちしています。

お茶を飲みながらゆったりと、お住まい探しをしませんか?

News

コマエカフェ不動産公式サイトが正式に完成です。

5月14日にコマエカフェ不動産サイトがグランドオープンしました。

おすすめ売買物件

More
    sql .. select * from ( select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, room_arrangement_code, property_type_code, image1, 'property' as tablename from property where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, '' as room_arrangement_code, '' as property_type_code, image1, 's_land' as tablename from s_land where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, room_arrangement_code, property_type_code, image1, 's_mansion' as tablename from s_mansion where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, room_arrangement_code, property_type_code, image1, 'r_kodate' as tablename from r_kodate where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, room_arrangement_code, property_type_code, image1, 'r_mansion' as tablename from r_mansion where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, property_name, recommendation_flg, station_name, line_code1, station_code1, line_code2, station_code2, line_code3, station_code3, traffic_minute, traffic_text, new_flg, charge, room_arrangement_code, property_type_code, image1, 'r_store' as tablename from r_store where recommendation_flg = 1 AND '2018/05/28' <= date2 AND draft_flg != 1 AND del_flg != 1 ) union_data order by id_code desc limit 4;
    Array ( [0] => Array ( [id_code] => 1527224901 [0] => 1527224901 [property_id] => 052457 [1] => 052457 [property_name] => 狛江リリエンハイム807号室 [2] => 狛江リリエンハイム807号室 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 25001 [5] => 25001 [station_code1] => 2500116 [6] => 2500116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 5 [11] => 5 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 34990000 [14] => 34990000 [room_arrangement_code] => 9 [15] => 9 [property_type_code] => 7 [16] => 7 [image1] => 1527224901_1.jpg [17] => 1527224901_1.jpg [tablename] => s_mansion [18] => s_mansion ) [1] => Array ( [id_code] => 1527213391 [0] => 1527213391 [property_id] => 052458 [1] => 052458 [property_name] => 狛江ハイタウン3号棟 512 [2] => 狛江ハイタウン3号棟 512 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 25001 [5] => 25001 [station_code1] => 2500115 [6] => 2500115 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 16 [11] => 16 [traffic_text] => 京王線つつじヶ丘駅バス8分「小足立橋」バス停徒歩1分 [12] => 京王線つつじヶ丘駅バス8分「小足立橋」バス停徒歩1分 [new_flg] => 1 [13] => 1 [charge] => 24800000 [14] => 24800000 [room_arrangement_code] => 9 [15] => 9 [property_type_code] => 7 [16] => 7 [image1] => 1527213391_1.jpg [17] => 1527213391_1.jpg [tablename] => s_mansion [18] => s_mansion ) [2] => Array ( [id_code] => 1527191630 [0] => 1527191630 [property_id] => 052305 [1] => 052305 [property_name] => 狛江市中和泉3丁目新築戸建て [2] => 狛江市中和泉3丁目新築戸建て [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 25001 [5] => 25001 [station_code1] => 2500116 [6] => 2500116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 15 [11] => 15 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 52800000 [14] => 52800000 [room_arrangement_code] => 11 [15] => 11 [property_type_code] => 8 [16] => 8 [image1] => 1527191630_1.jpg [17] => 1527191630_1.jpg [tablename] => property [18] => property ) [3] => Array ( [id_code] => 1527189172 [0] => 1527189172 [property_id] => 052304 [1] => 052304 [property_name] => 狛江市岩戸南4丁目新築戸建て [2] => 狛江市岩戸南4丁目新築戸建て [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 25001 [5] => 25001 [station_code1] => 2500116 [6] => 2500116 [line_code2] => 25001 [7] => 25001 [station_code2] => 2500115 [8] => 2500115 [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 23 [11] => 23 [traffic_text] => 狛江駅からバスで7分「こまえ苑」バス停下車徒歩2分 [12] => 狛江駅からバスで7分「こまえ苑」バス停下車徒歩2分 [new_flg] => 1 [13] => 1 [charge] => 45800000 [14] => 45800000 [room_arrangement_code] => 9 [15] => 9 [property_type_code] => 8 [16] => 8 [image1] => 1527189172_1.jpg [17] => 1527189172_1.jpg [tablename] => property [18] => property ) )
  • 売買

    狛江リリエンハイム807号室

    価格:3,499万円
    小田急線 狛江駅 徒歩5分
    間取り:3LDK

  • 売買

    狛江ハイタウン3号棟 512

    価格:2,480万円
    小田急線 喜多見駅 徒歩16分
    間取り:3LDK

  • 売買

    狛江市中和泉3丁目新築戸建て

    価格:5,280万円
    小田急線 狛江駅 徒歩15分
    間取り:4LDK

  • 売買

    狛江市岩戸南4丁目新築戸建て

    価格:4,580万円
    小田急線 狛江駅 徒歩23分 , 小田急線 喜多見駅
    間取り:3LDK

  • 購入の流れ
  • 売却の流れ
  • 賃貸の流れ
  • レンタルスタジオ
  • 会社案内
  • アクセス
  • 個人情報保護方針
  • お問い合わせ

komae cafe

ママに嬉しいお店は、みんなに嬉しいお店。
北欧風のカフェでほっこりタイム

PAGE TOP