全国賃貸住宅新聞に掲載されました
2019年11月18日号の全国賃貸住宅新聞にコマエカフェ不動産の記事が掲載されています。
詳しくは、下記PDFよりご確認ください。
東京都狛江市にある「コマエカフェ不動産」は、カフェを併設している不動産屋さんです。
敷居が高くて入りづらいという不動産屋さんのイメージからの脱却をコンセプトに、カフェという誰もが気軽に立ち寄り、相談できる空間でお待ちしています。
お茶を飲みながらゆったりと、お住まい探しをしませんか？
-
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 '2021/05/11' <= 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 '2021/05/11' <= 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 '2021/05/11' <= 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 '2021/05/11' <= 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 '2021/05/11' <= 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 '2021/05/11' <= date2
AND draft_flg != 1 AND del_flg != 1
) union_data
order by id_code desc
limit 4;
-
売買
ワコー喜多見マンション ４階
価格：2,680万円
小田急線 喜多見駅 徒歩8分 , 小田急線 狛江駅
間取り：2DK -
売買
狛江コーポラス 3階
価格：1,999万円
小田急線 喜多見駅 徒歩9分
間取り：2LDK -
売買
ワコーレ狛江ガーデン 2階
価格：3,198万円
小田急線 狛江駅 徒歩8分
間取り：3LDK -
売買
サンヴェール調布柴崎 ４階
価格：4,499万円
京王線 柴崎駅 徒歩12分
間取り：3LDK
Array ( [0] => Array ( [id_code] => 1618584935 [0] => 1618584935 [property_id] => 041952 [1] => 041952 [property_name] => ワコー喜多見マンション ４階 [2] => ワコー喜多見マンション ４階 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 25001 [5] => 25001 [station_code1] => 2500115 [6] => 2500115 [line_code2] => 25001 [7] => 25001 [station_code2] => 2500116 [8] => 2500116 [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 8 [11] => 8 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 26800000 [14] => 26800000 [room_arrangement_code] => 6 [15] => 6 [property_type_code] => 7 [16] => 7 [image1] => 1618584935_1.jpg [17] => 1618584935_1.jpg [tablename] => s_mansion [18] => s_mansion ) [1] => Array ( [id_code] => 1618584085 [0] => 1618584085 [property_id] => 041653 [1] => 041653 [property_name] => 狛江コーポラス 3階 [2] => 狛江コーポラス 3階 [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] => 9 [11] => 9 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 19990000 [14] => 19990000 [room_arrangement_code] => 7 [15] => 7 [property_type_code] => 7 [16] => 7 [image1] => 1618584085_1.jpg [17] => 1618584085_1.jpg [tablename] => s_mansion [18] => s_mansion ) [2] => Array ( [id_code] => 1618583579 [0] => 1618583579 [property_id] => 041652 [1] => 041652 [property_name] => ワコーレ狛江ガーデン 2階 [2] => ワコーレ狛江ガーデン 2階 [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] => 8 [11] => 8 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 31980000 [14] => 31980000 [room_arrangement_code] => 9 [15] => 9 [property_type_code] => 7 [16] => 7 [image1] => 1618583579_1.jpg [17] => 1618583579_1.jpg [tablename] => s_mansion [18] => s_mansion ) [3] => Array ( [id_code] => 1618582910 [0] => 1618582910 [property_id] => 041651 [1] => 041651 [property_name] => サンヴェール調布柴崎 ４階 [2] => サンヴェール調布柴崎 ４階 [recommendation_flg] => 1 [3] => 1 [station_name] => [4] => [line_code1] => 24001 [5] => 24001 [station_code1] => 2400115 [6] => 2400115 [line_code2] => [7] => [station_code2] => [8] => [line_code3] => [9] => [station_code3] => [10] => [traffic_minute] => 12 [11] => 12 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 44990000 [14] => 44990000 [room_arrangement_code] => 9 [15] => 9 [property_type_code] => 7 [16] => 7 [image1] => 1618582910_1.jpg [17] => 1618582910_1.jpg [tablename] => s_mansion [18] => s_mansion ) )
