SELECT C_L_Keyword5,C_LM_Char10_14,C_LM_Char10_26,C_LM_char10_59,C_LM_char10_60,C_L_ListOffice1, ListOfficePhone, C_LO1_OrganizationName, C_LM_Char10_23, C_L_ListingID, Rentable, Neighborhood, C_LA1_AgentID, C_L_ListingDate, C_L_PictureCount, C_L_StatusCatID, C_L_Status, C_L_Class, C_L_Type_, C_LM_char10_53, C_LM_char10_54, C_L_Address, C_L_Address2, C_L_AskingPrice, C_LM_Int4_18, C_LM_Dec_9, C_LM_char10_69, C_L_Area, C_L_SquareFeet, C_LM_Int4_17, C_L_NumAcres, C_LM_Char25_26, Christies FROM ( SELECT C_L_Keyword5,C_LM_Char10_14, C_LM_Char10_26,C_LM_char10_59,C_LM_char10_60,C_L_Status, C_L_ListOffice1, ListOfficePhone, C_LO1_OrganizationName, C_LM_Char10_23, C_L_ListingID, Rentable, Neighborhood, C_LA1_AgentID, C_L_ListingDate, C_L_PictureCount, C_L_StatusCatID, C_L_Class, C_L_Type_, C_LM_char10_53, C_LM_char10_54, C_L_Address, C_L_Address2, C_L_AskingPrice, C_LM_Int4_18, C_LM_Dec_9, C_LM_char10_69, C_L_Area, C_L_SquareFeet, C_LM_Int4_17, C_L_NumAcres, C_LM_Char25_26, Christies, C_L_SaleRent FROM maui_master UNION SELECT C_L_Keyword5,C_LM_Char10_14, C_LM_Char10_26,C_LM_char10_59, C_LM_char10_60,C_L_Status, C_L_ListOffice1, ListOfficePhone, C_LO1_OrganizationName, C_LM_Char10_23, C_L_ListingID, Rentable, Neighborhood, C_LA1_AgentID, C_L_ListingDate, C_L_PictureCount, C_L_StatusCatID, C_L_Class, C_L_Type_, C_LM_char10_53, C_LM_char10_54, C_L_Address, C_L_Address2, C_L_AskingPrice, C_LM_Int4_18, C_LM_Dec_9, C_LM_char10_69, C_L_Area, C_L_SquareFeet, C_LM_Int4_17, C_L_NumAcres, C_LM_Char25_26, Christies, '' AS C_L_SaleRent FROM maui_master_manual ) as t WHERE 1=1 AND C_L_Class IN ('Residential','SF w/Det Ohana or Cottage','SF w/Det Ohana','Single Family w/Att Ohana') AND Neighborhood = 'Keonekai Heights (Pacific Terrace)' AND AND C_L_StatusCatID != 'Sold' AND C_L_StatusCatID != 'Closed' AND C_L_StatusCatID != 'Expired' AND C_L_Status != 'PENDING - DO NOT SHOW' AND (C_L_Status != 'Canceled' OR C_L_StatusCatID='Active' OR C_L_StatusCatID='Pending') AND (C_L_SaleRent = '' OR C_L_SaleRent IS NULL) ORDER BY C_L_ListOffice1=2016 DESC, C_L_AskingPrice ASC

3 homes for sale in Keonekai Heights (Pacific Terrace),