エレベーター有の中古マンションをさがす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 (mansion_id=11406273 or mansion_id=11406319 or mansion_id=11406350 or mansion_id=11406429 or mansion_id=11406430 or mansion_id=11406442 or mansion_id=11406447 or mansion_id=11406457 or mansion_id=11406490 or mansion_id=11406514 or mansion_id=11406533 or mansion_id=11406679 or mansion_id=11406681 or mansion_id=11406706 or mansion_id=11406708 or mansion_id=11406712 or mansion_id=11406717 or mansion_id=11406720 or mansion_id=11406764 or mansion_id=11406765 or mansion_id=11406811 or mansion_id=11406812 or mansion_id=11406841 or mansion_id=11406902 or mansion_id=11406917 or mansion_id=11406971 or mansion_id=11407005 or mansion_id=11407006 or mansion_id=11407065 or mansion_id=11407075 or mansion_id=11407095 or mansion_id=11407097 or mansion_id=11407102 or mansion_id=11407110 or mansion_id=11407128 or mansion_id=11407166 or mansion_id=11407173 or mansion_id=11407190 or mansion_id=11407235 or mansion_id=11407254 or mansion_id=11407263 or mansion_id=11407279 or mansion_id=11407299 or mansion_id=11407325 or mansion_id=11407353 or mansion_id=11407356 or mansion_id=11407365 or mansion_id=11407409 or mansion_id=11407430 or mansion_id=11407433 or mansion_id=11407458 or mansion_id=11407474 or mansion_id=11407476 or mansion_id=11407510 or mansion_id=11407516 or mansion_id=11407521 or mansion_id=11407533 or mansion_id=11407747 or mansion_id=11407829 or mansion_id=11407828 or mansion_id=11407883 or mansion_id=11407888 or mansion_id=11407890 or mansion_id=11407892 or mansion_id=11407894 or mansion_id=11407896 or mansion_id=11407898 or mansion_id=11407906 or mansion_id=11407950 or mansion_id=11407954 or mansion_id=11407958 or mansion_id=11407961 or mansion_id=11407978 or mansion_id=11407985 or mansion_id=11407999 or mansion_id=11408002 or mansion_id=11408011 or mansion_id=11408041 or mansion_id=11408050 or mansion_id=11408057 or mansion_id=11408058 or mansion_id=11408063 or mansion_id=11408070 or mansion_id=11408071 or mansion_id=11408074 or mansion_id=11408076 or mansion_id=11408077 or mansion_id=11408081 or mansion_id=11408086 or mansion_id=11408089 or mansion_id=11408094 or mansion_id=11408096 or mansion_id=11408101 or mansion_id=11408108 or mansion_id=11408115 or mansion_id=11408119 or mansion_id=11408123 or mansion_id=11408130 or mansion_id=11408133 or mansion_id=11408138 or mansion_id=11408140 or mansion_id=11408143 or mansion_id=11408148 or mansion_id=11408152 or mansion_id=11408164 or mansion_id=11408167 or mansion_id=11408182 or mansion_id=11408186 or mansion_id=11408192 or mansion_id=11408201 or mansion_id=11408216 or mansion_id=11408217 or mansion_id=11408221 or mansion_id=11408227 or mansion_id=11408231 or mansion_id=11408232 or mansion_id=11408245 or mansion_id=11408254 or mansion_id=11408257 or mansion_id=11408277 or mansion_id=11408279 or mansion_id=11408289 or mansion_id=11408293 or mansion_id=11408319 or mansion_id=11408321 or mansion_id=11408371 or mansion_id=11408376 or mansion_id=11408379 or mansion_id=11408380 or mansion_id=11408383 or mansion_id=11408386 or mansion_id=11408387 or mansion_id=11408389 or mansion_id=11408484 or mansion_id=11408756 or mansion_id=11408765 or mansion_id=11408769 or mansion_id=11408771 or mansion_id=11408777 or mansion_id=11408782 or mansion_id=11408783 or mansion_id=11408784 or mansion_id=11408792 or mansion_id=11408794 or mansion_id=11408796 or mansion_id=11408797 or mansion_id=11408800 or mansion_id=11408804 or mansion_id=11408820 or mansion_id=11408833 or mansion_id=11408837 or mansion_id=11408839 or mansion_id=11408841 or mansion_id=11408844 or mansion_id=11408872 or mansion_id=11408892 or mansion_id=11408919 or mansion_id=11408924 or mansion_id=11408955 or mansion_id=11408957 or mansion_id=11408959 or mansion_id=11408963 or mansion_id=11409059 or mansion_id=11409061 or mansion_id=11409063 or mansion_id=11409067 or mansion_id=11409180 or mansion_id=11409191 or mansion_id=11409198 or mansion_id=11409202 or mansion_id=11409208 or mansion_id=11409236 or mansion_id=11409238 or mansion_id=11409240 or mansion_id=11409267 or mansion_id=11409274 or mansion_id=11409276 or mansion_id=11409280 or mansion_id=11409282 or mansion_id=11409284 or mansion_id=11409328 or mansion_id=11409332 or mansion_id=11409334 or mansion_id=11409337 or mansion_id=11409372 or mansion_id=11409438 or mansion_id=11409440 or mansion_id=11409492 or mansion_id=11409496 or mansion_id=11409498 or mansion_id=11409499 or mansion_id=11409501 or mansion_id=11409503 or mansion_id=11409506 or mansion_id=11409510 or mansion_id=11409513 or mansion_id=11409515 or mansion_id=11409517 or mansion_id=11409519 or mansion_id=11409521 or mansion_id=11409523 or mansion_id=11409549 or mansion_id=11409550 or mansion_id=11409552 or mansion_id=11409555 or mansion_id=11409561 or mansion_id=11409637 or mansion_id=11409640 or mansion_id=11409735 or mansion_id=11409744 or mansion_id=11409767 or mansion_id=11409771 or mansion_id=11409785 or mansion_id=11409789 or mansion_id=11409791 or mansion_id=11409794 or mansion_id=11409808 or mansion_id=11409826 or mansion_id=11409828 or mansion_id=11409840 or mansion_id=11409846 or mansion_id=11409920 or mansion_id=11409922 or mansion_id=11409928 or mansion_id=11409929 or mansion_id=11410016 or mansion_id=11410021 or mansion_id=11410023 or mansion_id=11410151 or mansion_id=11410153 or mansion_id=11410225 or mansion_id=11410490 or mansion_id=11410493 or mansion_id=11410499 or mansion_id=11410505 or mansion_id=11410507 or mansion_id=11410518 or mansion_id=11410536 or mansion_id=11410538 or mansion_id=11410543 or mansion_id=11410550 or mansion_id=11410552 or mansion_id=11410554 or mansion_id=11410593 or mansion_id=11410617 or mansion_id=11410624 or mansion_id=11410626 or mansion_id=11410628 or mansion_id=11410630 or mansion_id=11410739 or mansion_id=11410921 or mansion_id=11410962 or mansion_id=11410968 or mansion_id=11410970 or mansion_id=11410977 or mansion_id=11410980 or mansion_id=11410982 or mansion_id=11410982 or mansion_id=11410984 or mansion_id=11410986 or mansion_id=11411075 or mansion_id=11411108 or mansion_id=11411111 or mansion_id=11411189 or mansion_id=11411212 or mansion_id=11411214 or mansion_id=11411216 or mansion_id=11411262 or mansion_id=11411264 or mansion_id=11411266 or mansion_id=11411275 or mansion_id=11411306 or mansion_id=11411315 or mansion_id=11411320 or mansion_id=11411422 or mansion_id=11411424 or mansion_id=11411534 or mansion_id=11411606 or mansion_id=11411624 or mansion_id=11411648 or mansion_id=11411710 or mansion_id=11411712 or mansion_id=11411719 or mansion_id=11411750 or mansion_id=11411755 or mansion_id=11411755 or mansion_id=11411768 or mansion_id=11411772 or mansion_id=11410982 or mansion_id=11411829 or mansion_id=11411831 or mansion_id=11411934 or mansion_id=11411938 or mansion_id=11411943 or mansion_id=11411944 or mansion_id=11412023 or mansion_id=11412034 or mansion_id=11412037 or mansion_id=11412039 or mansion_id=11412041 or mansion_id=11412101 or mansion_id=11412118 or mansion_id=11412122 or mansion_id=11412124 or mansion_id=11412160 or mansion_id=11412189 or mansion_id=11412191 or mansion_id=11412222 or mansion_id=11412228 or mansion_id=11412236 or mansion_id=11412282 or mansion_id=11412356 or mansion_id=11412367 or mansion_id=11412373 or mansion_id=11412384 or mansion_id=11412446 or mansion_id=11412449 or mansion_id=11412483 or mansion_id=11412489 or mansion_id=11412494 or mansion_id=11412498 or mansion_id=11412504 or mansion_id=11412508 or mansion_id=11412510 or mansion_id=11412537 or mansion_id=11412568 or mansion_id=11412568 or mansion_id=11412572 or mansion_id=11412578 or mansion_id=11412591 or mansion_id=11412591 or mansion_id=11412607 or mansion_id=11412612 or mansion_id=11412615 or mansion_id=11412617 or mansion_id=11412635 or mansion_id=11412640 or mansion_id=11412642 or mansion_id=11412591 or mansion_id=11412591 or mansion_id=11412591 or mansion_id=11412655 or mansion_id=11412663 or mansion_id=11412721 or mansion_id=11412741 or mansion_id=11412745 or mansion_id=11412814 or mansion_id=11412825 or mansion_id=11412832 or mansion_id=11412834 or mansion_id=11412854 or mansion_id=11412856 or mansion_id=11412861 or mansion_id=11412861 or mansion_id=11412863 or mansion_id=11412863 or mansion_id=11412867 or mansion_id=11412885 or mansion_id=11412891 or mansion_id=11412894 or mansion_id=11412896 or mansion_id=11412902 or mansion_id=11412906 or mansion_id=11412915 or mansion_id=11412919 or mansion_id=11412954 or mansion_id=11412957 or mansion_id=11412973 or mansion_id=11412976 or mansion_id=11412981 or mansion_id=11412983 or mansion_id=11412988 or mansion_id=11412989 or mansion_id=11412988 or mansion_id=11412992 or mansion_id=11412992 or mansion_id=11412998 or mansion_id=11412999 or mansion_id=11412999 or mansion_id=11413002 or mansion_id=11413005 or mansion_id=11413007 or mansion_id=11413027 or mansion_id=11413027 or mansion_id=11413029 or mansion_id=11413031 or mansion_id=11413034 or mansion_id=11413036 or mansion_id=11413038 or mansion_id=11413048 or mansion_id=11413059 or mansion_id=11413062 or mansion_id=11413062 or mansion_id=11413077 or mansion_id=11413078 or mansion_id=11413078 or mansion_id=11413081 or mansion_id=11413081 or mansion_id=11413160 or mansion_id=11413160 or mansion_id=11413196 or mansion_id=11413196 or mansion_id=11413196 or mansion_id=11413203 or mansion_id=11413203 or mansion_id=11413196 or mansion_id=11413203 or mansion_id=11406663 or mansion_id=11413459 or mansion_id=11413463 or mansion_id=11413465 or mansion_id=11413466 or mansion_id=11413469 or mansion_id=11413481 or mansion_id=11413483 or mansion_id=11413485 or mansion_id=11413487 or mansion_id=11413489 or mansion_id=11413495 or mansion_id=11413509 or mansion_id=11413514 or mansion_id=11413528 or mansion_id=11413773 or mansion_id=11413779 or mansion_id=11413781 or mansion_id=11413810 or mansion_id=11413830 or mansion_id=11413832 or mansion_id=11413834 or mansion_id=11407314 or mansion_id=11413846 or mansion_id=11406995 or mansion_id=11413869 or mansion_id=11413901 or mansion_id=11413914 or mansion_id=11414060 or mansion_id=11414064 or mansion_id=11414068 or mansion_id=11414071 or mansion_id=11414079 or mansion_id=11414081 or mansion_id=11414087 or mansion_id=11414097 or mansion_id=11414101 or mansion_id=11414107 or mansion_id=11406623 or mansion_id=11414232 or mansion_id=11414235 or mansion_id=11414237 or mansion_id=11414287 or mansion_id=11414309 or mansion_id=11414311 or mansion_id=11414381 or mansion_id=11414410 or mansion_id=11407125 or mansion_id=11414509 or mansion_id=11414513 or mansion_id=11414516 or mansion_id=11406504 or mansion_id=11407295 or mansion_id=11407316 or mansion_id=11407505 or mansion_id=11406437 or mansion_id=11406469 or mansion_id=11414585 or mansion_id=11414587 or mansion_id=11414588 or mansion_id=11414590 or mansion_id=11414595 or mansion_id=11414597 or mansion_id=11414633 or mansion_id=11414635 or mansion_id=11414637 or mansion_id=11414764 or mansion_id=11414785 or mansion_id=11406816 or mansion_id=11414862 or mansion_id=11414864 or mansion_id=11414866 or mansion_id=11406754 or mansion_id=11414883 or mansion_id=11414914 or mansion_id=11407039 or mansion_id=11414933 or mansion_id=11407214 or mansion_id=11414970 or mansion_id=11415021 or mansion_id=11406377 or mansion_id=11415104 or mansion_id=11415123 or mansion_id=11415176 or mansion_id=11415178 or mansion_id=11415296 or mansion_id=11415320 or mansion_id=11415341 or mansion_id=11415343 or mansion_id=11415384 or mansion_id=11415456 or mansion_id=11415521 or mansion_id=11415523 or mansion_id=11415558 or mansion_id=11415583 or mansion_id=11415759 or mansion_id=11415760 or mansion_id=11415789 or mansion_id=11415802 or mansion_id=11415891 or mansion_id=11415893 or mansion_id=11415929 or mansion_id=11416012 or mansion_id=11416014 or mansion_id=11416044 or mansion_id=11416073 or mansion_id=11416128 or mansion_id=11416187 or mansion_id=11416241 or mansion_id=11416253 or mansion_id=11416256 or mansion_id=11416266 or mansion_id=11416317 or mansion_id=11416319 or mansion_id=11416430 or mansion_id=11416458 or mansion_id=11416495 or mansion_id=11416583 or mansion_id=11407489 or mansion_id=11416686 or mansion_id=11416754 or mansion_id=11416816 or mansion_id=11416847 or mansion_id=11416849 or mansion_id=11416868 or mansion_id=11416921 or mansion_id=11416940 or mansion_id=11417022 or mansion_id=11417078 or mansion_id=11417098 or mansion_id=11417100 or mansion_id=11407461 or mansion_id=11417131 or mansion_id=11417260 or mansion_id=11417283 or mansion_id=11417292 or mansion_id=11417398 or mansion_id=11417502 or mansion_id=11417513 or mansion_id=11406650 or mansion_id=11417551 or mansion_id=11417633 or mansion_id=11417668 or mansion_id=11417725 or mansion_id=11406767 or mansion_id=11407406 or mansion_id=11406355 or mansion_id=11417794 or mansion_id=11406949 or mansion_id=11406911 or mansion_id=11417866 or mansion_id=11407215 or mansion_id=11417869 or mansion_id=11407484 or mansion_id=11407008 or mansion_id=11417935 or mansion_id=11407428 or mansion_id=11407192 or mansion_id=11417963 or mansion_id=11417965 or mansion_id=11406584 or mansion_id=11418010 or mansion_id=11406665 or mansion_id=11406734 or mansion_id=11418100 or mansion_id=11407245 or mansion_id=11418307 or mansion_id=11418333 or mansion_id=11406824 or mansion_id=11418405 or mansion_id=11406672 or mansion_id=11418536 or mansion_id=11406408 or mansion_id=11418589 or mansion_id=11418593 or mansion_id=11406728 or mansion_id=11418625 or mansion_id=11418718 or mansion_id=11418721 or mansion_id=11418953 or mansion_id=11418955 or mansion_id=11419047 or mansion_id=11419096 or mansion_id=11419207 or mansion_id=11419234 or mansion_id=11419338 or mansion_id=11419343 or mansion_id=11419446 or mansion_id=11407386 or mansion_id=11419475 or mansion_id=11419489 or mansion_id=11419537 or mansion_id=11419539 or mansion_id=11419541 or mansion_id=11419543 or mansion_id=11407244 or mansion_id=11419613 or mansion_id=11419642 or mansion_id=11419644 or mansion_id=11419735 or mansion_id=11419737 or mansion_id=11419791 or mansion_id=11419793 or mansion_id=11419863 or mansion_id=11419882)
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
甲子園リバーサイドハイツ
3,880万円
more
- 西宮市甲子園口北町
- 兵庫県
- JR東海道本線「甲子園口」駅徒歩5分
-
階・間取/4階/9階建・4LDK
専有面積/133.94m²
築年月/1970年2月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ネバーランド上甲子園
3,280万円
more
- 西宮市上甲子園
- 兵庫県
- 阪神本線「久寿川」駅徒歩12分
-
階・間取/6階/7階建・3LDK
専有面積/68.00m²
築年月/2002年11月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
夙川グリーンタウン
3,780万円
more
- 西宮市羽衣町
- 兵庫県
- 阪急電鉄神戸線「夙川」駅徒歩2分
-
階・間取/10階/17階建・2LDK
専有面積/68.79m²
築年月/1977年10月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ラ・ビスタ宝塚 ウエストウイング1番館
2,370万円
more
- 宝塚市すみれガ丘
- 兵庫県
- JR福知山線「宝塚」駅徒歩35分
-
階・間取/11階/15階建・3LDK
専有面積/97.51m²
築年月/1991年2月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ダイアパレス宝塚クオリテ―ジⅣ
3,480万円
more
- 宝塚市山本南
- 兵庫県
- 阪急宝塚線「山本」駅徒歩8分
-
階・間取/6階/7階建・4LDK
専有面積/83.87m²
築年月/1998年2月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
コート甲子園南1番館
3,090万円
more
- 西宮市今津巽町
- 兵庫県
- 阪神本線「久寿川」駅徒歩10分
-
階・間取/3階/11階建・3LDK
専有面積/61.64m²
築年月/1996年7月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ライオンズマンション甲子園口
3,480万円
more
- 西宮市甲子園口
- 兵庫県
- JR神戸線「甲子園口」駅徒歩4分
-
階・間取/4階/6階建・2LDK
専有面積/78.00m²
築年月/1981年5月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
パーク・ハイム夙川泉町
2,880万円
more
- 西宮市泉町
- 兵庫県
- 阪神本線「香櫨園」駅徒歩12分
-
階・間取/2階/7階建・3LDK
専有面積/113.98m²
築年月/1992年11月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
セレッソコート伊丹ガーデンシティ
2,980万円
more
- 伊丹市北河原
- 兵庫県
- JR福知山線「伊丹」駅徒歩14分
-
階・間取/9階/11階建・3LDK
専有面積/70.93m²
築年月/2007年11月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ディオ・フォルティ雲雀丘
2,780万円
more
- 宝塚市南ひばりガ丘
- 兵庫県
- 阪急宝塚線「山本」駅徒歩13分
-
階・間取/6階/13階建・3LDK
専有面積/71.92m²
築年月/1995年8月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ロイヤル西宮駅前
3,750万円
more
- 西宮市和上町
- 兵庫県
- 阪神電鉄本線「西宮」駅徒歩3分
-
階・間取/2階/10階建・3LDK
専有面積/64.00m²
築年月/2000年6月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
藤和シティホームズ西宮東町
3,190万円
more
- 西宮市東町
- 兵庫県
- 阪神電鉄本線「西宮」駅徒歩18分
-
階・間取/2階/13階建・3LDK
専有面積/67.64m²
築年月/1997年2月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
ステイツ苦楽園
3,680万円
more
- 西宮市神原
- 兵庫県
- 阪急電鉄甲陽線「苦楽園口」駅徒歩7分
-
階・間取/4階/7階建・3LDK
専有面積/75.35m²
築年月/2000年3月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
グラン・コート上甲子園
3,699万円
more
- 西宮市上甲子園
- 兵庫県
- 阪神本線「甲子園」駅徒歩15分
-
階・間取/7階/7階建・3LDK
専有面積/68.11m²
築年月/1997年7月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
パレ伊丹北2
1,380万円
more
- 伊丹市東野
- 兵庫県
- 阪急伊丹線「伊丹」駅バス11分「東野南」停歩4分
-
階・間取/2階/6階建・3LDK
専有面積/64.40m²
築年月/1994年6月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
リバーサイド香櫨園
2,050万円
more
- 西宮市川東町
- 兵庫県
- 阪神本線「香櫨園」駅徒歩5分
-
階・間取/2階/9階建・2DK
専有面積/43.75m²
築年月/1998年3月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
リバーサイド香櫨園
4,180万円
more
- 西宮市川東町
- 兵庫県
- 阪神本線「香櫨園」駅徒歩5分
-
階・間取/7階/9階建・3LDK
専有面積/77.28m²
築年月/1998年3月
CASE WHEN revenue = 1 THEN 1 ELSE 0 END, created_at DESC
-
エスリード宝塚
3,680万円
more
- 宝塚市栄町
- 兵庫県
- 阪急電鉄宝塚線「宝塚」駅徒歩7分
-
階・間取/9階/14階建・3LDK
専有面積/63.44m²
築年月/2005年2月