If ‘open concept’ means no walls, and ‘classic’ layout means distinct and separated rooms, then the ‘connected concept’ found in this home provides the best of all worlds. Located in The Pointe, a gated community within the already guard-gate Hawaii Loa Ridge neighborhood, this 2-story home on a flag & rim lot has privacy, quiet, and VIEWS FOR DAYS.
Add to that the wonders of a 3-car garage, an infinity-edge pool with waterfall hot tub, a covered BBQ area as big as a living room, and walls of glass that simply fold away across most of the main floor and you’ve landed in the lap of luxury here.
But, seeing is believing so go now to the property website where you’ll find comprehensive details, full HD photos, infotaining videos, a Matterport 3D model, and much more. Are you ready to be amazed? Click the virtual tour link now.
Listing by: Portfolio
array(159) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(10) "2052900.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1645900.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "3698800.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(3) "125"
}
["association_fees"]=>
array(1) {
[0]=>
string(3) "125"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(8) "Electric"
}
["floor_covering"]=>
array(1) {
[0]=>
string(23) "Hardwood,Marble/Granite"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "4"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "790"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "14548.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(10) "Land Court"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(24) "kimo@portfoliohawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(15) "Kimo Smigielski"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 735-5585"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-18"
}
["list_office_name"]=>
array(1) {
[0]=>
string(9) "Portfolio"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "4295000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "5890"
}
["location"]=>
array(1) {
[0]=>
string(39) "595 Moaniala Street, Honolulu, HI 96821"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "306.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202207171"
}
["neighborhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "3"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "SIRI"
}
["parking_features"]=>
array(1) {
[0]=>
string(13) "3 Car+,Garage"
}
["pool_"]=>
array(1) {
[0]=>
string(25) "In Ground,Spa/HotTub,Tile"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["rets_association_community_name"]=>
array(1) {
[0]=>
string(23) "Hawaii Loa & The Pointe"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(3) "125"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "431"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-373-5173"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "4.02"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "4350000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "14"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16568247"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-5585"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(24) "kimo@portfoliohawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Kimo Smigielski"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26617"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8834447"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "SIRI"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9746287"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(9) "Portfolio"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-5585"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "4295000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-18"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "14548.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "306.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(9) "Hawaiiana"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-593-9100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-30T13:25:26.890"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16568247"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202207171"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-18T12:41:20.107"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "4295000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-7-022-032-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-18T12:41:20.107"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-18T12:41:20.107"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16568247"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(231) "Please call or text Kimo at 808-255-2400 to schedule a showing, 24-hour notice is requested as this is owner-occupied. The majority of furnishings will be included in the sale. Sellers prefer First American Title and Cindi Lewis."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(859) "If ‘open concept’ means no walls, and ‘classic’ layout means distinct and separated rooms, then the ‘connected concept’ found in this home provides the best of all worlds. Located in The Pointe, a gated community within the already guard-gate Hawaii Loa Ridge neighborhood, this 2-story home on a flag & rim lot has privacy, quiet, and VIEWS FOR DAYS.
Add to that the wonders of a 3-car garage, an infinity-edge pool with waterfall hot tub, a covered BBQ area as big as a living room, and walls of glass that simply fold away across most of the main floor and you’ve landed in the lap of luxury here.
But, seeing is believing so go now to the property website where you’ll find comprehensive details, full HD photos, infotaining videos, a Matterport 3D model, and much more. Are you ready to be amazed? Click the virtual tour link now."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "827"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "790"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "5100"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "5890"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-16T13:47:20.267"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Moaniala"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "595"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(7) "1038.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(8) "12456.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "3698800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(10) "2052900.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1645900.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16568247/45c90db889c09a7d226216581e43e1ad"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "137"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "32"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "22"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "2006"
}
["security"]=>
array(1) {
[0]=>
string(35) "Gated Community,Key,Security Patrol"
}
["setbacks"]=>
array(1) {
[0]=>
string(9) "Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Moaniala"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "595"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-7-022-032-0000"
}
["topography"]=>
array(1) {
[0]=>
string(16) "Flag Lot,Rim Lot"
}
["view"]=>
array(1) {
[0]=>
string(32) "Coastline,Mountain,Ocean,Sunrise"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(53) "https://portfoliohawaii.com/project/595moaniala-4mls/"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16568247"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202207171"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656631534"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "2006"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "04 - R-7.5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3468) "a:210:{i:0;i:22040317;i:1;i:22040318;i:2;i:22040319;i:3;i:22040320;i:4;i:22040321;i:5;i:22040322;i:6;i:22040323;i:7;i:22040324;i:8;i:22040325;i:9;i:22040326;i:10;i:22040327;i:11;i:22040328;i:12;i:22040329;i:13;i:22040330;i:14;i:22040331;i:15;i:22040332;i:16;i:22040333;i:17;i:22040334;i:18;i:22040335;i:19;i:22040336;i:20;i:22040337;i:21;i:22040979;i:22;i:22040980;i:23;i:22040981;i:24;i:22040982;i:25;i:22040983;i:26;i:22040984;i:27;i:22040985;i:28;i:22040986;i:29;i:22040987;i:30;i:22040988;i:31;i:22040989;i:32;i:22040990;i:33;i:22040991;i:34;i:22040992;i:35;i:22040993;i:36;i:22040994;i:37;i:22040995;i:38;i:22040996;i:39;i:22040997;i:40;i:22040998;i:41;i:22040999;i:42;i:22041021;i:43;i:22041022;i:44;i:22041023;i:45;i:22041024;i:46;i:22041025;i:47;i:22041026;i:48;i:22041027;i:49;i:22041028;i:50;i:22041029;i:51;i:22041030;i:52;i:22041031;i:53;i:22041032;i:54;i:22041033;i:55;i:22041034;i:56;i:22041035;i:57;i:22041036;i:58;i:22041037;i:59;i:22041038;i:60;i:22041039;i:61;i:22041040;i:62;i:22041041;i:63;i:22140623;i:64;i:22140624;i:65;i:22140625;i:66;i:22140626;i:67;i:22140627;i:68;i:22140628;i:69;i:22140629;i:70;i:22140630;i:71;i:22140631;i:72;i:22140632;i:73;i:22140633;i:74;i:22140634;i:75;i:22140635;i:76;i:22140636;i:77;i:22140637;i:78;i:22140638;i:79;i:22140639;i:80;i:22140640;i:81;i:22140641;i:82;i:22140642;i:83;i:22140643;i:84;i:22248713;i:85;i:22248714;i:86;i:22248715;i:87;i:22248716;i:88;i:22248717;i:89;i:22248718;i:90;i:22248719;i:91;i:22248720;i:92;i:22248721;i:93;i:22248722;i:94;i:22248723;i:95;i:22248724;i:96;i:22248725;i:97;i:22248726;i:98;i:22248727;i:99;i:22248728;i:100;i:22248729;i:101;i:22248730;i:102;i:22248731;i:103;i:22248732;i:104;i:22248733;i:105;i:22417846;i:106;i:22417847;i:107;i:22417848;i:108;i:22417849;i:109;i:22417850;i:110;i:22417851;i:111;i:22417852;i:112;i:22417853;i:113;i:22417854;i:114;i:22417855;i:115;i:22417856;i:116;i:22417857;i:117;i:22417858;i:118;i:22417859;i:119;i:22417860;i:120;i:22417861;i:121;i:22417862;i:122;i:22417863;i:123;i:22417864;i:124;i:22417865;i:125;i:22417866;i:126;i:22457910;i:127;i:22457911;i:128;i:22457912;i:129;i:22457913;i:130;i:22457914;i:131;i:22457915;i:132;i:22457916;i:133;i:22457917;i:134;i:22457918;i:135;i:22457919;i:136;i:22457920;i:137;i:22457921;i:138;i:22457922;i:139;i:22457923;i:140;i:22457924;i:141;i:22457925;i:142;i:22457926;i:143;i:22457927;i:144;i:22457928;i:145;i:22457929;i:146;i:22457930;i:147;i:22589136;i:148;i:22589137;i:149;i:22589138;i:150;i:22589139;i:151;i:22589140;i:152;i:22589141;i:153;i:22589142;i:154;i:22589143;i:155;i:22589144;i:156;i:22589145;i:157;i:22589146;i:158;i:22589147;i:159;i:22589148;i:160;i:22589149;i:161;i:22589150;i:162;i:22589151;i:163;i:22589152;i:164;i:22589153;i:165;i:22589154;i:166;i:22589155;i:167;i:22589156;i:168;i:22589157;i:169;i:22589158;i:170;i:22589159;i:171;i:22589160;i:172;i:22589161;i:173;i:22589162;i:174;i:22589163;i:175;i:22589164;i:176;i:22589165;i:177;i:22589166;i:178;i:22589167;i:179;i:22589168;i:180;i:22589169;i:181;i:22589170;i:182;i:22589171;i:183;i:22589172;i:184;i:22589173;i:185;i:22589174;i:186;i:22589175;i:187;i:22589176;i:188;i:22589177;i:189;i:22589446;i:190;i:22589447;i:191;i:22589448;i:192;i:22589449;i:193;i:22589450;i:194;i:22589451;i:195;i:22589452;i:196;i:22589453;i:197;i:22589454;i:198;i:22589455;i:199;i:22589456;i:200;i:22589457;i:201;i:22589458;i:202;i:22589459;i:203;i:22589460;i:204;i:22589461;i:205;i:22589462;i:206;i:22589463;i:207;i:22589464;i:208;i:22589465;i:209;i:22589466;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-02"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-05-02"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "4350000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-04-17"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-5585"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(24) "kimo@portfoliohawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Kimo Smigielski"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26617"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "8834447"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "SIRI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "9746287"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(9) "Portfolio"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-5585"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22589446"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 2052900.00
)
[assd_val_land] => Array
(
[0] => 1645900.00
)
[assd_val_total] => Array
(
[0] => 3698800.00
)
[assn_fee_inclusions] => Array
(
[0] => 125
)
[association_fees] => Array
(
[0] => 125
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => Electric
)
[floor_covering] => Array
(
[0] => Hardwood,Marble/Granite
)
[full_baths] => Array
(
[0] => 4
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 2
)
[home_exampt] => Array
(
[0] => 140000
)
[lanai_sf] => Array
(
[0] => 790
)
[land_area_sf] => Array
(
[0] => 14548.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => kimo@portfoliohawaii.com
)
[list_agent_name] => Array
(
[0] => Kimo Smigielski
)
[list_agent_phone_number] => Array
(
[0] => (808) 735-5585
)
[list_date] => Array
(
[0] => 2022-04-18
)
[list_office_name] => Array
(
[0] => Portfolio
)
[list_price] => Array
(
[0] => 4295000.00
)
[living_sf] => Array
(
[0] => 5890
)
[location] => Array
(
[0] => 595 Moaniala Street, Honolulu, HI 96821
)
[maintenance_fees] => Array
(
[0] => 306.00
)
[mls_] => Array
(
[0] => 202207171
)
[neighborhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[number_of_parking_spaces] => Array
(
[0] => 3
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => SIRI
)
[parking_features] => Array
(
[0] => 3 Car+,Garage
)
[pool_] => Array
(
[0] => In Ground,Spa/HotTub,Tile
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96821
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => DiamondHd
)
[rets_association_community_name] => Array
(
[0] => Hawaii Loa & The Pointe
)
[rets_association_fee] => Array
(
[0] => 125
)
[rets_association_fee_total] => Array
(
[0] => 431
)
[rets_association_phone] => Array
(
[0] => 808-373-5173
)
[rets_baths_full] => Array
(
[0] => 4
)
[rets_baths_half] => Array
(
[0] => 2
)
[rets_baths_total] => Array
(
[0] => 4.02
)
[rets_beds_total] => Array
(
[0] => 4
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 4350000.00
)
[rets_dom] => Array
(
[0] => 14
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16568247
)
[rets_immoviewer_yn] => Array
(
[0] => 1
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 1
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 1
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 735-5585
)
[rets_list_agent_email] => Array
(
[0] => kimo@portfoliohawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Kimo Smigielski
)
[rets_list_agent_mlsid] => Array
(
[0] => 26617
)
[rets_list_agent_mui] => Array
(
[0] => 8834447
)
[rets_list_office_mlsid] => Array
(
[0] => SIRI
)
[rets_list_office_mui] => Array
(
[0] => 9746287
)
[rets_list_office_name] => Array
(
[0] => Portfolio
)
[rets_list_office_phone] => Array
(
[0] => (808) 735-5585
)
[rets_list_price] => Array
(
[0] => 4295000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-18
)
[rets_lot_size_area] => Array
(
[0] => 14548.00
)
[rets_maintenance_expense] => Array
(
[0] => 306.00
)
[rets_management_company_name] => Array
(
[0] => Hawaiiana
)
[rets_management_company_phone] => Array
(
[0] => 808-593-9100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-30T13:25:26.890
)
[rets_matrix_unique_id] => Array
(
[0] => 16568247
)
[rets_mls_number] => Array
(
[0] => 202207171
)
[rets_neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-18T12:41:20.107
)
[rets_original_list_price] => Array
(
[0] => 4295000.00
)
[rets_parcel_number] => Array
(
[0] => 1-3-7-022-032-0000
)
[rets_parking_total] => Array
(
[0] => 3
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-18T12:41:20.107
)
[rets_postal_code] => Array
(
[0] => 96821
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-18T12:41:20.107
)
[rets_primary_key] => Array
(
[0] => 16568247
)
[rets_private_remarks] => Array
(
[0] => Please call or text Kimo at 808-255-2400 to schedule a showing, 24-hour notice is requested as this is owner-occupied. The majority of furnishings will be included in the sale. Sellers prefer First American Title and Cindi Lewis.
)
[rets_public_remarks] => Array
(
[0] => If ‘open concept’ means no walls, and ‘classic’ layout means distinct and separated rooms, then the ‘connected concept’ found in this home provides the best of all worlds. Located in The Pointe, a gated community within the already guard-gate Hawaii Loa Ridge neighborhood, this 2-story home on a flag & rim lot has privacy, quiet, and VIEWS FOR DAYS.
Add to that the wonders of a 3-car garage, an infinity-edge pool with waterfall hot tub, a covered BBQ area as big as a living room, and walls of glass that simply fold away across most of the main floor and you’ve landed in the lap of luxury here.
But, seeing is believing so go now to the property website where you’ll find comprehensive details, full HD photos, infotaining videos, a Matterport 3D model, and much more. Are you ready to be amazed? Click the virtual tour link now.
)
[rets_sqft_garage_carport] => Array
(
[0] => 827
)
[rets_sqft_lanai_open] => Array
(
[0] => 790
)
[rets_sqft_roofed_living] => Array
(
[0] => 5100
)
[rets_sqft_total] => Array
(
[0] => 5890
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-16T13:47:20.267
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-16
)
[rets_street_name] => Array
(
[0] => Moaniala
)
[rets_street_number] => Array
(
[0] => 595
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 1038.00
)
[rets_tax_annual_amount] => Array
(
[0] => 12456.00
)
[rets_tax_assessed_value] => Array
(
[0] => 3698800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 2052900.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1645900.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16568247/45c90db889c09a7d226216581e43e1ad
)
[rets_tmk_area] => Array
(
[0] => 137
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 32
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 3
)
[rets_tmkplat] => Array
(
[0] => 22
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] =>
)
[rets_year_built] => Array
(
[0] => 2006
)
[security] => Array
(
[0] => Gated Community,Key,Security Patrol
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Moaniala
)
[street_number] => Array
(
[0] => 595
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-3-7-022-032-0000
)
[topography] => Array
(
[0] => Flag Lot,Rim Lot
)
[view] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise
)
[virtual_tour] => Array
(
[0] => https://portfoliohawaii.com/project/595moaniala-4mls/
)
[wpp::rets_pk] => Array
(
[0] => 16568247
)
[wpp_gpid] => Array
(
[0] => 202207171
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656631534
)
[year_built] => Array
(
[0] => 2006
)
[zoning] => Array
(
[0] => 04 - R-7.5 Residential District
)
[new_attached_media] => Array
(
[0] => a:210:{i:0;i:22040317;i:1;i:22040318;i:2;i:22040319;i:3;i:22040320;i:4;i:22040321;i:5;i:22040322;i:6;i:22040323;i:7;i:22040324;i:8;i:22040325;i:9;i:22040326;i:10;i:22040327;i:11;i:22040328;i:12;i:22040329;i:13;i:22040330;i:14;i:22040331;i:15;i:22040332;i:16;i:22040333;i:17;i:22040334;i:18;i:22040335;i:19;i:22040336;i:20;i:22040337;i:21;i:22040979;i:22;i:22040980;i:23;i:22040981;i:24;i:22040982;i:25;i:22040983;i:26;i:22040984;i:27;i:22040985;i:28;i:22040986;i:29;i:22040987;i:30;i:22040988;i:31;i:22040989;i:32;i:22040990;i:33;i:22040991;i:34;i:22040992;i:35;i:22040993;i:36;i:22040994;i:37;i:22040995;i:38;i:22040996;i:39;i:22040997;i:40;i:22040998;i:41;i:22040999;i:42;i:22041021;i:43;i:22041022;i:44;i:22041023;i:45;i:22041024;i:46;i:22041025;i:47;i:22041026;i:48;i:22041027;i:49;i:22041028;i:50;i:22041029;i:51;i:22041030;i:52;i:22041031;i:53;i:22041032;i:54;i:22041033;i:55;i:22041034;i:56;i:22041035;i:57;i:22041036;i:58;i:22041037;i:59;i:22041038;i:60;i:22041039;i:61;i:22041040;i:62;i:22041041;i:63;i:22140623;i:64;i:22140624;i:65;i:22140625;i:66;i:22140626;i:67;i:22140627;i:68;i:22140628;i:69;i:22140629;i:70;i:22140630;i:71;i:22140631;i:72;i:22140632;i:73;i:22140633;i:74;i:22140634;i:75;i:22140635;i:76;i:22140636;i:77;i:22140637;i:78;i:22140638;i:79;i:22140639;i:80;i:22140640;i:81;i:22140641;i:82;i:22140642;i:83;i:22140643;i:84;i:22248713;i:85;i:22248714;i:86;i:22248715;i:87;i:22248716;i:88;i:22248717;i:89;i:22248718;i:90;i:22248719;i:91;i:22248720;i:92;i:22248721;i:93;i:22248722;i:94;i:22248723;i:95;i:22248724;i:96;i:22248725;i:97;i:22248726;i:98;i:22248727;i:99;i:22248728;i:100;i:22248729;i:101;i:22248730;i:102;i:22248731;i:103;i:22248732;i:104;i:22248733;i:105;i:22417846;i:106;i:22417847;i:107;i:22417848;i:108;i:22417849;i:109;i:22417850;i:110;i:22417851;i:111;i:22417852;i:112;i:22417853;i:113;i:22417854;i:114;i:22417855;i:115;i:22417856;i:116;i:22417857;i:117;i:22417858;i:118;i:22417859;i:119;i:22417860;i:120;i:22417861;i:121;i:22417862;i:122;i:22417863;i:123;i:22417864;i:124;i:22417865;i:125;i:22417866;i:126;i:22457910;i:127;i:22457911;i:128;i:22457912;i:129;i:22457913;i:130;i:22457914;i:131;i:22457915;i:132;i:22457916;i:133;i:22457917;i:134;i:22457918;i:135;i:22457919;i:136;i:22457920;i:137;i:22457921;i:138;i:22457922;i:139;i:22457923;i:140;i:22457924;i:141;i:22457925;i:142;i:22457926;i:143;i:22457927;i:144;i:22457928;i:145;i:22457929;i:146;i:22457930;i:147;i:22589136;i:148;i:22589137;i:149;i:22589138;i:150;i:22589139;i:151;i:22589140;i:152;i:22589141;i:153;i:22589142;i:154;i:22589143;i:155;i:22589144;i:156;i:22589145;i:157;i:22589146;i:158;i:22589147;i:159;i:22589148;i:160;i:22589149;i:161;i:22589150;i:162;i:22589151;i:163;i:22589152;i:164;i:22589153;i:165;i:22589154;i:166;i:22589155;i:167;i:22589156;i:168;i:22589157;i:169;i:22589158;i:170;i:22589159;i:171;i:22589160;i:172;i:22589161;i:173;i:22589162;i:174;i:22589163;i:175;i:22589164;i:176;i:22589165;i:177;i:22589166;i:178;i:22589167;i:179;i:22589168;i:180;i:22589169;i:181;i:22589170;i:182;i:22589171;i:183;i:22589172;i:184;i:22589173;i:185;i:22589174;i:186;i:22589175;i:187;i:22589176;i:188;i:22589177;i:189;i:22589446;i:190;i:22589447;i:191;i:22589448;i:192;i:22589449;i:193;i:22589450;i:194;i:22589451;i:195;i:22589452;i:196;i:22589453;i:197;i:22589454;i:198;i:22589455;i:199;i:22589456;i:200;i:22589457;i:201;i:22589458;i:202;i:22589459;i:203;i:22589460;i:204;i:22589461;i:205;i:22589462;i:206;i:22589463;i:207;i:22589464;i:208;i:22589465;i:209;i:22589466;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-02
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_pending_date] => Array
(
[0] => 2022-05-02
)
[rets_close_date] => Array
(
[0] => 2022-06-16
)
[rets_close_price] => Array
(
[0] => 4350000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-04-17
)
[rets_off_market_date] => Array
(
[0] => 2022-06-16
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 735-5585
)
[rets_selling_agent_email] => Array
(
[0] => kimo@portfoliohawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kimo Smigielski
)
[rets_selling_agent_mlsid] => Array
(
[0] => 26617
)
[rets_selling_agent_mui] => Array
(
[0] => 8834447
)
[rets_selling_office_mlsid] => Array
(
[0] => SIRI
)
[rets_selling_office_mui] => Array
(
[0] => 9746287
)
[rets_selling_office_name] => Array
(
[0] => Portfolio
)
[rets_selling_office_phone] => Array
(
[0] => (808) 735-5585
)
[_thumbnail_id] => Array
(
[0] => 22589446
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446