47-7424 Hui Kelu Street Unit 1504 Kaneohe, HI 96744
Listing
Overview
Price: $689,000
Area: TEMPLE VALLEY
Status: Active Under Contract
What a deal!! Welcome to the beautiful Kahalemanu complex in Temple Valley, located on the serene windward side of Oahu! This 4 bed/2 bath, split-level unit is a hidden gem waiting for you to make it your own. As you enter, you'll be greeted by the timeless elegance of ceramic tile flooring on the ground floor, offering durability & easy maintenance. Upstairs, you'll find the bedrooms adorned w/private balconies, where you can unwind & enjoy the gentle tropical breezes. Between the bedrooms, there's a spacious closet that can double as an office area, allowing for productivity without sacrificing space. The living room, with its high vaulted ceilings and the large enclosed front patio is an ideal spot for outdoor gatherings, providing privacy & tranquility. Situated at the edge of the complex, you have no neighbors directly behind or in front of you. While the unit requires some work to shine & reach its full potential, it offers an abundance of good space, providing endless possibilities for customization & personalization. Don't miss this opportunity to transform this diamond in the rough into your dream home. Listing by: Island, REALTORS
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202314787"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "47-7424"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Hui Kelu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "1504"
}
["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) "689000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "689000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "TEMPLE VALLEY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1130) "What a deal!! Welcome to the beautiful Kahalemanu complex in Temple Valley, located on the serene windward side of Oahu! This 4 bed/2 bath, split-level unit is a hidden gem waiting for you to make it your own. As you enter, you'll be greeted by the timeless elegance of ceramic tile flooring on the ground floor, offering durability & easy maintenance. Upstairs, you'll find the bedrooms adorned w/private balconies, where you can unwind & enjoy the gentle tropical breezes. Between the bedrooms, there's a spacious closet that can double as an office area, allowing for productivity without sacrificing space. The living room, with its high vaulted ceilings and the large enclosed front patio is an ideal spot for outdoor gatherings, providing privacy & tranquility. Situated at the edge of the complex, you have no neighbors directly behind or in front of you. While the unit requires some work to shine & reach its full potential, it offers an abundance of good space, providing endless possibilities for customization & personalization. Don't miss this opportunity to transform this diamond in the rough into your dream home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Island, REALTORS"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "398661.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1880"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1972"
}
["BuildingName"]=>
array(1) {
[0]=>
string(10) "Kahalemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(12) "Garden,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "620.64"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STFP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "jennifer.cook-fujioka@irhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(23) "Jennifer K Cook-Fujioka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-25T22:13:01.913"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17414041"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-02T23:59:46.557"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25863055"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "25863055"
[1]=>
string(8) "25863056"
[2]=>
string(8) "25863057"
[3]=>
string(8) "25863058"
[4]=>
string(8) "25863059"
[5]=>
string(8) "25863060"
[6]=>
string(8) "25863061"
[7]=>
string(8) "25863062"
[8]=>
string(8) "25863063"
[9]=>
string(8) "25863064"
[10]=>
string(8) "25863065"
[11]=>
string(8) "25863066"
[12]=>
string(8) "25863067"
[13]=>
string(8) "25863068"
[14]=>
string(8) "25863069"
[15]=>
string(8) "25863070"
[16]=>
string(8) "25863071"
[17]=>
string(8) "25863072"
[18]=>
string(8) "25863073"
[19]=>
string(8) "25863074"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(11) "Lender Sale"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202314787
)
[StreetNumber] => Array
(
[0] => 47-7424
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Hui Kelu
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 1504
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 689000.00
)
[CurrentPrice] => Array
(
[0] => 689000.00
)
[Neighbourhood] => Array
(
[0] => TEMPLE VALLEY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => What a deal!! Welcome to the beautiful Kahalemanu complex in Temple Valley, located on the serene windward side of Oahu! This 4 bed/2 bath, split-level unit is a hidden gem waiting for you to make it your own. As you enter, you'll be greeted by the timeless elegance of ceramic tile flooring on the ground floor, offering durability & easy maintenance. Upstairs, you'll find the bedrooms adorned w/private balconies, where you can unwind & enjoy the gentle tropical breezes. Between the bedrooms, there's a spacious closet that can double as an office area, allowing for productivity without sacrificing space. The living room, with its high vaulted ceilings and the large enclosed front patio is an ideal spot for outdoor gatherings, providing privacy & tranquility. Situated at the edge of the complex, you have no neighbors directly behind or in front of you. While the unit requires some work to shine & reach its full potential, it offers an abundance of good space, providing endless possibilities for customization & personalization. Don't miss this opportunity to transform this diamond in the rough into your dream home.
)
[ListOfficeName] => Array
(
[0] => Island, REALTORS
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 398661.00
)
[SqftTotal] => Array
(
[0] => 1880
)
[YearBuilt] => Array
(
[0] => 1972
)
[BuildingName] => Array
(
[0] => Kahalemanu
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Other
)
[MaintenanceExpense] => Array
(
[0] => 620.64
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Ahuimanu
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => STFP
)
[ListAgentEmail] => Array
(
[0] => jennifer.cook-fujioka@irhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Jennifer K Cook-Fujioka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-25T22:13:01.913
)
[Matrix_Unique_ID] => Array
(
[0] => 17414041
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-02T23:59:46.557
)
[_thumbnail_id] => Array
(
[0] => 25863055
)
[listing_image] => Array
(
[0] => 25863055
[1] => 25863056
[2] => 25863057
[3] => 25863058
[4] => 25863059
[5] => 25863060
[6] => 25863061
[7] => 25863062
[8] => 25863063
[9] => 25863064
[10] => 25863065
[11] => 25863066
[12] => 25863067
[13] => 25863068
[14] => 25863069
[15] => 25863070
[16] => 25863071
[17] => 25863072
[18] => 25863073
[19] => 25863074
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => Lender Sale
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 398,661
- Living (sf): 1,880
- Year Built: 1972
- Building Name: Kahalemanu
- Property Condition: Average
- Number of Parking Spaces: 2
- View: Garden,Other
- Listing Office: Island, REALTORS
- Maintenance Fees: $621
- Land Tenure: FS - Fee Simple
- Elementary School: Ahuimanu
- Middle School: King
- High School: Castle
