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

カフェで会話する男女

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

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

News

新聞折込チラシにて新春フェア実施のお知らせ

あけましておめでとうございます。1月5日の新聞折込チラシにて新春フェアをご案内しております。

売買のご成約の方に、4Kの40インチ液晶テレビをもれなくプレゼントしております。

是非この機会にコマエカフェ不動産をご利用ください。

おすすめ売買物件

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] => 1515952817 [0] => 1515952817 [property_id] => 18011403 [1] => 18011403 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => [5] => [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 9 [10] => 9 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 44800000 [13] => 44800000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 8 [15] => 8 [image1] => 1515952817_1.jpg [16] => 1515952817_1.jpg [tablename] => property [17] => property ) [1] => Array ( [id_code] => 1515949217 [0] => 1515949217 [property_id] => 18011402 [1] => 18011402 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => [5] => [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 17 [10] => 17 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 58800000 [13] => 58800000 [room_arrangement_code] => 1500384275 [14] => 1500384275 [property_type_code] => 8 [15] => 8 [image1] => 1515949217_1.jpg [16] => 1515949217_1.jpg [tablename] => property [17] => property ) [2] => Array ( [id_code] => 1515944334 [0] => 1515944334 [property_id] => 18011401 [1] => 18011401 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => [5] => [line_code2] => [6] => [station_code2] => [7] => [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 12 [10] => 12 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 45300000 [13] => 45300000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 8 [15] => 8 [image1] => 1515944334_1.jpg [16] => 1515944334_1.jpg [tablename] => property [17] => property ) [3] => Array ( [id_code] => 1515489461 [0] => 1515489461 [property_id] => 18010901 [1] => 18010901 [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] => 39800000 [13] => 39800000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => [15] => [image1] => 1515489461_1.jpg [16] => 1515489461_1.jpg [tablename] => s_mansion [17] => s_mansion ) )
  • 売買

    価格:4,480万円
    小田急線駅 徒歩9分
    間取り:3LDK

  • 売買

    価格:5,880万円
    小田急線駅 徒歩17分
    間取り:5LDK

  • 売買

    価格:4,530万円
    小田急線駅 徒歩12分
    間取り:3LDK

  • 売買

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

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

komae cafe

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

PAGE TOP