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

カフェで会話する男女

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

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

News

新聞折込チラシを実施

狛江市内に新聞折込チラシを実施しております。

イベントの内容やカフェの新メニューなど記事にしております。

お得なクーポン券もついていますので是非ご来店ください。

 

おすすめ売買物件

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] => 1511022061 [0] => 1511022061 [property_id] => 17111804 [1] => 17111804 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => 25001 [6] => 25001 [station_code2] => 2500115 [7] => 2500115 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 9 [10] => 9 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 22800000 [13] => 22800000 [room_arrangement_code] => 1500384069 [14] => 1500384069 [property_type_code] => 7 [15] => 7 [image1] => 1511022061_1.jpg [16] => 1511022061_1.jpg [tablename] => s_mansion [17] => s_mansion ) [1] => Array ( [id_code] => 1510997603 [0] => 1510997603 [property_id] => 17111803 [1] => 17111803 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => 24001 [6] => 24001 [station_code2] => 2400115 [7] => 2400115 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 24 [10] => 24 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 45800000 [13] => 45800000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 8 [15] => 8 [image1] => 1510997603_1.jpg [16] => 1510997603_1.jpg [tablename] => property [17] => property ) [2] => Array ( [id_code] => 1510995880 [0] => 1510995880 [property_id] => 17111802 [1] => 17111802 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500116 [5] => 2500116 [line_code2] => 25001 [6] => 25001 [station_code2] => 2500117 [7] => 2500117 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 9 [10] => 9 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 54800000 [13] => 54800000 [room_arrangement_code] => 11 [14] => 11 [property_type_code] => 8 [15] => 8 [image1] => 1510995880_1.jpg [16] => 1510995880_1.jpg [tablename] => property [17] => property ) [3] => Array ( [id_code] => 1510993594 [0] => 1510993594 [property_id] => 17111801 [1] => 17111801 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 24001 [4] => 24001 [station_code1] => 2400116 [5] => 2400116 [line_code2] => 25001 [6] => 25001 [station_code2] => 2500116 [7] => 2500116 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 17 [10] => 17 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 59800000 [13] => 59800000 [room_arrangement_code] => 1500384275 [14] => 1500384275 [property_type_code] => 8 [15] => 8 [image1] => 1510993594_1.jpg [16] => 1510993594_1.jpg [tablename] => property [17] => property ) )
  • 売買

    価格:2,280万円
    小田急線 狛江駅 徒歩9分 , 小田急線 喜多見駅
    間取り:2SLDK

  • 売買

    価格:4,580万円
    小田急線 狛江駅 徒歩24分 , 京王線 柴崎駅
    間取り:3LDK

  • 売買

    価格:5,480万円
    小田急線 狛江駅 徒歩9分 , 小田急線 和泉多摩川駅
    間取り:4LDK

  • 売買

    価格:5,980万円
    京王線 国領駅 徒歩17分 , 小田急線 狛江駅
    間取り:5LDK

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

komae cafe

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

PAGE TOP