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

カフェで会話する男女

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

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

News

ホームページをリニューアル致しました。

この度、当社のホームページをリニューアル致しました。

物件登録については、システムの都合上7月1日より開始をさせていただきます。

これからどんどん充実させていきますので、今後ともコマエカフェ並びにコマエカフェ不動産をよろしくお願い致します。

おすすめ売買物件

More
    sql .. select * from ( select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 UNION select id_code, property_id, 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 draft_flg != 1 AND del_flg != 1 ) union_data order by id_code desc limit 4;
    Array ( [0] => Array ( [id_code] => 1498856421 [0] => 1498856421 [property_id] => 112 [1] => 112 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 24001 [4] => 24001 [station_code1] => 2400116 [5] => 2400116 [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 13 [10] => 13 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 39800000 [13] => 39800000 [room_arrangement_code] => 1 [14] => 1 [property_type_code] => 7 [15] => 7 [image1] => 1498856421_1.jpg [16] => 1498856421_1.jpg [tablename] => s_mansion [17] => s_mansion ) [1] => Array ( [id_code] => 1498853703 [0] => 1498853703 [property_id] => 111 [1] => 111 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 5 [10] => 5 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 30900000 [13] => 30900000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 7 [15] => 7 [image1] => 1498853703_1.jpg [16] => 1498853703_1.jpg [tablename] => s_mansion [17] => s_mansion ) [2] => Array ( [id_code] => 1498585503 [0] => 1498585503 [property_id] => 0003 [1] => 0003 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => 11303 [6] => 11303 [station_code2] => 1130314 [7] => 1130314 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 13 [10] => 13 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 52800000 [13] => 52800000 [room_arrangement_code] => 11 [14] => 11 [property_type_code] => 8 [15] => 8 [image1] => 1498585503_1.jpg [16] => 1498585503_1.jpg [tablename] => property [17] => property ) [3] => Array ( [id_code] => 1496555753 [0] => 1496555753 [property_id] => 0001 [1] => 0001 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 21 [10] => 21 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 39800000 [13] => 39800000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 8 [15] => 8 [image1] => 1496555753_1.jpg [16] => 1496555753_1.jpg [tablename] => property [17] => property ) )
  • 売買

    価格:3,980万円
    京王線 国領駅 徒歩13分
    間取り:ワンルーム

  • 売買

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

  • 売買

    価格:5,280万円
    小田急線 狛江駅 徒歩13分 , JR南武線 登戸駅
    間取り:4LDK

  • 売買

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

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

komae cafe

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

PAGE TOP