47-318 Waihee Road Kaneohe, HI 96744
Listing
Overview
Price: $750,000
Area: WAIHEE
Status: Active
Rarely available, 5,000 square feet flat lot on the Windward side of Oahu. Build your dream home with the Koolau Mountains on one side and views of Kaneohe Bay on the other. Close proximity to the Elementary School and minutes from all that Kaneohe has to offer. Listing by: BHGRE Advantage Realty (808) 391-9714
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202413951"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-318"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Waihee"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "750000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "WAIHEE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(264) "Rarely available, 5,000 square feet flat lot on the Windward side of Oahu. Build your dream home with the Koolau Mountains on one side and views of Kaneohe Bay on the other. Close proximity to the Elementary School and minutes from all that Kaneohe has to offer."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Kahaluu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "TimT@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 391-9714"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Timmy R Tengan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-06-18T20:29:01.030"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18063321"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-18T20:29:01.030"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26590945"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "26590945"
[1]=>
string(8) "26590946"
[2]=>
string(8) "26590947"
[3]=>
string(8) "26590948"
[4]=>
string(8) "26590949"
[5]=>
string(8) "26590950"
[6]=>
string(8) "26590951"
[7]=>
string(8) "26590952"
[8]=>
string(8) "26590953"
[9]=>
string(8) "26590954"
[10]=>
string(8) "26590955"
[11]=>
string(8) "26590956"
[12]=>
string(8) "26590957"
[13]=>
string(8) "26590958"
[14]=>
string(8) "26590959"
[15]=>
string(8) "26590960"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202413951
)
[StreetNumber] => Array
(
[0] => 47-318
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Waihee
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 750000.00
)
[CurrentPrice] => Array
(
[0] => 750000.00
)
[Neighbourhood] => Array
(
[0] => WAIHEE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rarely available, 5,000 square feet flat lot on the Windward side of Oahu. Build your dream home with the Koolau Mountains on one side and views of Kaneohe Bay on the other. Close proximity to the Elementary School and minutes from all that Kaneohe has to offer.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 5000.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahaluu
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => TimT@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 391-9714
)
[ListAgentFullName] => Array
(
[0] => Timmy R Tengan
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-06-18T20:29:01.030
)
[Matrix_Unique_ID] => Array
(
[0] => 18063321
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-18T20:29:01.030
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26590945
)
[listing_image] => Array
(
[0] => 26590945
[1] => 26590946
[2] => 26590947
[3] => 26590948
[4] => 26590949
[5] => 26590950
[6] => 26590951
[7] => 26590952
[8] => 26590953
[9] => 26590954
[10] => 26590955
[11] => 26590956
[12] => 26590957
[13] => 26590958
[14] => 26590959
[15] => 26590960
)
)
- View: Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Kahaluu
- Middle School: King
- High School: Castle
