Title Page Background
HFQUERY 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 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

963 Niulani Rd
Kapaa, HI 96746
Jill Caisey with Hawaii Life, original listing - (800) 370-3848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1520 Square Feet
Agency: Hawaii Life
Agency Phone: (800) 370-3848

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1947
Notes: Classic Old World Hawaiian Charm with Ocean Views and a Vacation Rental License.<br /> <br /> Tucked back on a quiet one way street sits this classic plantation style vacation rental. Niulani is a wonderful little neighborhood with approximately 16 homes. Conveniently located just a street back from the ocean and close proximity to stores, beaches and restaurants. This property includes a very nice sized lot with mature palm trees and lush green grass. The separate detached garage has room for 2 cars and plenty of extra storage. <br /> This vacation rental house has the ability to sleep 8 people with 3 full bedrooms 3 full baths and an additional nook with twin beds off the second floor primary suite. The main floor living area includes two bedrooms, 2 baths and a large open kitchen/dining area, as well as a sitting area and a full living room. Upstairs you will find the primary suite, a full bath a twin sleeping porch and a lovely lanai for taking in the ocean views. The main front lanai is an expansive and relaxing resting place to enjoy the tropical breezes. Set up a hammock and spend your day perched between the coconut palms that line the yard. <br /> <br /> The property has been updated from cesspool to septic already. 963 Niulani is zoned R-20 lending the possibility to adding a guest house or additional structure. (Buyers and their agents to check with the county on building restrictions and all due diligence).<br /> <br /> This home has just received a full exterior refresh: including a power-wash, window and screen wash, followed by a custom professional paint job for the home and garage, additionally a new set of custom built entry stairs. <br /> <br /> Showings will be between guest stays.<br /> <br /> Non branded video: https://player.vimeo.com/video/935112251
MlsNumber: --
ListingId: 709269


Listing Provided By: Hawaii Life, original listing
Phone: (800) 370-3848
Office Phone: (800) 370-3848
Agent Name: Jill Caisey
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App