【小田急不動産×komaecafe不動産から新築マンション販売のお知らせ】
この度、komaecafe不動産は小田急不動産（株）と「リーフィアレジデンス狛江 和泉本町」の販売提携をいたしました。
狛江駅より、徒歩9分の新築マンションで狛江第一小学校からすぐの立地です。
建物完成済みのため、ご希望の室内をご内覧可能です。
気になっている方がいらっしゃいましたらお気軽に下記までお問合せください。
コマエカフェ不動産
03-5761-5605
東京都狛江市にある「komae café 不動産」は、カフェを併設している不動産屋さんです。
敷居が高くて入りづらいという不動産屋さんのイメージからの脱却をコンセプトに、カフェという誰もが気軽に立ち寄り、相談できる空間でお待ちしています。
お茶を飲みながらゆったりと、お住まい探しをしませんか？
-
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;
-
売買
価格：2,180万円
小田急線 狛江駅 徒歩5分
間取り：2LDK -
売買
価格：2,499万円
小田急線 狛江駅 徒歩8分 , 小田急線 喜多見駅
間取り：3LDK -
売買
価格：4,680万円
小田急線 和泉多摩川駅 徒歩15分 , 小田急線 狛江駅
間取り：4LDK -
売買
価格：5,380万円
小田急線 喜多見駅 徒歩17分 , 小田急線 狛江駅
間取り：4LDK
Array ( [0] => Array ( [id_code] => 1508443090 [0] => 1508443090 [property_id] => 17101901 [1] => 17101901 [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] => 21800000 [13] => 21800000 [room_arrangement_code] => 7 [14] => 7 [property_type_code] => 7 [15] => 7 [image1] => 1508443090_1.jpg [16] => 1508443090_1.jpg [tablename] => s_mansion [17] => s_mansion ) [1] => Array ( [id_code] => 1507826128 [0] => 1507826128 [property_id] => 171012 [1] => 171012 [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] => 8 [10] => 8 [traffic_text] => [11] => [new_flg] => 1 [12] => 1 [charge] => 24990000 [13] => 24990000 [room_arrangement_code] => 9 [14] => 9 [property_type_code] => 7 [15] => 7 [image1] => 1507826128_1.jpg [16] => 1507826128_1.jpg [tablename] => s_mansion [17] => s_mansion ) [2] => Array ( [id_code] => 1506665483 [0] => 1506665483 [property_id] => 1010014 [1] => 1010014 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500117 [5] => 2500117 [line_code2] => 25001 [6] => 25001 [station_code2] => 2500116 [7] => 2500116 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 15 [10] => 15 [traffic_text] => 小田急線「和泉多摩川」徒歩15分、狛江駅徒歩16分 [11] => 小田急線「和泉多摩川」徒歩15分、狛江駅徒歩16分 [new_flg] => 1 [12] => 1 [charge] => 46800000 [13] => 46800000 [room_arrangement_code] => 11 [14] => 11 [property_type_code] => 8 [15] => 8 [image1] => 1506665483_1.jpg [16] => 1506665483_1.jpg [tablename] => property [17] => property ) [3] => Array ( [id_code] => 1506594178 [0] => 1506594178 [property_id] => 101006 [1] => 101006 [recommendation_flg] => 1 [2] => 1 [station_name] => [3] => [line_code1] => 25001 [4] => 25001 [station_code1] => 2500115 [5] => 2500115 [line_code2] => 25001 [6] => 25001 [station_code2] => 2500116 [7] => 2500116 [line_code3] => [8] => [station_code3] => [9] => [traffic_minute] => 17 [10] => 17 [traffic_text] => 喜多見駅徒歩17分、狛江駅徒歩20分 [11] => 喜多見駅徒歩17分、狛江駅徒歩20分 [new_flg] => 1 [12] => 1 [charge] => 53800000 [13] => 53800000 [room_arrangement_code] => 11 [14] => 11 [property_type_code] => 8 [15] => 8 [image1] => 1506594178_1.jpg [16] => 1506594178_1.jpg [tablename] => property [17] => property ) )
