営業時間変更のお知らせ
新型コロナウイルスの感染拡大防止の観点から、お客様ならびに従業員の健康と安全のため、営業時間の変更・臨時休業がございますので、お知らせ致します。
営業時間の変更 10:00～18:00
お客様及び関係者の皆様にはご不便、ご迷惑おかけいたしますが、何卒ご理解を賜りますようお願い申し上げます。
東京都狛江市にある「コマエカフェ不動産」は、カフェを併設している不動産屋さんです。
敷居が高くて入りづらいという不動産屋さんのイメージからの脱却をコンセプトに、カフェという誰もが気軽に立ち寄り、相談できる空間でお待ちしています。
お茶を飲みながらゆったりと、お住まい探しをしませんか？
-
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 '2022/07/01' <= 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 '2022/07/01' <= 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 '2022/07/01' <= 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 '2022/07/01' <= 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 '2022/07/01' <= 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 '2022/07/01' <= date2
AND draft_flg != 1 AND del_flg != 1
) union_data
order by id_code desc
limit 4;
-
売買
狛江市中和泉5丁目 新築戸建て 3号棟
価格：5,980万円
京王線 国領駅 徒歩17分
間取り：3SLDK -
売買
狛江市中和泉5丁目 新築戸建て 2号棟
価格：6,380万円
京王線 国領駅 徒歩17分
間取り：3SLDK -
売買
狛江市中和泉5丁目 新築戸建て 1号棟
価格：5,780万円
京王線 国領駅 徒歩17分
間取り：3SLDK -
売買
狛江市中和泉3丁目 新築戸建て 2号棟
価格：5,380万円
京王線 国領駅 徒歩14分
間取り：2SLDK
Array ( [0] => Array ( [id_code] => 1654273556 [0] => 1654273556 [property_id] => 060303 [1] => 060303 [property_name] => 狛江市中和泉5丁目 新築戸建て 3号棟 [2] => 狛江市中和泉5丁目 新築戸建て 3号棟 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 24001 [5] => 24001 [station_code1] => 2400116 [6] => 2400116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 17 [11] => 17 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 59800000 [14] => 59800000 [room_arrangement_code] => 1500384104 [15] => 1500384104 [property_type_code] => 8 [16] => 8 [image1] => 1654273556_1.jpg [17] => 1654273556_1.jpg [tablename] => property [18] => property ) [1] => Array ( [id_code] => 1654270935 [0] => 1654270935 [property_id] => 060302 [1] => 060302 [property_name] => 狛江市中和泉5丁目 新築戸建て 2号棟 [2] => 狛江市中和泉5丁目 新築戸建て 2号棟 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 24001 [5] => 24001 [station_code1] => 2400116 [6] => 2400116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 17 [11] => 17 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 63800000 [14] => 63800000 [room_arrangement_code] => 1500384104 [15] => 1500384104 [property_type_code] => 8 [16] => 8 [image1] => 1654270935_1.jpg [17] => 1654270935_1.jpg [tablename] => property [18] => property ) [2] => Array ( [id_code] => 1654248523 [0] => 1654248523 [property_id] => 060301 [1] => 060301 [property_name] => 狛江市中和泉5丁目 新築戸建て 1号棟 [2] => 狛江市中和泉5丁目 新築戸建て 1号棟 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 24001 [5] => 24001 [station_code1] => 2400116 [6] => 2400116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 17 [11] => 17 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 57800000 [14] => 57800000 [room_arrangement_code] => 1500384104 [15] => 1500384104 [property_type_code] => 8 [16] => 8 [image1] => 1654248523_1.jpg [17] => 1654248523_1.jpg [tablename] => property [18] => property ) [3] => Array ( [id_code] => 1654211425 [0] => 1654211425 [property_id] => 060202 [1] => 060202 [property_name] => 狛江市中和泉3丁目 新築戸建て 2号棟 [2] => 狛江市中和泉3丁目 新築戸建て 2号棟 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 24001 [5] => 24001 [station_code1] => 2400116 [6] => 2400116 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 14 [11] => 14 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 53800000 [14] => 53800000 [room_arrangement_code] => 1500384069 [15] => 1500384069 [property_type_code] => 8 [16] => 8 [image1] => 1654211425_1.jpg [17] => 1654211425_1.jpg [tablename] => property [18] => property ) )
