public static List<Cottage> getAllCottages(boolean refresh) throws SQLException
    {
	if (!refresh)
	{
	    if (staticCottages != null)
		return staticCottages;
	}
	List<Cottage> cottages = new ArrayList<Cottage>();
	List<Zip> zips = ZipConnect.getAllZip(false);
	List<CottageType> types = getAllCottageTypes();
	String sql = "SELECT * FROM cottage order by id";
	Connection conn = DBConnect.getConnection();
	PreparedStatement p = conn.prepareStatement(sql);
	ResultSet rs = p.executeQuery();

	while (rs.next())
	{
	    int id = rs.getInt(1);
	    String name = rs.getString(2);
	    String street = rs.getString(3);
	    String houseNumber = rs.getString(4);
	    int zipCode = rs.getInt(5);
	    int cottageType = rs.getInt(6);
	    Zip zip = null;
	    CottageType type = null;
	    for (Zip z : zips)
	    {
		if (z.getZipCode() == zipCode)
		{
		    zip = z;
		}
	    }
	    for (CottageType t : types)
	    {
		if (t.getCottageTypeId() == cottageType)
		{
		    type = t;
		}
	    }
	    Cottage cottage = new Cottage(id, type, name, street, houseNumber, zip);
	    cottages.add(cottage);
	}

	return cottages;
    }