45-462 Waikalua Place Kaneohe, HI 96744
Listing
Overview
Price: $909,000
Area: HALEPUU
Status: Active Under Contract
Location! Location! Location! A unique and cozy single level home along the Kaneohe Stream Conveniently located near the heart of Kaneohe. Enjoy easy access to highways, shopping centers, Windward Mall, restaurants, grocery stores, military bases, police station and various outdoor activities! Outdoor space includes a fenced in yard area, spacious covered patio is ready to entertain your families and friends with no neighbors in the back. No Maintenance Fee No HOA Fee is always a plus. Fumigation (done in 10/2022) still under warranty. This home to be sold as is! Priced below appraised Value. Listing by: Soldier To Soldier HI Realty (808) 312-7884
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415703"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-462"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Waikalua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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) "909000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "909000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEPUU"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(599) "Location! Location! Location! A unique and cozy single level home along the Kaneohe Stream Conveniently located near the heart of Kaneohe. Enjoy easy access to highways, shopping centers, Windward Mall, restaurants, grocery stores, military bases, police station and various outdoor activities! Outdoor space includes a fenced in yard area, spacious covered patio is ready to entertain your families and friends with no neighbors in the back. No Maintenance Fee No HOA Fee is always a plus. Fumigation (done in 10/2022) still under warranty. This home to be sold as is! Priced below appraised Value."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Soldier To Soldier HI Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3496.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1200"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1987"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STSH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "wendy@lauleahomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 312-7884"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Yanbo Liao"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-04T21:30:01.747"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18118274"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-12T09:35:30.010"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26619313"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "26619313"
[1]=>
string(8) "26619314"
[2]=>
string(8) "26619315"
[3]=>
string(8) "26619316"
[4]=>
string(8) "26619317"
[5]=>
string(8) "26619318"
[6]=>
string(8) "26619319"
[7]=>
string(8) "26619320"
[8]=>
string(8) "26619321"
[9]=>
string(8) "26619322"
[10]=>
string(8) "26619323"
[11]=>
string(8) "26619324"
[12]=>
string(8) "26619325"
[13]=>
string(8) "26619326"
[14]=>
string(8) "26619327"
[15]=>
string(8) "26619328"
[16]=>
string(8) "26619329"
[17]=>
string(8) "26619330"
[18]=>
string(8) "26619331"
[19]=>
string(8) "26619332"
[20]=>
string(8) "26619333"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415703
)
[StreetNumber] => Array
(
[0] => 45-462
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waikalua
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 909000.00
)
[CurrentPrice] => Array
(
[0] => 909000.00
)
[Neighbourhood] => Array
(
[0] => HALEPUU
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Location! Location! Location! A unique and cozy single level home along the Kaneohe Stream Conveniently located near the heart of Kaneohe. Enjoy easy access to highways, shopping centers, Windward Mall, restaurants, grocery stores, military bases, police station and various outdoor activities! Outdoor space includes a fenced in yard area, spacious covered patio is ready to entertain your families and friends with no neighbors in the back. No Maintenance Fee No HOA Fee is always a plus. Fumigation (done in 10/2022) still under warranty. This home to be sold as is! Priced below appraised Value.
)
[ListOfficeName] => Array
(
[0] => Soldier To Soldier HI Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3496.00
)
[SqftTotal] => Array
(
[0] => 1200
)
[YearBuilt] => Array
(
[0] => 1987
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => STSH
)
[ListAgentEmail] => Array
(
[0] => wendy@lauleahomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 312-7884
)
[ListAgentFullName] => Array
(
[0] => Yanbo Liao
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-04T21:30:01.747
)
[Matrix_Unique_ID] => Array
(
[0] => 18118274
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-12T09:35:30.010
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26619313
)
[listing_image] => Array
(
[0] => 26619313
[1] => 26619314
[2] => 26619315
[3] => 26619316
[4] => 26619317
[5] => 26619318
[6] => 26619319
[7] => 26619320
[8] => 26619321
[9] => 26619322
[10] => 26619323
[11] => 26619324
[12] => 26619325
[13] => 26619326
[14] => 26619327
[15] => 26619328
[16] => 26619329
[17] => 26619330
[18] => 26619331
[19] => 26619332
[20] => 26619333
)
)
- BedsTotal: 3
- Full Baths: 1
- Half Baths: 1
- Land Area (sf): 3,496
- Living (sf): 1,200
- Year Built: 1987
- Property Condition: Above Average,Average
- Number of Parking Spaces: 3
- View: None
- Listing Office: Soldier To Soldier HI Realty
- Land Tenure: FS - Fee Simple
- Middle School: King
- High School: Castle