@Test
 public void testGetResidential() throws SQLException {
   rp = new ResidentialProperty();
   rp.setPropertyId(100);
   ResultSet rs = rp.getResidential();
   assertNotNull(rs);
   if (rs.next()) {
     assertEquals(15, rs.getLong("specificationid"));
   }
 }