現在、情報を準備中です。
喜多見・狛江の不動産についてのご相談は「きたみ不動産」へ！
宅地建物取引士、行政書士、ファイナンシャルプランナー、電気工事士等の専門知識を有するスタッフが在籍しております。
売買、相続、賃貸、管理などについてお困りごとがございましたら、まずは当店へご相談ください。
-
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 '2025/11/18' <= 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 '2025/11/18' <= 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 '2025/11/18' <= 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 '2025/11/18' <= 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 '2025/11/18' <= 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 '2025/11/18' <= date2
AND draft_flg != 1 AND del_flg != 1
) union_data
order by id_code desc
limit 4;
-
売買
東海狛江マンション
価格：4,498万円
小田急線 狛江駅 徒歩4分
間取り：2LDK -
売買
狛江市東野川２丁目 新築戸建 B号棟
価格：7,190万円
小田急線 喜多見駅 徒歩20分
間取り：4LDK -
売買
狛江市東野川２丁目 新築戸建 A号棟
価格：6,590万円
小田急線 喜多見駅 徒歩20分
間取り：2LDK -
売買
狛江市中和泉4丁目 新築戸建 2号棟
価格：6,998万円
小田急線 狛江駅 徒歩18分
間取り：4LDK
Array ( [0] => Array ( [id_code] => 1763379385 [0] => 1763379385 [property_id] => 071105 [1] => 071105 [property_name] => 東海狛江マンション [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] => 4 [11] => 4 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 44980000 [14] => 44980000 [room_arrangement_code] => 7 [15] => 7 [property_type_code] => 7 [16] => 7 [image1] => 1763379385_1.jpg [17] => 1763379385_1.jpg [tablename] => s_mansion [18] => s_mansion ) [1] => Array ( [id_code] => 1762828375 [0] => 1762828375 [property_id] => 071104 [1] => 071104 [property_name] => 狛江市東野川２丁目 新築戸建 B号棟 [2] => 狛江市東野川２丁目 新築戸建 B号棟 [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] => 20 [11] => 20 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 71900000 [14] => 71900000 [room_arrangement_code] => 11 [15] => 11 [property_type_code] => 8 [16] => 8 [image1] => 1762828375_1.jpg [17] => 1762828375_1.jpg [tablename] => property [18] => property ) [2] => Array ( [id_code] => 1762814266 [0] => 1762814266 [property_id] => 071103 [1] => 071103 [property_name] => 狛江市東野川２丁目 新築戸建 A号棟 [2] => 狛江市東野川２丁目 新築戸建 A号棟 [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] => 20 [11] => 20 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 65900000 [14] => 65900000 [room_arrangement_code] => 7 [15] => 7 [property_type_code] => 8 [16] => 8 [image1] => 1762814266_1.jpg [17] => 1762814266_1.jpg [tablename] => property [18] => property ) [3] => Array ( [id_code] => 1762806527 [0] => 1762806527 [property_id] => 071102 [1] => 071102 [property_name] => 狛江市中和泉4丁目 新築戸建 2号棟 [2] => 狛江市中和泉4丁目 新築戸建 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] => 18 [11] => 18 [traffic_text] => [12] => [new_flg] => 1 [13] => 1 [charge] => 69980000 [14] => 69980000 [room_arrangement_code] => 11 [15] => 11 [property_type_code] => 8 [16] => 8 [image1] => 1762806527_1.jpg [17] => 1762806527_1.jpg [tablename] => property [18] => property ) )
