E_USER_ERROR : SQL Query ERROR
Mysql Error -> 1021:Disk full (/tmp/#sql-temptable-57a-122861d-65.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query -> SELECT count(*) as n , city FROM article_rp WHERE `flag`=1 and `listing_flag`=1 and `service_id`='rp' and `service_site`='vnnet' and `listing_site_id` REGEXP '(^0-03|[[:space:]]0-03[[:space:]]|[[:space:]]0-03)' GROUP BY city
: /home/vnsh/vnnet/agora/lib/class/db/mysqli.php 282  Ref EID 69361fad77ab2  
Coldwell Banker不動産 / New Arrival] Property for sale : 2 bed condo in Ho'opili, West Oahu new residential area ・ Open House Dec 7 & 14th / Vivinavi World (All listing areas) Your community classified / Housing / Real Estate
2025/12/07 04:45:33
There is a communication failure between servers.We are currently recovering data. Please wait for a while. Depending on communication status, you may lose registered data.If you would like to make post, please do so after recovery is completed. All of currently displayed data are cached.Actual data may be different due to time passage.
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
Previous
Next
CgkJPHNjcmlwdCB0eXBlPSJ0ZXh0L2phdmFzY3JpcHQiPgoJCQkvL1ZpZGVvSlMuc2V0dXBBbGxXaGVuUmVhZHkoKTsKCQk8L3NjcmlwdD4KCQk8ZGl2IGNsYXNzPSJ2aWRlby1qcy1ib3giPgoJCQk8dmlkZW8gaWQ9InZpZGVvX2ppZF82OTM2MWZhZDdlNmVhXzczMDc0YjlhNmU5MDRkNzY1OWY3NDhjY2RkNTgzZTRjYTA0NGMyMDltcDQiIHdpZHRoPSIzNjAuODg4ODg4ODg4ODkiIGhlaWdodD0iNjQwIiBjb250cm9scyAgcHJlbG9hZD0ibWV0YWRhdGEiIHBvc3Rlcj0iaHR0cHM6Ly92bm11c2UxLnZpdmluYXZpLmNvbS83MzAvNzMwNzRiOWE2ZTkwNGQ3NjU5Zjc0OGNjZGQ1ODNlNGNhMDQ0YzIwOV90aHVtYl9sYXJnZS5qcGVnIiBjbGFzcz0idmlkZW8tanMiPgoKCQkJCTxvYmplY3QgaWQ9ImZsYXNoX2ZhbGxiYWNrXzEiIHdpZHRoPSIzNjAuODg4ODg4ODg4ODkiIGhlaWdodD0iNjQwIiB0eXBlPSJhcHBsaWNhdGlvbi94LXNob2Nrd2F2ZS1mbGFzaCIgZGF0YT0iL2ZsYXNoL2Zsb3dwbGF5ZXIvZmxvd3BsYXllci0zLjIuNy5zd2YiIGNsYXNzPSJ2anMtZmxhc2gtZmFsbGJhY2siPgoJCQkJCTxwYXJhbSBuYW1lPSJtb3ZpZSIgdmFsdWU9Ii9mbGFzaC9mbG93cGxheWVyL2Zsb3dwbGF5ZXItMy4yLjcuc3dmIj4KCQkJCQk8cGFyYW0gbmFtZT0iYWxsb3dmdWxsc2NyZWVuIiB2YWx1ZT0idHJ1ZSI+CgkJCQkJPHBhcmFtIG5hbWU9ImZsYXNodmFycyIgdmFsdWU9J2NvbmZpZz17InBsYXlsaXN0IjpbImh0dHBzOi8vdm5tdXNlMS52aXZpbmF2aS5jb20vNzMwLzczMDc0YjlhNmU5MDRkNzY1OWY3NDhjY2RkNTgzZTRjYTA0NGMyMDlfdGh1bWJfbGFyZ2UuanBlZyIsIHsidXJsIjogImh0dHBzOi8vdm5tdXNlMS52aXZpbmF2aS5jb20vNzMwLzczMDc0YjlhNmU5MDRkNzY1OWY3NDhjY2RkNTgzZTRjYTA0NGMyMDkubXA0IiwiYXV0b1BsYXkiOmZhbHNlLCJhdXRvQnVmZmVyaW5nIjp0cnVlfV19Jz4KCQkJCQk8aW1nIHNyYz0iaHR0cHM6Ly92bm11c2UxLnZpdmluYXZpLmNvbS83MzAvNzMwNzRiOWE2ZTkwNGQ3NjU5Zjc0OGNjZGQ1ODNlNGNhMDQ0YzIwOV90aHVtYl9sYXJnZS5qcGVnIiB3aWR0aD0iMzYwLjg4ODg4ODg4ODg5IiBoZWlnaHQ9IjY0MCIgYWx0PSIiIHRpdGxlPSIiPgoJCQkJPC9vYmplY3Q+CgkJCQk8c291cmNlIHNyYz0iaHR0cHM6Ly92bm11c2UxLnZpdmluYXZpLmNvbS83MzAvNzMwNzRiOWE2ZTkwNGQ3NjU5Zjc0OGNjZGQ1ODNlNGNhMDQ0YzIwOS5tcDQiIHR5cGU9J3ZpZGVvL21wNDsgY29kZWNzPSJhdmMxLjQyRTAxRSwgbXA0YS40MC4yIic+CgkJCQk8c291cmNlIHNyYz0iaHR0cHM6Ly92bm11c2UyLnZpdmluYXZpLmNvbS83MzAvNzMwNzRiOWE2ZTkwNGQ3NjU5Zjc0OGNjZGQ1ODNlNGNhMDQ0YzIwOV92aWRlby5vZ2ciIHR5cGU9J3ZpZGVvL29nZzsgY29kZWNzPSJ0aGVvcmEsIHZvcmJpcyInPgoKCQkJPC92aWRlbz4KCQk8L2Rpdj4=
Previous
Next

This text has been translated by auto-translation. There may be a slight difference between the original text and the translation. (Original Language: 日本語)

Sell / Condominium

Enlarge
Sell
Price / Rent 575,000
Management Fee / Common Charges 671.45
Surety No
Transporation ホノウリウリ駅( #3)
Location 91-3641 Iwikuamoo St #9309 9309, Ewa Beach, HI, 96706 USA
Transaction Type Exclusive Right to Sell Listing
Property Condominium
Age of Building 2
Built 2023year 
Layout 2LDK
Bathroom 2+
Restroom 2+
Building Area(Occupied Area) 867square feet
[Concept]
  • Quiet Residential Area
[Condition]
  • Dog OK
  • Cat OK
  • Pet Friendly
[Amenity]
  • Pool
  • Post Box
  • Barrier-free
  • Elevator
  • Cable/Satellite
  • Sprinkler
[Security]
  • Autolock
  • Security Camera
  • Monitor Interphone
  • On-site Manager
[Indoor Environment]
  • Bath/Restroom Divided
  • Dishwasher
  • Airconditioner
  • Fridge
  • Walk-in Closet
  • Inside Wash Machine Space
  • Patio/Balcony
  • 2 Floor or more
  • Electric Stove
  • Separate Washstand
[Outdoor Environment]
  • Property Parking
  • Parking (Paid)
  • Near Station
  • Near Convenience Store
  • Near Supermarket
  • Parking
  • Near Shopping Mall
  • Dispose trash 24hrs
Web Access No.3282977

New Arrival] Property for sale : 2 bed condo in Ho'opili, West Oahu new residential area ・ Open House Dec 7 & 14th

🏡 Most affordable 2 bedroom !
closest condo to 🚃 train station ( Honouliuli Station #3 ) in popular Ho'opili ! rare to find on the market !
✨ like new Good Condition
🌺 Community with ample amenities such as parks, pools, dock parks and community events to enhance your life

[Open House]
December 7 ( Sunday ) 2:00 PM - 5:00 PM
December 14 ( Sunday ) 2:00 PM to 5:00 PM
Individual previews are available for those who cannot make it.
Contact : Hakko Smith ( RS-84708)-Coldwell Banker Real Estate
📞 808-398-8112
📧 hiroko.smith@cbrealty.com
Instagram: https://www.instagram.com/hiroko.smith_halealoha/

[Property Summary]
Location : Nahele at Hoopili | 91-3641 Iwikuamoo St #9309, Ewa Beach 96706
Type : 2 bedroom / 2 bath / 1 parking
Square footage : 867 square feet + lanai 69 square feet
Floors : 3rd floor 1 Elevator )
View : Mountain & Rail
Property Tax : $ 155/month
Maintenance Fee : $ 671.45/month ( Electric ・ Water ・ Sewer Separate )
Selling Price : $ 575,000 MLS#202527502

✨ Property Features
• Bright & Open 2BD / 2BA / 1 Parking • Abundant Natural Light & Airy
• Nearly New in Good Condition
• Open Floor Plan
• Luxury Vinyl Plank Flooring, Carpet in Bedroom
• Split A/C in each room, ceiling fans
• Quartz kitchen counters + stainless steel appliances
• Relaxing covered lanai
• Large Closets
• Full size washer&dryer
• With smart home system
• Security ( Manager on duty )
• Pets allowed Negotiable )

🏡 Full Hoopiri ・ Community Facilities
• SoHo Community Center available
- Large swimming pool
- Party room
- Meeting room
- Spacious lawn area
- BBQ area
Dog Park
- Playground
- Pickleball Court&Basketball Court

📍 Convenient Location
• Walking distance to Honouliuli Station ( #3 )
( 20 minutes to airport / 32 minutes to downtown in the future )
• Close to University of Hawaii at West Oahu
Ka ・ Makana ・ Alii ・ Minutes to mall - shopping ・ dining ・ entertainment galore
• Don Quijote, Costco, Target, Walmart, Minutes to Foodland Farm

* Property for sale is co-listed with John Gephart (RB-23240).

[Contact]
  • Coldwell Banker不動産
  • [TEL]808-398-8112
  • [License]RS-84708
  • Posted : 2025/12/06
  • Published : 2025/12/06
  • Changed : 2025/12/06
  • Total View : 21 persons