Hawaiian Dream PropertiesHawaiian Dream Properties
 
Home
Property Search
Featured Listings
Vacation Rentals
Long-Term Rentals
Big Island INFO
Buyer/Seller Tips
About Our Office
Agent Roster
Your Home's Value
Interest Rates
Calculator
Local Schools
Apply Online
Owner's Link
Community Profile
Consumer Links
Local Partners
Free Reports
Real Estate News
Contact Form
 
  Previous Property  |  Back To Listings  |  Next Property  
Turn key with ocean views
Property Info
$329,000
68-1745 WAIKOLOA RDK-212
Waikoloa, Hawaii 96738
MLS #: 227194
Agent
Scott Hawkins

Direct Number: (808) 883-9550
Email:
Broker info
Jim Albone

Description
This is a rare ocean facing 3 bedroom 3 bath offering in the Waikoloa Greens.
Being a corner unit this second floor two story apartment has extra windows for added light and ventilation. It also boasts many upgrades including granite counter tops wood laminate floors and a renovated kitchen. Ocean and year round sunset views abound from your living room and covered lanai. It is currently in a vacation rental program and is being offered turn key furnished.
Full Property Info
PropertyType  Condo
MLS#  227194
Year Built  1990
Bedrooms  3
Bathrooms  3
Square Feet  1292
Stories  2
Parking  2
Floors  3
  • Balcony
  • CC & R
  • Golf Community
  • Pool
  • BBQ
  • Fitness Center
  • Laminate Flooring
  • Tennis Court
  • Beds
  • Furnished
  • Ocean View
  • Washer/Dryer
  • Dishwasher
  • Garbage Disposal


  • Data provided by eNeighborhoods © 2010
    In partnership with Advanced Access
    Data provided by eNeighborhoods © 2010
    Nation’s Premier Provider of Neighborhood Data
    Legend
    Private School
    Public School

    Schools
    # School Address Phone Dist

    01
    WAIKOLOA ELEMENTARY SCHOOL
    Grades PK Thru 06
    68-1730 HOOKO ST
    WAIKOLOA, HI 96738
    (808)883-6808 1.54  Mi.

    02
    Waimea Community Montessori SCH.
    Grades PK Thru KG
    65 1297 OPELO ROAD
    Kamuela, HI 96743
    8088856867 7.59  Mi.

    03
    WEST HAWAII EXPLORATIONS ACADEMY - PCS
    Grades 07 Thru 12
    73-4460 QUEEN KAAHUMANU HWY
    KAILUA-KONA, HI 96740
    (808)327-4751 8.88  Mi.

    04
    Hawaii Montessori
    Grades PK Thru 6
    64-1061 Mamalahoa Hwy Suite 201
    Kamuela, HI 96743
    808-885-4141 9.39  Mi.

    05
    KANU O KA AINA - NEW CENTURY PCS
    Grades PK Thru 12
    65-1170 OPELO RD
    KAMUELA, HI 96743
    (808)887-8144 9.79  Mi.

    06
    WAIMEA ELEMENTARY SCHOOL
    Grades PK Thru 05
    67-1225 MAMALAHOA HWY
    KAMUELA, HI 96743
    (808)887-7636 9.83  Mi.

    07
    WAIMEA MIDDLE - PCCS
    Grades 06 Thru 08
    67-1229 MAMALAHOA HWY
    KAMUELA, HI 96743
    (808)887-6090 10  Mi.

    08
    Parker School
    Grades 7 Thru 12
    65 1224 Lindsey Rd
    Kamuela, HI 96743
    8088857933 10.12  Mi.

    09
    Hawaii PREP. Academy
    Grades KG Thru 12
    65-1692 Kohala Mountain Rd
    Kamuela, HI 96743
    8088814082 13.94  Mi.

    10
    KOHALA MIDDLE SCHOOL
    Grades 06 Thru 08
    PO BOX 777
    KAPAAU, HI 96755
    (808)889-7119 18.98  Mi.

    11
    KOHALA ELEMENTARY SCHOOL
    Grades PK Thru 05
    PO BOX 819
    KAPAAU, HI 96755
    (808)889-7100 18.98  Mi.

    12
    Kohala Mission School
    Grades 1 Thru 8
    PO Box 99 Akoni Puli Hwy
    Hawi, HI 96719
    8088895646 21.21  Mi.

    13
    PAAUILO ELEMENTARY & INTERMEDIATE SCHOOL
    Grades PK Thru 09
    PO BOX 329
    PAAUILO, HI 96776
    (808)776-7710 21.21  Mi.

    14
    KOHALA HIGH SCHOOL
    Grades 09 Thru 12
    PO BOX 279
    KAPAAU, HI 96755
    (808)889-7117 21.24  Mi.

    15
    KEALAKEHE ELEMENTARY SCHOOL
    Grades PK Thru 05
    74-5118 KEALAKAA ST
    KAILUA-KONA, HI 96740
    (808)327-4308 21.67  Mi.

    16
    KEALAKEHE INTERMEDIATE SCHOOL
    Grades 06 Thru 08
    74-5062 ONIPAA ST
    KAILUA-KONA, HI 96740
    (808)327-4314 21.76  Mi.

    17
    KEALAKEHE HIGH SCHOOL
    Grades 09 Thru 12
    74-5000 PUOHULIHULI ST
    KAILUA-KONA, HI 96740
    (808)327-4300 22.54  Mi.

    18
    HONOKAA HIGH & INTERMEDIATE SCHOOL
    Grades 07 Thru 12
    45-527 PAKALANA ST
    HONOKAA, HI 96727
    (808)775-8800 23.33  Mi.

    19
    HONOKAA ELEMENTARY SCHOOL
    Grades PK Thru 06
    45-534 PAKALANA ST
    HONOKAA, HI 96727
    (808)775-8820 23.33  Mi.

    20
    Kona Christian Academy
    Grades KG Thru 8
    74 4907 PALANI RD
    Kailua Kona, HI 96745
    8083293093 23.35  Mi.

    21
    HOLUALOA ELEMENTARY SCHOOL
    Grades PK Thru 05
    76-5957 MAMALAHOA HWY
    HOLUALOA, HI 96725
    (808)322-4800 23.61  Mi.

    22
    INNOVATIONS - PCS
    Grades 01 Thru 07
    75-5815 QUEEN KAAHUMANU HWY
    KAILUA-KONA, HI 96740
    (808)327-6205 24.98  Mi.

    23
    KAHAKAI ELEMENTARY SCHOOL
    Grades PK Thru 05
    76-147 ROYAL POINCIANA DR
    KAILUA-KONA, HI 96740
    (808)327-4313 24.98  Mi.

    24
    Makua Lani Christian School
    Grades 9 Thru 12
    74-4947 Mamakhoa Hwy
    Holualoa, HI 96725
    8083294898 24.99  Mi.

    25
    Hualalai Academy
    Grades KG Thru 8
    78 7156 Puuloa Rd
    Kailua Kona, HI 96740
    8083269866 27.37  Mi.

    26
    Kona Pacific School
    Grades PK Thru 7

    Kealakekua, HI 96750
    8083247224 29.23  Mi.

    27
    KONAWAENA MIDDLE SCHOOL
    Grades 06 Thru 08
    81-1045 KONAWAENA SCHOOL RD
    KEALAKEKUA, HI 96750
    (808)323-4566 29.99  Mi.

    28
    KE KULA O EHUNUIKAIMALINO
    Grades PK Thru 12
    81-1041 KONAWAENA SCHOOL RD
    KEALAKEKUA, HI 96750
    (808)323-1900 29.99  Mi.

    29
    KONAWAENA ELEMENTARY SCHOOL
    Grades PK Thru 05
    81-901 ONOULI RD
    KEALAKEKUA, HI 96750
    (808)323-4555 29.99  Mi.

    30
    Kona Adventist School
    Grades KG Thru 8
    School St. PO Box 739
    Captain Cook, HI 96704
    8083232788 38.18  Mi.
    school_AddPushpin(new VELatLong(19.94898,-155.79154),"WAIKOLOA ELEMENTARY SCHOOL","68-1730 HOOKO ST","(808)883-6808","Grades PK - 06","629 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","01"); school_AddPushpin(new VELatLong(19.982817,-155.687916),"Waimea Community Montessori SCH.","65 1297 OPELO ROAD","8088856867","Grades PK - KG","0 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","02"); school_AddPushpin(new VELatLong(19.86379,-155.90752),"WEST HAWAII EXPLORATIONS ACADEMY - PCS","73-4460 QUEEN KAAHUMANU HWY","(808)327-4751","Grades 07 - 12","131 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","03"); school_AddPushpin(new VELatLong(20.01193,-155.67573),"Hawaii Montessori","64-1061 Mamalahoa Hwy Suite 201","808-885-4141","Grades PK - 6","120 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","04"); school_AddPushpin(new VELatLong(20.02454,-155.67936),"KANU O KA AINA - NEW CENTURY PCS","65-1170 OPELO RD","(808)887-8144","Grades PK - 12","152 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","05"); school_AddPushpin(new VELatLong(20.02095,-155.67507),"WAIMEA ELEMENTARY SCHOOL","67-1225 MAMALAHOA HWY","(808)887-7636","Grades PK - 05","644 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","06"); school_AddPushpin(new VELatLong(20.02253,-155.6731),"WAIMEA MIDDLE - PCCS","67-1229 MAMALAHOA HWY","(808)887-6090","Grades 06 - 08","459 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","07"); school_AddPushpin(new VELatLong(20.021205,-155.66931),"Parker School","65 1224 Lindsey Rd","8088857933","Grades 7 - 12","170 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","08"); school_AddPushpin(new VELatLong(20.12837,-155.7945),"Hawaii PREP. Academy","65-1692 Kohala Mountain Rd","8088814082","Grades KG - 12","620 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","09"); school_AddPushpin(new VELatLong(20.2014,-155.7864),"KOHALA MIDDLE SCHOOL","PO BOX 777","(808)889-7119","Grades 06 - 08","208 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","10"); school_AddPushpin(new VELatLong(20.2014,-155.7864),"KOHALA ELEMENTARY SCHOOL","PO BOX 819","(808)889-7100","Grades PK - 05","404 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","11"); school_AddPushpin(new VELatLong(20.231324,-155.829095),"Kohala Mission School","PO Box 99 Akoni Puli Hwy","8088895646","Grades 1 - 8","33 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","12"); school_AddPushpin(new VELatLong(19.871,-155.4676),"PAAUILO ELEMENTARY & INTERMEDIATE SCHOOL","PO BOX 329","(808)776-7710","Grades PK - 09","241 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","13"); school_AddPushpin(new VELatLong(20.2338,-155.803),"KOHALA HIGH SCHOOL","PO BOX 279","(808)889-7117","Grades 09 - 12","283 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","14"); school_AddPushpin(new VELatLong(19.67456,-155.98625),"KEALAKEHE ELEMENTARY SCHOOL","74-5118 KEALAKAA ST","(808)327-4308","Grades PK - 05","1003 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","15"); school_AddPushpin(new VELatLong(19.67408,-155.98765),"KEALAKEHE INTERMEDIATE SCHOOL","74-5062 ONIPAA ST","(808)327-4314","Grades 06 - 08","909 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","16"); school_AddPushpin(new VELatLong(19.67133,-156.0036),"KEALAKEHE HIGH SCHOOL","74-5000 PUOHULIHULI ST","(808)327-4300","Grades 09 - 12","1638 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","17"); school_AddPushpin(new VELatLong(20.07618,-155.46638),"HONOKAA HIGH & INTERMEDIATE SCHOOL","45-527 PAKALANA ST","(808)775-8800","Grades 07 - 12","837 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","18"); school_AddPushpin(new VELatLong(20.07618,-155.46638),"HONOKAA ELEMENTARY SCHOOL","45-534 PAKALANA ST","(808)775-8820","Grades PK - 06","385 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","19"); school_AddPushpin(new VELatLong(19.648196,-155.991296),"Kona Christian Academy","74 4907 PALANI RD","8083293093","Grades KG - 8","0 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","20"); school_AddPushpin(new VELatLong(19.62176,-155.95145),"HOLUALOA ELEMENTARY SCHOOL","76-5957 MAMALAHOA HWY","(808)322-4800","Grades PK - 05","471 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","21"); school_AddPushpin(new VELatLong(19.61354,-155.97978),"INNOVATIONS - PCS","75-5815 QUEEN KAAHUMANU HWY","(808)327-6205","Grades 01 - 07","152 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","22"); school_AddPushpin(new VELatLong(19.61354,-155.97978),"KAHAKAI ELEMENTARY SCHOOL","76-147 ROYAL POINCIANA DR","(808)327-4313","Grades PK - 05","562 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","23"); school_AddPushpin(new VELatLong(19.597727,-155.947137),"Makua Lani Christian School","74-4947 Mamakhoa Hwy","8083294898","Grades 9 - 12","75 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","24"); school_AddPushpin(new VELatLong(19.55804,-155.9412),"Hualalai Academy","78 7156 Puuloa Rd","8083269866","Grades KG - 8","90 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","25"); school_AddPushpin(new VELatLong(19.522822,-155.921033),"Kona Pacific School","","8083247224","Grades PK - 7","0 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","26"); school_AddPushpin(new VELatLong(19.51161,-155.9215),"KONAWAENA MIDDLE SCHOOL","81-1045 KONAWAENA SCHOOL RD","(808)323-4566","Grades 06 - 08","415 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","27"); school_AddPushpin(new VELatLong(19.51161,-155.9215),"KE KULA O EHUNUIKAIMALINO","81-1041 KONAWAENA SCHOOL RD","(808)323-1900","Grades PK - 12","173 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","28"); school_AddPushpin(new VELatLong(19.51161,-155.9215),"KONAWAENA ELEMENTARY SCHOOL","81-901 ONOULI RD","(808)323-4555","Grades PK - 05","584 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmSPlDniyh4sru8Ld4pcaIBj_WEgP0cus0qwWOMUW_mgg1&t=634181820949337133","29"); school_AddPushpin(new VELatLong(19.381199,-155.879156),"Kona Adventist School","School St. PO Box 739","8083232788","Grades KG - 8","11 Students","/WebResource.axd?d=7RnRiFCSZ2c5abBXZMBuU_QYIUCJrQVkWE7_ihXbb-l7ytYKNwyoVKXv34vWr1VmeQxJY0S32JyeJn8Mx1UxENUMXzvXJbZ0mKwOkNc0HhM1&t=634181820949337133","30");


    Data provided by eNeighborhoods © 2010
    In partnership with Advanced Access
    Data provided by eNeighborhoods © 2010
    Nation’s Premier Provider of Neighborhood Data

    Real Estate Websites by Advanced Access © 1998-2010