Title Page Background
DEBUG FN args: Array ( [0] => 552 [1] => [2] => [3] => agent ) BEFORE: Site: 552 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 552 Igate: njhud LocID: 552 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 552 [1] => [2] => [3] => lender ) BEFORE: Site: 552 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 552 Igate: njhud LocID: 552 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 552 [1] => [2] => [3] => other ) BEFORE: Site: 552 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 552 Igate: njhud LocID: 552 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

5454 Ka Haku Rd
Princeville, HI 96722
Rohn Boyd with eXp Realty, original listing - (866) 549-8527

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,810,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1734 Square Feet
Agency: eXp Realty
Agency Phone: (866) 549-8527

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1981
Notes: Oceanfront Elegance at Puu Poa | Kauai's Premier Luxury Living <br /> <br /> Experience the pinnacle of coastal luxury in this stunning 2-bedroom, 2-bathroom oceanfront condo at the highly sought-after Puu Poa on Kaua'i’s North Shore. Perched on a dramatic bluff above Hideaways Beach, this meticulously designed residence offers panoramic views of the Pacific Ocean, Bali Hai sunsets, and the tropical beauty that makes Princeville iconic. This turnkey condo offers not only breathtaking oceanfront views, but also exceptional income potential as a high-performing vacation rental on Kaua'i’s famed North Shore. Step inside to find an expansive open-concept layout with floor-to-ceiling windows that blur the line between indoor comfort and outdoor splendor. <br /> <br /> The ocean-facing chef’s kitchen boasts high-end appliances, custom cabinetry, and elegant granite countertops—perfect for preparing island-inspired meals to be enjoyed on your private lanai while watching whales breach in the distance. The primary suite offers ocean views and a spa-like bathroom. Designer finishes and curated furnishings elevate every corner of this refined retreat. Enjoy the newly tiled lanai—an ideal spot to take in the sights of surfers, whales, dolphins, and turtles below, along with breathtaking North Shore sunsets.<br /> <br /> A brand-new 3-unit Fujitsu air conditioning system is scheduled for installation in May.<br /> <br /> On-site amenities include a cliff-side swimming pool along with tennis and pickleball courts. A nearby public trail offers convenient access to the stunning Hideaway’s Beach. Just minutes away from the One Hotel, Hanalei Bay, Makai Golf & Tennis Club, and Princeville Shopping Center—providing both ease and entertainment. Whether you're seeking a luxury full-time residence, vacation escape, or premium investment opportunity, this unit is a rare opportunity to own a luxury property that not only pays for itself, but also allows you and your guests to enjoy the ultimate Kaua'i lifestyle.
MlsNumber: --
ListingId: 719780


Listing Provided By: eXp Realty, original listing
Phone: (808) 652-0530
Office Phone: (866) 549-8527
Agent Name: Rohn Boyd
Disclaimer: Copyright © 2025 Hawaii Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => kauai [3] => HI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: kauai State: HI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: kauai State: HI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Vicki Agor
Vicki Agor
ASCIIPoipu 365, Inc.
Call Today!: (808) 639-7801

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App