物件一覧
id IS NOT NULL and id != 0 and price IS NOT NULL and price !=0 and (members IS NULL or members=0) and (status=1 or status=2 or status=3) and own_company=2 and (del IS NULL or del=0) and (property=4 or property=5) and property_sub=1 and (main_traffic_line_id=6 and main_traffic_station_id=34 or sub_traffic1_line_id=6 and sub_traffic1_station_id=34 or sub_traffic2_line_id=6 and sub_traffic2_station_id=34)
阪急宝塚線「清荒神」駅の新築一戸建てをさがすid IS NOT NULL and id != 0 and price IS NOT NULL and price !=0 and (members IS NULL or members=0) and (status=1 or status=2 or status=3) and own_company=2 and (del IS NULL or del=0) and (property=4 or property=5) and property_sub=1 and (main_traffic_line_id=6 and main_traffic_station_id=34 or sub_traffic1_line_id=6 and sub_traffic1_station_id=34 or sub_traffic2_line_id=6 and sub_traffic2_station_id=34)
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
宝塚市小浜3丁目新築戸建
3,680万円
more
- 宝塚市小浜
- 兵庫県
- 阪急宝塚線「清荒神」駅徒歩17分
-
階・間取／3階建・4LDK
建物・土地／122.68m²・63.79m²
築年月／2024年5月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
宝塚市売布ガ丘新築戸建 2号地
6,980万円
more
- 宝塚市売布ガ丘
- 兵庫県
- 阪急宝塚線「売布神社」駅徒歩9分
-
階・間取／2階建・3LDK
建物・土地／126.69m²・185.18m²
築年月／-
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
宝塚市売布ガ丘新築戸建 1号地
6,980万円
more
- 宝塚市売布ガ丘
- 兵庫県
- 阪急宝塚線「売布神社」駅徒歩9分
-
階・間取／2階建・3LDK
建物・土地／126.69m²・185.43m²
築年月／-
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
宝塚市清荒神2丁目新築戸建 1号地
9,480万円
more
- 宝塚市清荒神
- 兵庫県
- 阪急宝塚線「清荒神」駅徒歩7分
-
階・間取／2階建・4LDK
建物・土地／168.55m²・281.62m²
築年月／-
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
宝塚市清荒神２丁目新築戸建 2号地
9,480万円
more
- 宝塚市清荒神
- 兵庫県
- 阪急宝塚線「清荒神」駅徒歩7分
-
階・間取／2階建・4LDK
建物・土地／176.93m²・214.01m²
築年月／-
