Listing
Overview
Price: $1,189,000
Area: RENAISSANCE
Status: Active
Summer Sale!!! $10,000 Price Reduction!!!! The Renaissance at Waikele. This contemporary style home sits on a rim lot and features soaring ceilings as you enter the formal living room with divine moonlight views. The kitchen is at the heart of the home and extends into another bonus living area. A recent addition is a covered lanai offering desirable indoor-outdoor living space. A bonus loft serves as a perfect work space overlooking the formal area above. All four bedrooms enjoy privacy on the second level. We invite you to tour this property and experience the thoughtful improvements throughout, including 26-Owned PV Panels!!!! Listing by: Coldwell Banker Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202311527"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1040"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Halekapio"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96797"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://s3.amazonaws.com/video.creativeedge.tv/743956-4.mp4"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1189000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1189000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "RENAISSANCE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(642) "Summer Sale!!! $10,000 Price Reduction!!!! The Renaissance at Waikele. This contemporary style home sits on a rim lot and features soaring ceilings as you enter the formal living room with divine moonlight views. The kitchen is at the heart of the home and extends into another bonus living area. A recent addition is a covered lanai offering desirable indoor-outdoor living space. A bonus loft serves as a perfect work space overlooking the formal area above. All four bedrooms enjoy privacy on the second level. We invite you to tour this property and experience the thoughtful improvements throughout, including 26-Owned PV Panels!!!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4725.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1911"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2004"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(21) "Mountain,Other,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waikele"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "hazel.unciano@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Hazel Unciano"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-07-22T17:30:01.457"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17340620"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-25T12:41:51.777"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25851911"
}
["listing_image"]=>
array(15) {
[0]=>
string(8) "25851911"
[1]=>
string(8) "25851912"
[2]=>
string(8) "25851913"
[3]=>
string(8) "25851914"
[4]=>
string(8) "25851915"
[5]=>
string(8) "25851916"
[6]=>
string(8) "25851917"
[7]=>
string(8) "25851918"
[8]=>
string(8) "25851919"
[9]=>
string(8) "25851920"
[10]=>
string(8) "25851921"
[11]=>
string(8) "25851922"
[12]=>
string(8) "25851923"
[13]=>
string(8) "25851924"
[14]=>
string(8) "25851925"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(31) "Subject To Replacement Property"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202311527
)
[StreetNumber] => Array
(
[0] => 94-1040
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Halekapio
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://s3.amazonaws.com/video.creativeedge.tv/743956-4.mp4
)
[ListPrice] => Array
(
[0] => 1189000.00
)
[CurrentPrice] => Array
(
[0] => 1189000.00
)
[Neighbourhood] => Array
(
[0] => RENAISSANCE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Summer Sale!!! $10,000 Price Reduction!!!! The Renaissance at Waikele. This contemporary style home sits on a rim lot and features soaring ceilings as you enter the formal living room with divine moonlight views. The kitchen is at the heart of the home and extends into another bonus living area. A recent addition is a covered lanai offering desirable indoor-outdoor living space. A bonus loft serves as a perfect work space overlooking the formal area above. All four bedrooms enjoy privacy on the second level. We invite you to tour this property and experience the thoughtful improvements throughout, including 26-Owned PV Panels!!!!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4725.00
)
[SqftTotal] => Array
(
[0] => 1911
)
[YearBuilt] => Array
(
[0] => 2004
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Other,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waikele
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => hazel.unciano@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Hazel Unciano
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-07-22T17:30:01.457
)
[Matrix_Unique_ID] => Array
(
[0] => 17340620
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-05-25T12:41:51.777
)
[_thumbnail_id] => Array
(
[0] => 25851911
)
[listing_image] => Array
(
[0] => 25851911
[1] => 25851912
[2] => 25851913
[3] => 25851914
[4] => 25851915
[5] => 25851916
[6] => 25851917
[7] => 25851918
[8] => 25851919
[9] => 25851920
[10] => 25851921
[11] => 25851922
[12] => 25851923
[13] => 25851924
[14] => 25851925
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => Subject To Replacement Property
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 4,725
- Living (sf): 1,911
- Year Built: 2004
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain,Other,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waikele
- Middle School: Waipahu
- High School: Waipahu